@Webcam723, I see that you have updated your profile, although you didn't specify Mac.
Do you have Power Query and would you want to try to use that as opposed to VBA to produce a pivot table?
If so please attach a small sample of your workbook to your next post.
Information about attachments is given in the "HOW TO ATTACH YOUR SAMPLE WORKBOOK" banner at the top of the page.
Let us know if you have any questions.