Creating a master list
 

Hi!
I have 6 lists that can vary up to 10 rows long. I would like t
maintain (automatically) a master list which contains all items in th
6 lists and maintains the order that they are listed in. In other word
when I add to list 1 I want the new item to be inserted into the maste
list where it belongs with list 1 items.
A formula would actually be preferable but I can trigger a macro to d
it if necesasary

--
Brian Matlac
-----------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...nfo&userid=350
View this thread: http://www.excelforum.com/showthread.php?threadid=47720