Posted to microsoft.public.excel.programming

Max

external usenet poster

Posts: 9,221

Duplication

" Wonderer" wrote
I need to know how to have two cells contain the same information, on the
same sheet, so that when I change on cell, the other will reflect that
change. How do I do that?

If you put in say, F1: =IF(A1="","",A1)
F1 will reflect the input in A1.
If A1 is cleared, F1 will display a blank: ""
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Duplication	Lorenza@hsccs	Excel Worksheet Functions	1	May 5th 10 06:10 PM
Duplication	PMST	Excel Discussion (Misc queries)	2	February 19th 08 03:18 PM
Duplication	Welthey	Excel Discussion (Misc queries)	2	January 15th 07 09:48 PM
How-to Prevent Value Duplication	StrapJr	Excel Discussion (Misc queries)	1	November 28th 06 03:57 PM
Data duplication	No Name	Excel Programming	1	June 14th 04 05:14 PM

All times are GMT +1. The time now is 06:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us