Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Basic formula for linking data
I'm trying to figure out how to link data from cells into new cells. For example if cell A1 = Cell B1 then I want Cell A2 to equal B2, but if A1=C1 then I want A2=C2and so on. The purpose is to prevent the user of my sheet from having to enter two data items that are always linked. Can anyone help? The cells being referenced are unchangable, so it should be possible....Thanks -- WatrWolff ------------------------------------------------------------------------ WatrWolff's Profile: http://www.excelforum.com/member.php...o&userid=30614 View this thread: http://www.excelforum.com/showthread...hreadid=502663 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |