I have a raw data worksheet with headers from A:AK and data from 2:8868. Each row is a unique account. Column I is the "Product Description," and I have 70 different product descriptions. I also have another column P "Value Adjustment" which is a numeric value. Most of the accounts have a "0" Value Adjustment; however, about 300 do have a value adjustment. I need to put all Value Adjusted Accounts regardless of Product Description one on worksheet, and I also need to put all accounts with the respective Product Descriptions excluding Value Adjusted Accounts on separate worksheets for all 70 Product Descriptions. So I will have 72 total worksheets (including the Raw Data and Value Adjusted Accounts worksheets).
I have been using Advanced Filter for this process, but I'm running into an issue. When I use Advanced Filter I move over all accounts with the same Product Descriptions, but I need to exclude Value Adjusted Accounts How can I do this? (Note: I added an additional column using an IF statement labeling Yes if there is a #>0 for Value Adjustment and No if not. Then I used this column with Advanced Filter criteria to move all Value Adjusted Accounts to their own tab.)
Also, I need to create a monthly report from this data, so is there any easier way to automatically create the tabs based on unique Product Descriptions and add the corresponding accounts to each tab (noting that Value Adjusted Accounts go on their own tab and are excluded on the other tabs)?
Bookmarks