Pull data from sheet 3 to sheet 2 using a search field in sheet 1?

**smithymcsmithy** · 09-05-2012, 04:50 PM

Hi guys,

Ok I have another one for you

I want to pull all columns from sheet 3 to sheet 2 using a search field in sheet 1. To search you would use the "store" number, this will be a 4 or 5 digit number. There will be multiple orders pulled from sheet 3. From 1 to over 200. Then when you want to search another store it replaces all data in sheet 2. I've included a sample if it helps. Any help would be greatly appreciated.

**JieJenn** · 09-05-2012, 05:14 PM

If you change the filter fomratting in sheet 1, you can use advancedfilter.

**smithymcsmithy** · 09-05-2012, 05:31 PM

This is fantastic

Thank you

**smithymcsmithy** · 09-05-2012, 05:37 PM

Could you make a search function for the order number too?

**JieJenn** · 09-05-2012, 05:57 PM

Add a new search field next to Store then expand the filter range from ws1.Range("A2:A3") to ws.Range("A2:B3"). You might want to google AdvancedFilter to see how it works.