G
Guest
Hi,
I have a workbook containing 50+ worksheets in the same format, with the
same information calculated for each individual client.
What I need to do is copy specific information (which is always in the same
cells in each worksheet) into one definitive list. Is there an easy way of
doing this?
For E.g.
I have 4 worksheets labelled client A, B, C & D
in each worksheet, cell B1 contains client name
cell F29 contains fist line of address
cell L10 contains the charge rate
Is it possible to have one worksheet with the information in cells B1, F29
and L10 in 3 adjacent columns in a list of the 4 clients?
Hope this makes sense.
Many thanks,
HS
I have a workbook containing 50+ worksheets in the same format, with the
same information calculated for each individual client.
What I need to do is copy specific information (which is always in the same
cells in each worksheet) into one definitive list. Is there an easy way of
doing this?
For E.g.
I have 4 worksheets labelled client A, B, C & D
in each worksheet, cell B1 contains client name
cell F29 contains fist line of address
cell L10 contains the charge rate
Is it possible to have one worksheet with the information in cells B1, F29
and L10 in 3 adjacent columns in a list of the 4 clients?
Hope this makes sense.
Many thanks,
HS