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

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