Transferring monthly figures to summary tab

[Tucker]

Hi All,

I have a workbook with about 8 tabs. This all contain a list of staff
members and months of the year. Each tab is for a different performance
indicator (minutes late, errors, handling time etc).
I'm trying to create a summary tab where I can enter the month in a cell and
have only the data for that month from each tab copy to this tab.

Does anyone have any ideas? I have seen this done before.

 

[Max]

INDIRECT probably holds the key for you here

In your summary sheet,
Assume your source sheetnames are listed in A2 down
(Sheetnames must match exactly with what's on the tabs, except for case)
Assume the key cell refs to be extracted from each source sheet
are listed in B1 across, eg: B2, E5, etc
Put in B2: =INDIRECT("'"&$A2&"'!"&B$1)
Copy B2 across/fill down to populate the required extracts in one fell swoop

Celebrate your success, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik