Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto fill in cells
If you mean that when data is entered into column a you want the column b to
have data that is the same as all data in column b then =if(a1<"","constant info",""). This assumes that there is nothing in column a if there are zeros, change the ""s to 0 in the formula. "Roy" wrote: I have info that goes into a cell based on info in the cell next to it and that info is always the same. How do I get a cell to fill in automatically based on information entered in another cell? -- Roy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto fill data from cells | New Users to Excel | |||
How can I auto fill cells in excel for example 1 of 50, 2 of 50 | Excel Discussion (Misc queries) | |||
Auto Fill a row of cells | Excel Discussion (Misc queries) | |||
auto color fill cells | New Users to Excel | |||
Auto fill in cells | Excel Worksheet Functions |