Good Morning,
I need some help with a VBA code to get unique values from multiple columns pasted into a new sheet. I tried recording a macro but it got really messy so I thought one of you might have something easy to edit.
Sheet one have over 7 pivot tables coming from different sources: Each will have a vendor ID in the pivot, Start Date, End Date, total amount etc. I am trying to copy vendor ID, Start Date, End Date from each pivottable and copy unique values to a new sheet.
I have an attachment for example but I guess the thread wont allow any attachments.
Appreciate any help.
Thanks in advance.
I need some help with a VBA code to get unique values from multiple columns pasted into a new sheet. I tried recording a macro but it got really messy so I thought one of you might have something easy to edit.
Sheet one have over 7 pivot tables coming from different sources: Each will have a vendor ID in the pivot, Start Date, End Date, total amount etc. I am trying to copy vendor ID, Start Date, End Date from each pivottable and copy unique values to a new sheet.
I have an attachment for example but I guess the thread wont allow any attachments.
Appreciate any help.
Thanks in advance.
