Lookup from a range on separate sheets

[Paul Reeve]

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

 

[Guest]

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