N
Nutan Nayee
Hi I hope you can help!
I have a large excel spreadsheet showing 150 projects, for thes
projects there are then 5 coloums showing spend, budget, actual cos
etc, the information in these coloums is fed from another shee
containing the data.
My problem is that I have to go in an manually put in formulas to pic
up data from the back sheet, i cant copy the formula down as th
projects reported on changes month by month, is there a quick way fo
fill formulas down, maybe a look up or something?
regard
I have a large excel spreadsheet showing 150 projects, for thes
projects there are then 5 coloums showing spend, budget, actual cos
etc, the information in these coloums is fed from another shee
containing the data.
My problem is that I have to go in an manually put in formulas to pic
up data from the back sheet, i cant copy the formula down as th
projects reported on changes month by month, is there a quick way fo
fill formulas down, maybe a look up or something?
regard