hii guys..
I have got one file on which I update growth and outstanding on weekly basis. What i need is that on the basis of week, respective monthly and quarterly numbers should get automatically updated.
There are two major issues i am facing in doing so:-
1) How to identify last non blank cell and return value of the same
2) I need to report growth on cumulative basis and outstanding on as on basis. That means if i have updated values for first three weeks of April then growth number which will appear in April Month Column will be sum of growth of all weeks, however outstanding number will be of latest week.
File is attached at below link for further reference:-
https://docs.google.com/file/d/0B_ERYRYCgSUXRTUwQzhJWWl3LTg/edit?usp=sharing
Thanks in advance..
I have got one file on which I update growth and outstanding on weekly basis. What i need is that on the basis of week, respective monthly and quarterly numbers should get automatically updated.
There are two major issues i am facing in doing so:-
1) How to identify last non blank cell and return value of the same
2) I need to report growth on cumulative basis and outstanding on as on basis. That means if i have updated values for first three weeks of April then growth number which will appear in April Month Column will be sum of growth of all weeks, however outstanding number will be of latest week.
File is attached at below link for further reference:-
https://docs.google.com/file/d/0B_ERYRYCgSUXRTUwQzhJWWl3LTg/edit?usp=sharing
Thanks in advance..