| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
forcing value into remote cell
i want to create cell A3 with a calculation that forces a defualt value into cell B3 if cell B3 is blank, but then that value can be overwitten by the user without affecting cell A3...possible? -- bcamp1973 ------------------------------------------------------------------------ bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268 View this thread: http://www.excelforum.com/showthread...hreadid=521146 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
forcing value into remote cell
Enter =A3 in cell B3.
B3 will pick up whatever A3 has in it. The user can over-ride B3 with any entry and not affect A3. -- Gary's Student "bcamp1973" wrote: i want to create cell A3 with a calculation that forces a defualt value into cell B3 if cell B3 is blank, but then that value can be overwitten by the user without affecting cell A3...possible? -- bcamp1973 ------------------------------------------------------------------------ bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268 View this thread: http://www.excelforum.com/showthread...hreadid=521146 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
| Forcing data into a cell | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
