Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional extract from external worksheets
Hi
I have had a workbook foisted on me which is to be distributed to my managers and it has 52 sheets in the form wk 1, wk2.....wk 52 etc. I need to be able to pull in the weekly data for the workbooks they forward and these will include all weeks. I have done stuff like this before using lookup but that will only work if the data is in a continuous array I guess? What I would like to be able to do on the collation sheet is put a week number into a cell and have it populate the collation sheet with the totals from the various returns. All the return sheets are structured identically, I'm sure I could do this in a long winded and cack handed way but I'm hoping there will be a nice, elegant and time saving way!! All suggestions gratefully received!! Peter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save External Link Values | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Conditional hiding of worksheets | Excel Discussion (Misc queries) |