View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NateBuckley NateBuckley is offline
external usenet poster
 
Posts: 146
Default 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