ExcelNewbie1234
New Member
- Joined
- Sep 24, 2018
- Messages
- 1
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
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