cut and paste or something more elaborate?

[Takeadoe]

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

[Ron de Bruin]

Hi

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

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


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


"Takeadoe" <[email protected]> wrote in message news:[email protected]...
> 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
>
>
>