Combining multiple worksheets into 1

[yorkieboy]

May have been asked before but here goes:
I have 7 worksheets all laid out the same but all contain different data.
How do I get a "summary" worksheet that has all the data from all the
worksheets. In the past have copied the data from each individual
worksheet and then pasted into a new worksheet but there has to be a better
way

Ahy help would be appreciated

 

[Ron de Bruin]

Try this yorkieboy

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

 

[yorkieboy]

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

Thanks for te tips but I cannot get it working
have pasted into visual basic and run but get compile error at "if
sheetexists" part
anymore help?????

 

[Ron de Bruin]

Hi yorkieboy

Read the part on the webpage about the functions.
You must copy them in a normal module for using them.