Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to automatically populate a cell?
Say I have a 20 column wide spread sheet- columns 'A' ~ 'T'.
When I enter data into the cell at row 1 / column 'A', is there a way to have that data automatically populate the cell at row 1 / column 'T'? And if it can be done with cells, can it also be done with entire rows and columns? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to automatically populate a cell?
One way:
In T1, enter =IF(A1<"", A1,"") copy down as far as desired. In article , "RW" wrote: Say I have a 20 column wide spread sheet- columns 'A' ~ 'T'. When I enter data into the cell at row 1 / column 'A', is there a way to have that data automatically populate the cell at row 1 / column 'T'? And if it can be done with cells, can it also be done with entire rows and columns? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make dates automatically populate a cell on different worksheets | Excel Worksheet Functions | |||
Automatically Populate Fields | Excel Discussion (Misc queries) | |||
Automatically Populate Fields | Excel Discussion (Misc queries) | |||
how do you have information from one tab automatically populate i | Excel Worksheet Functions | |||
make a cell automatically populate with "1" when specified cell va | Excel Discussion (Misc queries) |