| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to automatically update a second worksheet when data inserted
I prepared a worksheet with years and names. This worksheet showed names,
dates and other data (total five columns) with the names (column 2) in alphabetical order A to Z. I copied this to a second worksheet which showed all the same data but in year order (column 1) 1999 to 2010. Can I now insert a row of data in the first worksheet and get it to automatically be inserted in the correct position in the second worksheet? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can we automatically update page numbers for inserted tab? | Excel Discussion (Misc queries) | |||
| How can I get linked data to update inserted rows | Excel Discussion (Misc queries) | |||
| Copy data into another worksheet and have it update automatically? | Excel Discussion (Misc queries) | |||
| Copy data into another worksheet and have it update automatically? | Excel Discussion (Misc queries) | |||
| Can inserted rows automatically include existing worksheet formula | Excel Discussion (Misc queries) | |||
Threaded Mode
