ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Consolidate multiple lists, with auto-update (https://www.excelbanter.com/excel-discussion-misc-queries/164407-consolidate-multiple-lists-auto-update.html)

Eric

Consolidate multiple lists, with auto-update
 
I have multiple lists that I'd like to consolidate, i.e., create a
consolidated list that contains all the entries in the first list followed by
all the entries in the second list..., etc.

Obviously I can simply cut and paste. But I wonder if there is any way to
do it automatically, so that the consolidated list will be automatically
updated as I edit and add/delete entries in the original lists.

Any suggestions?

Thanks.


All times are GMT +1. The time now is 08:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com