software

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: www.excelforum.com/member.php...oamp;userid=27091
View this thread: www.excelforum.com/showthread...hreadid=497698Hi!

Either save it as a template or just copy it.

To save as a template:

Filegt;Save asgt;Save as typegt;Template (*.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

quot;ROCKWARRIORquot; gt;
wrote in message
...
gt;
gt; Hi! In 2005 I designed a workbook w/3 worksheets. Each sheet shares
gt; various information with the other. This year I needed the same thing,
gt; so I copied/pasted all the text headings, but I had to re-enter the
gt; formulas (because the formulas don't just copy/paste to the new
gt; workbook... only the 2005 actual numbers/data will copy). Now I have a
gt; brand new blank workbook, complete with formulas for information
gt; sharing, calculations, etc.
gt; HOW DO I COPY THIS BLANK WORKBOOK W/FORMULAS TO MAKE A NEW BLANK
gt; WORKBOOK FOR 2007.... SO THAT ALL I HAVE TO DO IS CHANGE THE DATES ON
gt; THE HEADING from 2006 to 2007? CAN IT BE DONE? I'm hoping to do it
gt; quickly, before I have to start enering data on my 2006 worksheets.
gt; PLEASE HELP! I love excell, but 'm no excell expert... self taught via
gt; trial and error (and ofcourse help from this forum). THANK YOU
gt;
gt;
gt; --
gt; ROCKWARRIOR
gt; ------------------------------------------------------------------------
gt; ROCKWARRIOR's Profile:
gt; www.excelforum.com/member.php...oamp;userid=27091
gt; View this thread: www.excelforum.com/showthread...hreadid=497698
gt;