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.
|