combining data from separate sheets into one

  • Thread starter Thread starter ajohns
  • Start date Start date
A

ajohns

Greetings

I would be grateful if someone could start me off on a macro to
combine data (size variable) from a number of sheets (number unknown)
from a single file. The data will always start in the same cell, A6.

Many thanks

Yours

Andrew j
Fife
 
Can you be a bit more specific on what exactly do you want
to do? Do you want to, say, add the values of cell A6 in
all sheets in A6 in a totals sheet, or something like
this? Do you want to do this for a range of cells? Does
your totals sheet have a specific name (so it can be
excluded from the summation?

Nikos Y.
 
Nikos Yannacopoulos said:
Can you be a bit more specific on what exactly do you want
to do? Do you want to, say, add the values of cell A6 in
all sheets in A6 in a totals sheet, or something like
this? Do you want to do this for a range of cells? Does
your totals sheet have a specific name (so it can be
excluded from the summation?
Click to expand...


I do not know how big the range will be in each sheet, it is likely to vary.

I would like to arrange all the active cells from each sheet onto a single
sheet.


Andrew J
Fife
 
Back
Top