+ Reply to Thread
Results 1 to 10 of 10

Macro to Update Data from Master Worksheet to Separate Sheets based on Criteria

  1. #1
    Registered User
    Join Date
    11-19-2010
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    5

    Macro to Update Data from Master Worksheet to Separate Sheets based on Criteria

    Hello. I have searched the internet for several weeks and still have not been able to find the correct macro to do what I need. I have a workbook that is updated daily for product issues that occur. I am looking for a macro to update the workbook by copying the entire rows of a specific criteria into separate worksheets based on that criteria. The criteria is in column E, so there should be a worksheet labeled for each category. I also need a separate worksheet added based on the criteria in column AC. If there is a checkmark in column AC, than I need that entire row to be added to another worksheet and deleted from the master sheet. And finally, if possible, also have separate worksheets based on criteria in column I. So there would be separate worksheets based on the champion listed in column I. As I said before, this workbook is updated daily and I would like to have some type of order to it when it is time to present. I have attached a sample copy below. Any help would be greatly appreciated. Thank you.
    Attached Files Attached Files

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Macro to Update Data from Master Worksheet to Separate Sheets based on Criteria

    'SHEET1 TO MANY SHEETS
    Here's a macro for parsing rows of data from one sheet to many sheets named for the same values.It not only can parse the rows, it can create the sheets if they are missing. There is a sample sheet there where you can test this out.

    ==============

    I tweaked this code a little so that you can call it multiple times and feed in a different "column to parse by (vCol)" each time.

    Then I added a macro to run the ParseItems macro twice, once for column E and once for column I, then a separate routine to move all the completed items to an appropriately named sheet.
    Please Login or Register  to view this content.

    With the button on the Master Sheet, it will create the sheets and parse the data as needed, and move the completed items each time you press the button.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-19-2010
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Macro to Update Data from Master Worksheet to Separate Sheets based on Criteria

    Hi Jerry! Thank you for responding so soon. However, when I try to use the macro on my main workbook, it doesn't work. It keeps saying that the sub or function is not defined for ParseItems (5). Any other suggestions?

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Macro to Update Data from Master Worksheet to Separate Sheets based on Criteria

    The workbook I uploaded has two macros in it. Be sure to put both in your main workbook.

  5. #5
    Registered User
    Join Date
    11-19-2010
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Macro to Update Data from Master Worksheet to Separate Sheets based on Criteria

    yeah i noticed that and it's still not working. thanks for your help anyway.

  6. #6
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Macro to Update Data from Master Worksheet to Separate Sheets based on Criteria

    Let's take a look together.

  7. #7
    Registered User
    Join Date
    11-19-2010
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Macro to Update Data from Master Worksheet to Separate Sheets based on Criteria

    ok....... how would you like to proceed?

  8. #8
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Macro to Update Data from Master Worksheet to Separate Sheets based on Criteria

    You should upload the file so we can look at it together.

  9. #9
    Registered User
    Join Date
    11-19-2010
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Macro to Update Data from Master Worksheet to Separate Sheets based on Criteria

    do you have an e-mail address I can use to send it to you?

  10. #10
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Macro to Update Data from Master Worksheet to Separate Sheets based on Criteria

    There are links in my signature you can use to contact me through my site, but is it necessary? Upload it here we can all look at it together.

    Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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