Creatng macro in sheet which opens up an existing template

C

Craigybaby31

New Member
Joined
Mar 29, 2011
Messages
1
Howdy folks , looking for some help, I'm new to this so be kind. I have a spread sheet which has a button which brings a window up so u can Fill in certain info. This is then placed within the spread sheet .Once complete I would like that button to open up a new template and save it as the info i just input in to the spread sheet. Sorry for the explanation but I'm new to excel and struggling to get to terms with the technical jargon . If that's not possible, a new macro button will do. Look forward to all the baffling suggestions lol
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
You must log in or register to reply here.

Similar threads

P
  • Question Question
Checking for Worksheets that already exist
2
Replies
11
Views
307
Logit
Logit
A
  • Solved
Copy Entire Workbook, save as sheet name with current date, hide all sheets except one, & attach to email
Replies
2
Views
611
Amo840812
A
B
  • Solved
Macro to Open new tab and duplicate the data from the template, and rename new tab from cell value of template.
Replies
3
Views
612
mumps
mumps
E
  • Solved
#REF when copying the result of a formula using VBA
Replies
2
Views
284
eDarren
E
T
  • Question Question
VBA Stuck Sanitising Several Sheets
Replies
2
Views
216
Tarkemelion
T

Forum statistics

Threads
1,224,518
Messages
6,179,259
Members
452,901
Latest member
LisaGo

Share this page

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
Back
Top