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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Excel Facts
Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
dmt32
Well-known Member
- Joined
- Jul 3, 2012
- Messages
- 8,334
- Office Version
- 2021
- 2019
- Platform
- Windows
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
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
Upvote
0
Similar threads
- Replies
- 2
- Views
- 251
- Replies
- 1
- Views
- 87
- Replies
- 4
- Views
- 251
