Multiple worksheets

B

Boenerge

Hi,
Is it possible to enter data on one worksheet and for the same data then to
be automatically entered into another worksheet within the same workbook?
 
R

Ragdyer

One way is to link cells.

You can have XL create the link for you by clicking in the destination cell,
type in an equal sign ( = ),
navigate to the source sheet and click in the cell holding the "original"
data,
and hit <Enter>.

Anything entered in the source cell will be displayed in the destination
(target) cell.
Look at the formula syntax in the target cell, so you can duplicate this
with revisions in other cells, or you can continue to use the above method.

Another method is to go "in-the-other-direction" ... from the source to the
target.

Right click in the source cell and choose "Copy",
Navigate to the target sheet and right click in the target cell, and choose
"Paste Special".
Click on "Paste Link", and you're done!

You'll notice the 2 different methods produce similar BUT *not* exact
formulas.

The "Paste Link" method yields absolute cell references, while the other
creates relative references.
 
E

Earl Kiosterud

Boenerge,

Is is possible, but consider this: Keeping multiple copies of the same stuff can lead to
unintended consequences. Accidental updating of one but not the other can lead to
problems -- you have to be diligent to keep the copies synchronzed.. It's generally better
to keep it all in one sheet, then usvarious tecniques to present (but not change) the data
when it's needed elsewhere. Such techniques include Advanced Filter, links (Copy - Paste
Special - Paste link), and pivot tables (for summary data).
--
Earl Kiosterud
www.smokeylake.com

Note: 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.
 
Top