cut and paste or something more elaborate?
 

Folks,

Can you help me make my mind up on how to go about moving small blocks
of data from nearly 88 worksheets to one central worksheet. I'm trying
to learn excel and VBA and I've found some examples using small
snippets of code to write values from one cell to another. I thought
this might be a good excuse to try and expand my horizons beyond the
cut-and-paste operations. I will be moving data from 88 different
worksheets in 5 workbooks to a single worksheet. Once the data are
copied, I will have need to maintain the original worksheets (in case
that matters). Also, I might mention that the range of cells that I
want to grab will be identical, or nearly so in all 88 worksheets.


Any suggestions on how I might go about this would be greatly
appreciated.


Regards,


Mike

cut and paste or something more elaborate?
 

Hi

See
http://www.rondebruin.nl/tips.htm

Maybe
http://www.rondebruin.nl/copy3tip.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Takeadoe" wrote in message ...
Folks,

Can you help me make my mind up on how to go about moving small blocks
of data from nearly 88 worksheets to one central worksheet. I'm trying
to learn excel and VBA and I've found some examples using small
snippets of code to write values from one cell to another. I thought
this might be a good excuse to try and expand my horizons beyond the
cut-and-paste operations. I will be moving data from 88 different
worksheets in 5 workbooks to a single worksheet. Once the data are
copied, I will have need to maintain the original worksheets (in case
that matters). Also, I might mention that the range of cells that I
want to grab will be identical, or nearly so in all 88 worksheets.


Any suggestions on how I might go about this would be greatly
appreciated.


Regards,


Mike