Hi,
Thanks for your response.
http://www.2shared.com/document/MVZOO_95/Dashboard.html
This is my sample work sheet. I want individual salary head total. I am using excel template to generate my report. I can directly dump data into template sheet like sample one. And it must automatically...
Thanks Faseeh..
But it is not sure that my data will remain in the range A1:G5. It may cross. I can work with SUBTOTAL to get column sum if i could know columns prior. But it may vary according to employees. In such condition how can i set that formula. Here i am stuck with..;(
tWiN..
Okay. Let me explain
500k
Basic Pay .....................
200k ..............
300k ..............
This is my data format. Here Column fields are (Salary head) not pre determinate. Dynamically increasing column fields. But i want total spent for...
Hi,
I am working with excel dashboard reports. But i am stuck with excel dynamic list.
I do have a list with dynamically growing column field.
Say Column1, Column2,..... This Column number is indeterminate. It depends on user input.
As column number grows i want to print sum of each column...