taylorbjorklund
New Member
- Joined
- Aug 22, 2014
- Messages
- 3
My title sounds confusing. Essentially, I have a list of products that I pull weekly from a database and it contains all the products, active and discontinued. When I'm doing inventory ordering, I'd like to use a master "discontinued" list to filter out all the product that is no longer active.
For example, within the following table let's say the Amazon Fire SKU's are discontinued. Every time I pull this report, they'll be there. I'd like to find a way to have a running list that I can add to every time a product is discontinued, and then when I pull this list, I run the Macro and BAM, they disappear.
I will warn anyone kind enough to help me with this that I have zero experience with VBA, although I can wrap my head around formulas, and recording macros. Thank you so much.
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
For example, within the following table let's say the Amazon Fire SKU's are discontinued. Every time I pull this report, they'll be there. I'd like to find a way to have a running list that I can add to every time a product is discontinued, and then when I pull this list, I run the Macro and BAM, they disappear.
I will warn anyone kind enough to help me with this that I have zero experience with VBA, although I can wrap my head around formulas, and recording macros. Thank you so much.
Product SKU | Description | Sold | Daily Avg | Stock Out | In Stock | On Order | On Back Order |
ACCIAF000664 | Alcatel 510A PIB w/ $15 airtime | 6 | 0.27 | 3.67 | 1 | 0 | 0 |
ACCIAT000898 | Alcatel 871A (Gray) PIB w/ $25 airtime | 0 | 0 | 1 | 0 | 0 | |
ACCIAM001059 | Amazon Fire 32GB | 0 | 0 | 0 | 0 | 0 | |
ACCIAM001060 | Amazon Fire 64GB | 1 | 0.05 | 0 | 0 | 0 | 0 |
ACCIAF000757 | Amazon Kindle Fire HD 8.9" LTE | 0 | 0 | 0 | 0 | 0 | |
ACCIAP000894 | Apple iPhone 4S 8GB Black | 0 | 0 | 1 | 0 | 0 | |
ACCIAP000895 | Apple iPhone 4S 8GB White | 0 | 0 | 2 | 0 | 0 | |
ACCIAP000883 | Apple iPhone 5C 16GB Blue | 2 | 0.09 | 0 | 0 | 0 | 0 |
ACCIAP000884 | Apple iPhone 5C 16GB Green | 1 | 0.05 | 22 | 1 | 0 | 0 |
ACCIAP000881 | Apple iPhone 5C 16GB Pink | 2 | 0.09 | 0 | 0 | 0 | 0 |
ACCIAP000880 | Apple iPhone 5C 16GB White | 0 | 0 | 1 | 0 | 0 | |
ACCIAP000882 | Apple iPhone 5C 16GB Yellow | 1 | 0.05 | 0 | 0 | 0 | 0 |
ACCIAP000878 | Apple iPhone 5C 32GB Blue | 0 | 0 | 0 | 0 | 0 | |
ACCIAP000879 | Apple iPhone 5C 32GB Green | 0 | 0 | 0 | 0 | 0 | |
ACCIAP000876 | Apple iPhone 5C 32GB Pink | 0 | 0 | 0 | 0 | 0 | |
ACCIAP000875 | Apple iPhone 5C 32GB White | 0 | 0 | 0 | 0 | 0 | |
ACCIAP000877 | Apple iPhone 5C 32GB Yellow | 0 | 0 | 0 | 0 | 0 | |
ACCIAP000891 | Apple iPhone 5S 16GB Gold | 5 | 0.23 | 13.2 | 3 | 0 | 0 |
ACCIAP000892 | Apple iPhone 5S 16GB Silver | 2 | 0.09 | 0 | 0 | 0 | 0 |
ACCIAP000893 | Apple iPhone 5S 16GB Space Gray | 4 | 0.18 | 5.5 | 1 | 0 | 0 |
ACCIAP000888 | Apple iPhone 5S 32GB Gold | 0 | 0 | 1 | 0 | 0 |
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>