| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to have cells automatically fill when entering value in ref
In A2 a formula like =IF(B2="","","text" & B2) would give you a
blank-looking A2 if nothing entered in B2 Gord Dibben MS Excel MVP On Fri, 6 Nov 2009 07:09:02 -0800, Matt wrote: How do you automatically fill in values down a spreadsheet. I have a formula in cell A1 that references the value in B1 (ie ="text"& B1) When I enter a number in b1 (ie 55) cell a1 then reads "text55".......here is my question.....I want to add a value to B2 and have A2 fill in the value from above without having to copy afterwards. I have a workbook that functions like this but cannot figure out how it is done. No values appear in A2 until i hit enter after filling a value in cell B2 and hitting enter. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to have cells automatically fill when entering value in ref | Excel Discussion (Misc queries) | |||
| Automatically apply a fill when entering text | Excel Discussion (Misc queries) | |||
| Help using the 'If' function to automatically fill in other cells | Excel Worksheet Functions | |||
| automatically fill in a range of cells | Excel Discussion (Misc queries) | |||
| need to fill cells automatically | Excel Worksheet Functions | |||
Threaded Mode
