Filtering a list in excel then saving into a PDF with different file names

**aexcelv** · 09-24-2018, 04:19 PM

Hi All,

Need some help with a macro (not done these for a very long time).

What I am trying to achieve;

- I have a list of 100 rows (e.g. Yellow) which relate to a data set of say 1400 rows. I want to be able to take each item from the List (e.g. Yellow) and then filter the data set with all yellow related items.
- Once the filter has been done, I want to take all the filtered rows (for yellow) and save this table as a PDF.
- I then want to move down the list, e.g. blue, red etc. and repeat the process.
- I have tried to record a macro however I have been unsuccessful.

Any help would be greatly appreciated.

Many Thanks

**Logit** · 09-24-2018, 04:30 PM

.
What are the colors you are using ? Please list them.

I am presuming the color names are all in COL A ?

**aexcelv** · 09-24-2018, 04:33 PM

Thanks for replying, its actually not colours but a long list of components I just tried to simplify.

But that list would be on 1 sheet in column A with the data set on another in which is across various columns.

Thanks

**jeffreybrown** · 09-24-2018, 06:03 PM

Administrative Note:

We would love to continue to help you with your query, but first, before we can proceed…
Please see Forum Rule #3 about cross-posting and adjust accordingly...
Also see, A message to forum cross posters