I'm looking for help with a macro that would need to filter Column D on the Report sheet for unique values and attach that as a new workbook to an email. It would also need to filter the Status tab for the same 'x' value in Column A and copy all the data to the email in table format.
The email 'to' would be in the format of the filtered value from Column D on Report tab. ([email protected]) - formatted to add 2 leading zeroes if number is less than 3 digits.
It would need to create an email for each unique number in the filtered Column D. The emails will be sent from a shared email account.
You can read my original post here:
A sample file has been attached
Sample File.xlsx (11.1 KB, 2 views)