Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transferring monthly figures to summary tab
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transferring monthly figures to summary tab
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 --- "Tucker" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transferring data from multiple worksheets to a Summary sheet | Excel Discussion (Misc queries) | |||
Transferring data from one wksht to another (detail and summary) | Excel Discussion (Misc queries) | |||
Converting Monthly figures to Quarters | Excel Discussion (Misc queries) | |||
Calculating a YTD figures from changing monthly figure. | Excel Discussion (Misc queries) | |||
sum monthly to get quarterly figures | Excel Programming |