copying worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nadji - 04 Oct 2006 18:23 GMT

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.

Reply to this Message

Marcelo - 04 Oct 2006 20:13 GMT

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

Signature

regards from Brazil
Thanks in advance for your feedback.
Marcelo

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

Reply to this Message

Nadji - 04 Oct 2006 20:41 GMT

Thanks again

> hi Nadji
>
[quoted text clipped - 9 lines]
> > 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.

Reply to this Message

Rate this thread: