Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying an Excel sheet keeping the formulas in the copy linked to
I have created an Excel sheet and need to create a copy in the same Work
Book. This copy needs to be linked to the original with regards to formula. The purpose is that when any changes are made to the original it should be made automatically to the copy. Pls advise how can I do the copying in this manner. Best regards, -- Hesahm Sharara |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying an Excel sheet keeping the formulas in the copy linked to
Hesahm,
One way is to use a Range name instead of a cell reference. You name a range by using the Name box (left of the formula bar) or with Insert - Name - Define. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Hesham Sharara" wrote in message ... I have created an Excel sheet and need to create a copy in the same Work Book. This copy needs to be linked to the original with regards to formula. The purpose is that when any changes are made to the original it should be made automatically to the copy. Pls advise how can I do the copying in this manner. Best regards, -- Hesahm Sharara |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Always keeping source formatting when copying and pasting in Excel | Excel Worksheet Functions | |||
Copying formulas to other cells. Keeping references w/o $ sign. | Excel Discussion (Misc queries) | |||
Copying formulas to other cells. Keeping references w/o $ sign. | Excel Discussion (Misc queries) | |||
Transfer/Copy Sheet, Dynamically linked Sheet | Excel Discussion (Misc queries) | |||
How do I copy a spreadsheet, keeping the formulas but not the #s | Excel Discussion (Misc queries) |