Create a New Database

[lbc0056]

I have a database tracking orders from our suppliers on one worksheet. I want to be pull all the orders for one supplier on to another sheet. Then narrow that down to the orders within a specific date range. Is there a formula or VBA code that can do that?

 

[dmt32]

Hi,
should be able to do what you want using Advance Filter.

Have a look here for guidance:http://www.contextures.com/xladvfilter01.html#ExtractWs

There is a sample workbook you can download for free which may find helpful

Dave