cut and paste or something more elaborate

T

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
 
G

gs

you could use vba in loops. One word of caution, you want to consider the
final size of the work book, the RAM of your PC. The resultant excel
workbook could be too wieldy or complex for your PC and office version(
especially if lots of formulae)

Also be careful when copying formulae.

office 97 excel had tendency to corrupt with large workbook. XP seems to do
better.

for really large amount of data, you may want to use some database to store
the actual data and use excel as front end
 
Y

York

Why copy and paste when you can import data ?
Leave your data where it is.

Let Excel read it and diplay it in whatever sheet you want.
Then tell Excel that it should automatically re read the base data say every
10 minutes.
That's not VBA, that's in the options.
When your base data is modified then your displayed data will automatically
update.

Go to the menu
then Data, then import data.
OK. It is tricky. More elaborate. There is a learning curve.
But once you have mastered it there is a time saving curve too.
Get some help on that.
That'll expand your horizons ! : )

York.
 
Top