Why don't you think it would work?

if the total number of rows don't exceed 65536, then you should be able to
do it with a macro.

Or you could try manual copy and paste, but if you can do that, a macro
should work as well.

--
Regards,
Tom Ogilvy

Dinesh wrote in message
...
Hi again:

I have 7 different data worksheets that need to be
compiled as one. I was wondering if there is a way to
automate this? I thought about using a Macro, but I'm not
sure if it would work in this case.

Again, your advise would be very greatly appreciated.

Regards,

Dinesh.