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, 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, 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...
Thanks Narayan. It is working. But everytime I have to open the external file to refresh the data. Is there any other way, where the data will be refreshed automatically withouth opening the external file?
Regards
Jay
Hi Narayan,
Yes, I am using the sheet name selected in the drop-down in a formula.I copy pasted the formula above at the beginning of this converstaion. again copying the same below.
='C:UsersjsarangiDocumentsFNNFY 2000Q2Working Files1 23 2000[FY13 Q3 Fnn Quarty Comson (01 23...
Actually, I am linking one file to another with a drop down of sheet name. That is, as I choose a name from the drop down the link should move to another sheet. the sheet name and the drop down list are the same.
The cell may contain both numeric and text.
Let me know if you need any further...