Copy Excel workbook to Excel template

[George53]

I have been doing the same thing for years, copying and pasting excel worksheets from this one workbook to an excel template which has had the columns renamed in order to upload into an access database. The original excel worksheet does have some fields at the bottom called subtotal that are removed in the template but apart from that and the renamed columns it stays the same. There are about 20 sheets that I move to 20 sheets in the template.

The question is, is there an easier way to do this? Although I am probably too old to learn anything new now. But, there is that saying about an old dog.
Thanks

 

[Logit]

Well ... if you are copying and pasting those sheets manually (one by one, using your mouse) ... then yes, you can use some vba code in a macro to automate the process.
Plenty of examples on this forum and the internet.

 

[George53]

Well ... if you are copying and pasting those sheets manually (one by one, using your mouse) ... then yes, you can use some vba code in a macro to automate the process.
Plenty of examples on this forum and the internet.

Could you point me in the right direction of these examples? I would be very grateful. Also what is the best way to learn how to do vba. Sorry, I am an oldie. I am going along the it’s never to late to learn approach. Thank you!

 

[Logit]

How to copy sheets to another workbook using vba?

VBA Copy Sheet / Copy Sheet to Another Workbook

VBA - copy sheet from another workbook to current workbook

 

[George53]

How to copy sheets to another workbook using vba?

VBA Copy Sheet / Copy Sheet to Another Workbook

VBA - copy sheet from another workbook to current workbook

Awesome thank you!

 

[Logit]

That should give you a start. When you run into problems ... post back again. Someone will assist.