Copying from multiple worksheets

G

GMP

I want to copy a cell (say A1) from multiple worsheets to a single sheet in
different cells (say A2 thru A15) using a formula.
 
P

Peo Sjoblom

if you have some system in the naming of the sheets with numbers like in the
default names (Sheet1, Sheet2 etc) it might be possible. Maybe you can post
back with more info about the sheet names, otherwise a macro would be the
only way


Regards,

Peo Sjoblom
 
G

GMP

The sheet names are Jan 2004, Feb 2004, etc. These are monthly financial
statements that I want to summarize on a single sheet (meaning side by side
not summed).
 
K

Ken Wright

Assuming 12 sheets named as per your example 'mmm 2004' with data in say
cells A1:A4 on each sheet to be returned to the summary sheet

Summary sheet:-
B1:M1 = Jan, Feb, Mar, Apr..........
A2:A5 = 1,2,3,4 (represent row numbers of data to be returned from each
sheet)

Cell B2 = =INDIRECT("'"&B$1&" 2004'!A"&$A2)
Copy across B2:M5 and all data will be returned. Dollar signs on the 1 and
the A simply lock those row and column references for when you copy the
formula across the other cells.

use same principle but adjust for your ranges
 
Top