S
Snailspace
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 Before:=Workbooks("Book2").Sheets(1)
This doesn't work....so I want to try and figure this out.
Thanks!!
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 Before:=Workbooks("Book2").Sheets(1)
This doesn't work....so I want to try and figure this out.
Thanks!!