Copying data based on cell value

[mluetkem]

How can you copy a block of data (cells G3:AK50) into another workshee
based on a cell value? I have a workbook with 4 worksheets, 3 of whic
contain data for 3 separate months. So they are basically formatte
exactly the same but with different data in the G3:AK50 range. Th
fourth worksheet is used to perform calculations on the selecte
worksheets data (1 thru 3). So based on a value of a cell in the 4t
worksheet I want to automatically populate that worksheets dat
(G3:AK50) into the 4th worksheet. Any quick ideas?

Mik

 

[Bernie Deitrick]

Mike,

On your 4th sheet, in cell G3, enter the formula

=INDIRECT("'" & $A$1 & "'!" & ADDRESS(ROW(),COLUMN()))

and copy it to G3:AK50.

Then in cell A1, type in the name of the worksheet whose data you want to
view.

HTH,
Bernie
MS Excel MVP

 

[Ron de Bruin]

You can use indirect

with a sheet name in A1
=INDIRECT($A$1 & "!G3")