Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
customized template w/formulas
Hi! In 2005 I designed a workbook w/3 worksheets. Each sheet shares various information with the other. This year I needed the same thing, so I copied/pasted all the text headings, but I had to re-enter the formulas (because the formulas don't just copy/paste to the new workbook... only the 2005 actual numbers/data will copy). Now I have a brand new blank workbook, complete with formulas for information sharing, calculations, etc. HOW DO I COPY THIS BLANK WORKBOOK W/FORMULAS TO MAKE A NEW BLANK WORKBOOK FOR 2007.... SO THAT ALL I HAVE TO DO IS CHANGE THE DATES ON THE HEADING from 2006 to 2007? CAN IT BE DONE? I'm hoping to do it quickly, before I have to start enering data on my 2006 worksheets. PLEASE HELP! I love excell, but 'm no excell expert... self taught via trial and error (and ofcourse help from this forum). THANK YOU -- ROCKWARRIOR ------------------------------------------------------------------------ ROCKWARRIOR's Profile: http://www.excelforum.com/member.php...o&userid=27091 View this thread: http://www.excelforum.com/showthread...hreadid=497698 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
customized template w/formulas
Hi!
Either save it as a template or just copy it. To save as a template: FileSave asSave as typeTemplate (*.xlt) Excel will then save the file as a template and place it in your Templates directory (folder). The next time you need this file you would open the template, add your new data then save as a new file with the normal .xls file extension and a name of your choice. Biff "ROCKWARRIOR" wrote in message ... Hi! In 2005 I designed a workbook w/3 worksheets. Each sheet shares various information with the other. This year I needed the same thing, so I copied/pasted all the text headings, but I had to re-enter the formulas (because the formulas don't just copy/paste to the new workbook... only the 2005 actual numbers/data will copy). Now I have a brand new blank workbook, complete with formulas for information sharing, calculations, etc. HOW DO I COPY THIS BLANK WORKBOOK W/FORMULAS TO MAKE A NEW BLANK WORKBOOK FOR 2007.... SO THAT ALL I HAVE TO DO IS CHANGE THE DATES ON THE HEADING from 2006 to 2007? CAN IT BE DONE? I'm hoping to do it quickly, before I have to start enering data on my 2006 worksheets. PLEASE HELP! I love excell, but 'm no excell expert... self taught via trial and error (and ofcourse help from this forum). THANK YOU -- ROCKWARRIOR ------------------------------------------------------------------------ ROCKWARRIOR's Profile: http://www.excelforum.com/member.php...o&userid=27091 View this thread: http://www.excelforum.com/showthread...hreadid=497698 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Need One Excel Template to copy to TWO Databases | Excel Discussion (Misc queries) | |||
How do you open a template at startup? | Excel Discussion (Misc queries) | |||
How to use a template when inputting csv files? | Excel Discussion (Misc queries) | |||
How do I create a customized template? | Excel Discussion (Misc queries) |