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 |
#2
|
|||
|
|||
Paul,
In the sheet/cells that you want to extract the values type in an equal sign (=) and then go to the sheet/cells that have the values, highlist them and then press enter. When you go back to original sheet you will see that it has put extract range and sheet name. HTH Pank "Paul Reeve" wrote: 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 |
Reply |
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 |