Combine Worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

William@Target - 08 Mar 2007 20:28 GMT

I have 13 worksheets, same workbook and same column titles. Looking to
combine all 13 worksheets into 1 master worksheet. Anyone know how?

Reply to this Message

Wood Grafing - 08 Mar 2007 20:35 GMT

If you aren't going to be doing the same thing repeatedly, then why spend
time writing code to do it?

Delete the title rows in the ones to be copied, select all, paste at the
bottom of the receiving sheet. Rinse and repeat as needed.

> I have 13 worksheets, same workbook and same column titles. Looking to
> combine all 13 worksheets into 1 master worksheet. Anyone know how?

Reply to this Message

Ron de Bruin - 08 Mar 2007 21:19 GMT

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

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

>I have 13 worksheets, same workbook and same column titles. Looking to
> combine all 13 worksheets into 1 master worksheet. Anyone know how?

Reply to this Message