Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copying worksheets
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copying worksheets
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: 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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copying worksheets
Thanks again
"Marcelo" wrote: 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: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying data across different worksheets | Excel Discussion (Misc queries) | |||
Copying multiple Worksheets | Excel Discussion (Misc queries) | |||
copying cells from other worksheets | Excel Discussion (Misc queries) | |||
Excel 2002 - copying formulas across worksheets | Excel Discussion (Misc queries) | |||
copying worksheets | Excel Discussion (Misc queries) |