freshpro3285
New Member
- Joined
- Sep 26, 2017
- Messages
- 2
I have a workbook with 2 tabs
1st tab = Top 50 sales by item code
2nd tab = Open Orders w/amounts and item codes
I need a formula that will pull only the item codes listed on the 1st tab from the Open Order tab. My Open Orders tab contains over 3,000 different item codes with 1000's of rows and I only need the 50 with their corresponding amounts.
Make sense ??
Any help would greatly be appreciated.
1st tab = Top 50 sales by item code
2nd tab = Open Orders w/amounts and item codes
I need a formula that will pull only the item codes listed on the 1st tab from the Open Order tab. My Open Orders tab contains over 3,000 different item codes with 1000's of rows and I only need the 50 with their corresponding amounts.
Make sense ??
Any help would greatly be appreciated.