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

**kmnuabea** · 12-14-2010, 03:09 PM

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.

**JBeaucaire** · 12-14-2010, 04:13 PM

'SHEET1 TO MANY SHEETS
Here's a macro for parsing rows of data from one sheet to many sheets named for the same values.

Sheet1 to Many Sheets

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.

**kmnuabea** · 12-15-2010, 12:31 PM

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?

**JBeaucaire** · 12-15-2010, 07:37 PM

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

**kmnuabea** · 12-16-2010, 02:14 PM

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

**JBeaucaire** · 12-16-2010, 07:01 PM

Let's take a look together.

**kmnuabea** · 12-17-2010, 08:39 AM

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

**JBeaucaire** · 12-17-2010, 10:59 AM

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

**kmnuabea** · 12-17-2010, 01:48 PM

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

**JBeaucaire** · 12-17-2010, 05:49 PM

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.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

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

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

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

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

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

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

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions