Copy Excel workbook to Excel template

George53

New Member
Joined
Feb 28, 2021
Messages
3
Office Version
  1. 2016
Platform
  1. Windows
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
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
4,013
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

New Member
Joined
Feb 28, 2021
Messages
3
Office Version
  1. 2016
Platform
  1. Windows
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

Well-known Member
Joined
Aug 31, 2016
Messages
4,013
That should give you a start. When you run into problems ... post back again. Someone will assist.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,026
Messages
5,639,615
Members
417,101
Latest member
amoverton2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top