Search and Populate the data in a single spreadsheet

Dear All,

I'm looking for a solution to my need.. I've been searching and going through multiple threads but didnt help.

My excel work book will have two sheets named as Search Data and Dumbs...

In the dumb sheet there are 100's of rows available with the below headers.

Account# Invoice# Inv Date Order # slip#


In Search Data if i enter a account number i need the list of available records to be populated on the search data sheet.

i have attached a sample sheet for your reference, please go through.

Many thanks for your help in advance.

BR, Safi.

Hi BSB,


Thanks for swift pickup.
Please see the attached

Attachment 621873

Sorry, I believe this time i made it right.

I presume there would/could be more than one record to return for each account number? "Yes there would be multiple records based on the invoice triggered"


Maybe around thousand records in dumps sheet and the maybe a around 10.20 records per account number.

Hope this helps.

There would be multiple account number search Ina single time . I believe only a macro can get this done .

Thank you

Hello BSB,

That was performing what i was looking for.. really appreciate your help.

Sorry for the late post. i just checked out the forum.

Have a good day.