Return Values in a specific column
 

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.

Return Values in a specific column
 

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

On Aug 12, 9:09*pm, Eric H wrote:
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.

Return Values in a specific column
 

Thanks Pete!

"Pete_UK" wrote:

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

On Aug 12, 9:09 pm, Eric H wrote:
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.

Return Values in a specific column
 

You're welcome, Eric - thanks for feeding back.

Pete

On Aug 13, 1:51*am, Eric H wrote:
Thanks Pete!