Hi
not sure if this is what you want but you can build your quick pick list
manually in tab1 and then by right clicking on any of the events within the
quick pick list window you can then save it. Open tab2 with blank quick pick
list and then right click anywhere within that window and restore the same
set of events as in tab1. Hope that makes sense?
It's something I do regularly to save me filtering out two lots of quick pick lists.
If you wanted this automatically then sorry, I do not know how?
All the best - Michael
P.S. Then each can happily be linked to Excel.