copying worksheets

N

Nadji

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.
 
M

Marcelo

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:
 
N

Nadji

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

VBA Coding Help for Beginner 0
Space at end of multi page list to accommodate new entries 1
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
New computer, how do i move outlook 365 ENTIRELY? 0
Autonumber field in Excel that behaves the same as Access 0
How to update a value from a linked worksheet back to the master worksheet? 0
How to update data from linked worksheet back to a master worksheet? 0
Sum multiple worksheets and summary tab that would sum and count by rep name 0

Top