Hi there
I have a number of different worksheets ("Divisions") with data i would like to pull into a summary worksheet ("Summary").
In the attached sample file, I would like to enhance the formula in cell F6 on the "Summary" worksheet, such that the formula will look for the data in the column in the selected "divisional" worksheets that correspond with the month in row 3 on the "Summary" worksheet
Please note that the formula only gets data from the Divisions that are selected on the "Selection" worksheet. In this example, only DivisionsA and B are selected.
My problem relates to the fact that there is no consistency in the columns used for the data on the Division worksheets. For example, "DivisionA" worksheet the 2006 Year numbers are in column F whereas "DivisionB" worksheet Year 2006 numbers are in column D etc. The row used for the "Year" criteria is consistent on all Division worksheets.
Hope this makes sense.
Thanks in advance for any assistance.
Regards
Peter
Bookmarks