Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ATTN : Ron (Multiple Dependent DV List Auto Update) Rajat Excel Worksheet Functions 0 December 1st 06 01:31 PM
ATTN : Ron (Multiple Dependent DV List Auto Update) Rajat Excel Worksheet Functions 2 November 30th 06 07:21 AM
Help - Auto update from multiple spreadsheets plngarbage Excel Worksheet Functions 5 May 12th 06 04:49 PM
Help - Auto update from multiple spreadsheets plngarbage Excel Discussion (Misc queries) 0 May 12th 06 11:05 AM
How to consolidate several Excel lists into one? alm60103 Excel Discussion (Misc queries) 1 May 26th 05 07:40 PM


All times are GMT +1. The time now is 07:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"