Make a copy of a sheet and add it into a new workbook?
Hello, I know how to copy and paste data from one sheet to another with ranges
but I'm just wondering if there is an easier way by simply stating something
like
Workbooks("Backup.xls").Sheets("Data") =
Workbooks("Project.xls").Sheets("Data")
Thanks in advance!!
Nate
|