VBA Newbie - Need Help

lsaddler

New member
Joined
Sep 29, 2021
Messages
2
Reaction score
0
Points
0
Excel Version(s)
2010
I am trying to create invoices from a pivot table and watched a YouTube video and copied the code. However, mine is not working and I have no idea why. Please help!!!!
 

Attachments

  • August 2021 - Copy.xlsm
    98.3 KB · Views: 5
You have at least Excel 2016 so you don't need the combobox/dropdown for contractors, that's more easily done with the built-in pivot table slicers (see near cell J4 of the AUGUST SERVICES sheet). So I've disabled all but the code which refreshes the pivots and there's no need to have the Contractor sheet at all.
There is/was no code at all to update the Invoice sheet.
It would be helpful to know which YouTube video - provide a link to it.
Which version of Excel are you using? [Does the formula at cell A4 work if you re-enter it?]
The attached only does the bit of filtering the pivot table for the chosen contractor.
 

Attachments

  • ExcelGuru11322Copy of August 2021 - Copy.xlsm
    92.6 KB · Views: 5
Last edited:
How would I add more vendors to the built in table slicers?
When the source data for the pivot is changed and the pivot refreshed the slicer will automatically update itself.

I see he put the pivot table directly on the invoice sheet.
You could do something similar; stop the pivot autofitting on update, hide some rows, change the layout and design of the pivot.
 
Back
Top