| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
continuous updating list on two worksheets
In an Excel document, I have a list of names that I add to and delete from
daily. How do I create in that same document, but on another tab, a copy of that list that automatically updates whenever I make a change in the original list? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
continuous updating list on two worksheets
=INDIRECT("Sheet1!A" & ROWS($A$1:A1)) and copy down
-- Gary''s Student - gsnu200765 "Alissa" wrote: In an Excel document, I have a list of names that I add to and delete from daily. How do I create in that same document, but on another tab, a copy of that list that automatically updates whenever I make a change in the original list? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| updating multiple worksheets | Excel Discussion (Misc queries) | |||
| Formulas across worksheets are not updating | Excel Discussion (Misc queries) | |||
| Updating worksheets from another file | Links and Linking in Excel | |||
| Continuous Page No. on all worksheets | Excel Discussion (Misc queries) | |||
| Continuous page numbers in workbook of multiple worksheets | Excel Discussion (Misc queries) | |||
Linear Mode
