Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup from a range on separate sheets
Hi,
I am trying to look up values from the same fixed range (c50:E200) in 45 sheets and extract the values onto one sheet (same workbook) 3 columns at a time (ie first sheet B-D, second sheet E-G etc). I can't work out how to put the sheet name (or a reference to the sheet number) in a formula in the destination sheet - is it possible or do I have to use a macro? I can write the code for a macro, but as it is statistical process control limits which are added to each month, it means rerunning the macro every time Any help much appreciated! Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range Lookup? Is there such a thing like this? | Excel Worksheet Functions | |||
How do I save sheets in a workbook to separate files? | Excel Worksheet Functions | |||
set or reset the print range for several sheets at a time? | Excel Discussion (Misc queries) | |||
Printing separate sheets on one paper sheet | Excel Discussion (Misc queries) | |||
Sum a range across multiple sheets | Excel Worksheet Functions |