Thread: Copy Workbooks and Paste into same spreadsheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lcannon lcannon is offline
external usenet poster
  
Posts: 1
Default Copy Workbooks and Paste into same spreadsheet

I have several Workbooks I need to copy from and paste into one
spreadsheet.

Say Template1, Template2, Template3

All with the same columns and all starting on the same row and just
pasted in the new spreadsheet on the next blank row. How can I do this
adding onto the macro below? Thanks.


Workbooks.Open Filename:= _
"C:\Documents and Settings\My Documents\template1.xls"
Range("A5:R61").Select
Selection.Copy
Windows("MyFile.xls").Activate
Range("A5").Select
ActiveSheet.Paste
End Sub


--
lcannon
------------------------------------------------------------------------
lcannon's Profile: http://www.excelforum.com/member.php...o&userid=24253
View this thread: http://www.excelforum.com/showthread...hreadid=378627

Reply With QuoteReply With Quote