Combine 7 files then create 1 master
 

I have to combine 7 worksheets from 7 files on my desktop into 1
workbook - then create 1 worksheet of all the data in this same
workbook except the column header row 1. I tried doing a recording to
make my own macro but I get an error when trying to copy the sheet to
the workbook and sheet.

what do I use to copy the data to a new workbook/worksheet

Copy Befo=Workbooks("Book2").Sheets(1)

This doesn't work....so I want to try and figure this out.

Thanks!!

Combine 7 files then create 1 master
 

Try asking in microsoft.public.excel.programming

On Aug 5, 3:00*pm, Snailspace wrote:
I have to combine 7 worksheets from 7 files on my desktop into 1
workbook - then create 1 worksheet of all the data in this same
workbook except the column header row 1. *I tried doing a recording to
make my own macro but I get an error when trying to copy the sheet to
the workbook and sheet.

what do I use to copy the data to a new workbook/worksheet

Copy Befo=Workbooks("Book2").Sheets(1)

This doesn't work....so I want to try and figure this out.

Thanks!!

Combine 7 files then create 1 master
 

Hi

Ron de Bruin has lots of code for achieving this on his site.
http://www.rondebruin.nl/tips.htm

--
Regards
Roger Govier

"Snailspace" wrote in message
...
I have to combine 7 worksheets from 7 files on my desktop into 1
workbook - then create 1 worksheet of all the data in this same
workbook except the column header row 1. I tried doing a recording to
make my own macro but I get an error when trying to copy the sheet to
the workbook and sheet.

what do I use to copy the data to a new workbook/worksheet

Copy Befo=Workbooks("Book2").Sheets(1)

This doesn't work....so I want to try and figure this out.

Thanks!!