multiple worksheet data into 1 worksheet
 

i have a workbook with X number of sheets. I want to put all the data
from each sheet and copy/paste them into 1 worksheet with each set of
data one after another (going down in rows)..

i'm thinking of some sort of loop that will detect the number of sheets
and then copy and paste it into a new file

appreciate the help


--
narutard
------------------------------------------------------------------------
narutard's Profile: http://www.excelforum.com/member.php...o&userid=25111
View this thread: http://www.excelforum.com/showthread...hreadid=467186

multiple worksheet data into 1 worksheet
 

anyone?

thanks


--
narutard
------------------------------------------------------------------------
narutard's Profile: http://www.excelforum.com/member.php...o&userid=25111
View this thread: http://www.excelforum.com/showthread...hreadid=467186

multiple worksheet data into 1 worksheet
 

Hi narutard

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


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


"narutard" wrote in message
...

anyone?

thanks


--
narutard
------------------------------------------------------------------------
narutard's Profile: http://www.excelforum.com/member.php...o&userid=25111
View this thread: http://www.excelforum.com/showthread...hreadid=467186