| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create, name, open, and enter data in new sheet - from template
I keep track of monthly finances with a simple spreadsheet. I keep one sheet
unedited to copy/paste each month into a new sheet (current month-year), then fill in all the relevant data (dollar amounts/rates/misc fees/etc). What I would like to have is a button or something that will create a copy of this original/template, name it (with the current month-year), open it so it's the currently viewed screen, and have the name of the sheet (current month-year) in cell A1. I haven't a clue where to start so any help will be greatly appreciated. Many thanks, Ann~ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Enter data and Function in same cell | Excel Discussion (Misc queries) | |||
| Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
| How do I get an xls to open from the last cell that data is enter | Excel Discussion (Misc queries) | |||
| Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
