Creating a Filter loop based on unique values in a column

**Ragnarok_421** · 08-09-2014, 01:46 PM

OK, I am hoping someone can help me with this.
First I need to obtain a range based on the unique values in a set column (lets call it B)
Then I need to run a loop to filter all rows containing this list of unique values one at a time.
I will perform some other calculations on this filtered data then jump to the next unique value in column B

I have done something similar before that involved copying the data to different sheets and naming them based on the unique value currently running in the loop but I can't seem to get the syntax right to adapt it to do this within the existing worksheet.

Here is a sample of what I tried to adapt.

Please Login or Register  to view this content.

I have attached a sample for the file I am trying to apply the loop I described to.

Any help with this is greatly appreciated. I am totally stuck on this one.

**JBeaucaire** · 08-09-2014, 07:08 PM

I haven't gotten into your macro, but if all you're looking to do is parse all the values of one sheet to separate sheets based on the unique values in one column, here's a published macro that 1000s of people have used for this purpose, very little tweaking will be needed for you to use it:

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

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.

**Ragnarok_421** · 08-22-2014, 03:20 PM

Good deal, I was able to do some patch work with that and get this file working. Thans for the suggestion.

**JBeaucaire** · 08-23-2014, 05:34 AM

As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.

Creating a Filter loop based on unique values in a column

LinkBack

Thread Tools

Rate This Thread

Display

Creating a Filter loop based on unique values in a column

Re: Creating a Filter loop based on unique values in a column

Re: Creating a Filter loop based on unique values in a column

Re: Creating a Filter loop based on unique values in a column

Thread Information

Users Browsing this Thread

Similar Threads

Macro for creating new sheets based on unique values in a row...

[SOLVED] Filter for Unique Values based on Two Columns

[SOLVED] Filter rows based on unique values in one column + specific value in another column

how to loop Criteria based on unique values in a column

filter list first by one column, then by unique values in another column

Bookmarks

Bookmarks

Posting Permissions