copying worksheets

G

Guest

Is it possible to copy a workbook & formulas to another workbook without
re-entering each formula to reflect a new year? I created a budget worksheet
that's linked to another worksheet that needs to be updated every year. I'm
able to copy the workbook but I have to put the new year in each field
manually. Are there any shortcuts? I hope someone can help thanks.
 
G

Guest

hi Nadji

one way is on menu Edit select replace and change 2006 to 2007.

make a backup of your sheet before do it

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Nadji" escreveu:
 
G

Guest

Thanks again

Marcelo said:
hi Nadji

one way is on menu Edit select replace and change 2006 to 2007.

make a backup of your sheet before do it

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Nadji" escreveu:
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copying workbooks 3
copying formulas from worksheets 3
Referrence a total in a cell on another worksheet 4
Copying workbooks 4
Need to make page numbers sequential across worksheets 2
Search columns on multiple worksheets 2
IF formula statement that would spread an annual budget over 12months 1
Excel Formulas 2

Top