Results 1 to 4 of 4

Thread: VBA Newbie - Need Help

  1. #1
    Neophyte lsaddler's Avatar
    Join Date
    Sep 2021
    Posts
    2
    Articles
    0
    Excel Version
    2010

    VBA Newbie - Need Help



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!!!!
    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    2,039
    Articles
    0
    Excel Version
    365
    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.
    Attached Files Attached Files
    Last edited by p45cal; 2021-09-29 at 11:21 PM.

  3. #3
    Neophyte lsaddler's Avatar
    Join Date
    Sep 2021
    Posts
    2
    Articles
    0
    Excel Version
    2010
    I do have 2016 version.

    How would I add more vendors to the built in table slicers?

    Is there a way to have it update the invoice sheet?

    Here is the link to the video https://www.youtube.com/watch?v=wXSa0WmQhco

    Thank you!!

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    2,039
    Articles
    0
    Excel Version
    365
    Quote Originally Posted by lsaddler View Post
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •