+ Reply to Thread
Results 1 to 2 of 2

Move Data from Raw Data Worksheet to Other Worksheets Based on Criteria (Except Also..)

  1. #1
    Registered User
    Join Date
    10-31-2017
    Location
    Salt Lake City
    MS-Off Ver
    2013
    Posts
    5

    Move Data from Raw Data Worksheet to Other Worksheets Based on Criteria (Except Also..)

    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)?
    Last edited by exceldemon; 10-25-2019 at 01:02 AM.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016 (preparing to update to 2021)
    Posts
    7,543

    Re: Move Data from Raw Data Worksheet to Other Worksheets Based on Criteria (Except Also..

    I would suggest a helper column for the exceptions.
    The way I would do it would be to create the worksheets for each of the unique accounts and then past te corresponding data from the raw table to each sheet.
    Since you don't mention if you're using macro's the rest would be based on assumptions and guessing, and that my friend is the worst trap to fall in to.
    I would suggest a dummy data file with what you have so far, add one or two of the worksheets as you would want to have them and also are the new worksheets to be part of the raw data file or is it a new file?
    You've got some homework to do and just update when you're ready
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to move data from one worksheet to another based off of criteria;
    By KLiving in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-17-2015, 12:41 PM
  2. Replies: 0
    Last Post: 08-11-2014, 02:38 PM
  3. [SOLVED] Macro Needed - Move data to worksheet based on criteria
    By sharpyoungb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-10-2014, 11:42 AM
  4. Move data to specific worksheet based on Column A criteria.
    By forestminuet in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-07-2013, 01:44 PM
  5. Automatically move rows of data to different worksheets based on cell criteria
    By Kaz09 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2013, 12:49 PM
  6. I need to move data from main worksheet into multiple worksheets based on a criteria
    By ksenia81 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2012, 05:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1