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!!!!
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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.