VBA Excel 2013 - Filter Unique Value from Column and Print to PDF details

Johnny Thunder

Well-known Member
Joined
Apr 9, 2010
Messages
693
Office Version
  1. 2016
Platform
  1. MacOS
Hello All,

I am currently working on a project that requires printing details from a CSV log to PDF for specific ID's.

Explanation,

I have details on my sheet from Column A:E.
Column A - My ID's (1437 Unique Values)
Column B - DAte Stamps to revisions
Columns C:E Metadata like Username and Status.

What I am trying to accomplish is having a code that will look into Column A, find a unique value and filter by that value, Then Set print details for the filtered data and Print to PDF and use the ID name as the file name and then loop to the next unique value.

What I have done on a second sheet is copy all the ID's and removed duplicates so I have my unique value list in case the code would need to follow a list to execute.

Any help is appreciated.

Thanks.
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Forum statistics

Threads
1,223,246
Messages
6,170,987
Members
452,373
Latest member
TimReeks

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top