Return Values in a specific column

E

Eric H

I have a workbook containing multiple worksheets. In each worksheet, I have
some data in cells under column L. I wish to return all data residing in
column L in every worksheet back to a designated worksheet with in the same
workbook.
 
P

Pete_UK

Put the names of the worksheets in A1, B1, C1, D1 etc, then put this
formula in A2:

=INDIRECT("'"&A$1&"'!L"&ROW($A1))

Then copy this across to the other cells in row 2 - it will bring data
from L1 of each sheet, but if you wanted it to start with L5, for
example, just change to ROW($A5).

Then you can copy the row of formulae down for as many rows as you
need.

Hope this helps.

Pete
 
E

Eric H

Thanks Pete!

Pete_UK said:
Put the names of the worksheets in A1, B1, C1, D1 etc, then put this
formula in A2:

=INDIRECT("'"&A$1&"'!L"&ROW($A1))

Then copy this across to the other cells in row 2 - it will bring data
from L1 of each sheet, but if you wanted it to start with L5, for
example, just change to ROW($A5).

Then you can copy the row of formulae down for as many rows as you
need.

Hope this helps.

Pete
Click to expand...
 
Top