On 1 tab I have multiple listings with 1 effective date. I want to pull
all listings for 1 effective date over to my summary tab. Using the
lookup functions only allow me to pull over the first result. HELP!

bmarqner,

Take a look at Advanced filter. It's a process you have to perform each
time you want the data copied to your summary tab (which a macro could
automate).

Putting your email address in a post absolutely guarantees it will be picked
up by the spam-bots. My last email address was getting about 100 spams/day
a few years ago. Literally. I'd put my email address in the reply-to
field, etc. I had to retire it and get a new one.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
wrote in message
ups.com...
On 1 tab I have multiple listings with 1 effective date. I want to pull
all listings for 1 effective date over to my summary tab. Using the
lookup functions only allow me to pull over the first result. HELP!