combine data from multiple worksheet
 

I was working on a workbook with 50 worksheet and in each sheet I have
got about 700 lines of data (or 700 rows). These data are
cross-referenced with formulas.

What I need to do is to combine all data from all worksheets into one
single worksheet, or a sheer with ~35,000 lines. I can do this with
building copy/paste macros in Excel but I believe there would be much
easier ways to achieve this.

Can anyone help me this out?

Thanks. :confused:


--
prague
------------------------------------------------------------------------
prague's Profile: http://www.excelforum.com/member.php...o&userid=30172
View this thread: http://www.excelforum.com/showthread...hreadid=498559

combine data from multiple worksheet
 

Hi

Try this
http://www.rondebruin.nl/copy2.htm


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


"prague" wrote in message
...

I was working on a workbook with 50 worksheet and in each sheet I have
got about 700 lines of data (or 700 rows). These data are
cross-referenced with formulas.

What I need to do is to combine all data from all worksheets into one
single worksheet, or a sheer with ~35,000 lines. I can do this with
building copy/paste macros in Excel but I believe there would be much
easier ways to achieve this.

Can anyone help me this out?

Thanks. :confused:


--
prague
------------------------------------------------------------------------
prague's Profile: http://www.excelforum.com/member.php...o&userid=30172
View this thread: http://www.excelforum.com/showthread...hreadid=498559