Search results

Is there a way to create parliament chart in excel?

Hello, Need some guidance in preparing Fibonacci chart in excel. Regards, Jay POST MOVED BY MOD

Hello, I need some suggestions on best chart/graph to put to show month end closed inventory and revenue days/DSO to gether with a comparison to prior year. Regards, Jay

Hello, Kindly guide me on how can I get lets say top 20% of the total clients on the basis of revenue in a pivot table. Regards Jay

Hello, How to have a dynamic data range for a bar chart. When I select an item from a drop down the data range should move to a corresponding row for the row header selected. Kindly help. Regards Jay

Hello, How I can add a customised tool bar in excel where all the clicks are vba enabled? Regards Jay

Hello, Please guide me on offset formula. Regards Jay

Hello, I have this below code. but everytime there is a change in color in the range, I have to press F2 then press enter to recalculate teh formula. Can you please guide me in fixing that issue so that whenever there is a change in color the formula recalculates automatically and I do not have...

Hello, I need some urgent help on the below explained. Link string - ='C:UsersjsarangiDocumentsFNNFY 2000Q2Working Files1 23 2000[FY13 Q3 Fnn Quarty Comson (01 23 2000).xlsm]Cypora'!$T$8 Need to give a cell reference to "Cypora (Sheet Name)" in the string. Kindly advise Regards Jay

Hello, Please find below the problem description. I have a line chart with marker. The position of the marker changes according to the change in data. I need your help in changing the color of the marker automatically as the data changes. Lets say the range is between (-5%) to 10%. If the...

Hello, Please let me know if there is anything wrong in the below code. Because after updating the file I have to press F2 to get the desired result. It does not update automatically which I want. Kindly advise. Regards Jay -----------------Code------------- Function Colorfunction(rColor As...

Is it possible to insert "AND/OR" function or a defined NAME range in sumifs? Please advise. Thanks Jay

Hello, Please advise me on VBA to print all active sheets in a excel file Regards Jay

Hello, Can we have both Label filters and value filters in pivot at the same time? Regards Jay

Hello, I need help on dynamic drop down. Below is the requirement. Cel A1, A2 and A3 contain 1,1 and 2 respectively. Cell B1, B2 and B3 contain A, B and C respectively. I want to have a drop down where I select 1 or 2 then in the next cell it will automatically show up the respective valude...

Hello, Is there any formula for below issue... Lets say - Cell A6 has yellow color, I want to write a formula in B6 having the logic - if cell A6 is yellow, then give me "Y" Kindly advise Jay

Is there any problem in the below code, its not moving to next sheet. Also please modify to exclude one tab and make the changes in all other active tabs. Its quite urgent. " Dim sh As Worksheet For Each sh In ActiveWorkbook.Worksheets Range("D2").Select ActiveCell.FormulaR1C1 =...

Hello, I need some help in writing a VBA. Detail expanation - Have two drop down lists in excel. One has all the column headers and the other has ascending or descending option. I need a VBA to sort the entire range of data depending on the inputs provided in the above mentioned two drop down...

Hello, I need some VBA help on the below requirement. I have two sheets. Sheet 1 has a name called "Jay" lets say. Sheet2 has a text string with Jay, lets say like " jfjhljafvl11/2/12Jay-ext kjdhj". My question is how to get the name "Jay" out of the string and put into next cell in next...