+ Reply to Thread
Results 1 to 8 of 8

Pivot Table Get & Display Data Help...

  1. #1
    Registered User
    Join Date
    09-26-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    76

    Unhappy Pivot Table Get & Display Data Help...

    Dear Experts

    i have pivot table & i want to get data from pivot table

    i have Userform & when i click on Combobox1 & select supplier name form drop down list then only display bill nos. of that supplier in Combobox51 to Combobox60 from Balance Payable Sheet

    & if sheets ("Balance Payable") is contain 0 in column F then do not display that row or bill no.

    Attached workbook for your ready reference.

    Hope you can understand my problem.

    If you help on this regards, it would be very helpful me & save my lot of time.

    Thanks in advance
    Sagar007
    Attached Files Attached Files
    Last edited by sagar007; 10-22-2012 at 07:06 AM.

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Pivot Table Get & Display Data Help...

    hi sagar07, option to make it if I understood everything correctly
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-26-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    76

    Re: Pivot Table Get & Display Data Help...

    Hello

    Awesome Perfect, thank you very much for your valuable time spending.

    If i add new supplier name in pivot table & select in combobox1 from pivot table then getting error message : Run Time error 13 " Type Mismatch "

    & one more little help is if i select supplier name then all combo boxes fill automatically, i want to select only from dropdown list.

    Thank you
    Sagar

  4. #4
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Pivot Table Get & Display Data Help...

    please check attachment, test the userform if it's OK with you
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-26-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    76

    Re: Pivot Table Get & Display Data Help...

    Dear Watersev Sir

    Superb, Awesome , Everything is ok & working like a charm.

    You are Really intelligent / brilliant person.

    You save my lot of time.

    God Bless You

    Reputation added

    Thank you very much
    Sagar007
    Last edited by sagar007; 10-25-2012 at 01:17 AM.

  6. #6
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Pivot Table Get & Display Data Help...

    thank you, though it seems I understood only now what you wanted when you said not to show zero values in F column - it means the dropdown should not have those Invoice numbers. If I'm right, this amended code would do that
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    09-26-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    76

    Re: Pivot Table Get & Display Data Help...

    Thank you very much sir , awesome i am really your fan

    I am also very impressive by your codes.

    I kept this workbook on D:\AVS\Data\Creditors Data.xlsm & trying to open this workbook from AVS workbook then getting error " run time error 70 " Permission denied, error highlighted in blue color

    both workbooks attached for your ready reference please look & help me out

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by sagar007; 10-25-2012 at 05:09 AM.

  8. #8
    Registered User
    Join Date
    09-26-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    76

    Re: Pivot Table Get & Display Data Help...

    I think did not work due to file extension, i was used extension .xlsb instead of .xlsm.

    i have changed file extension & it's work perfectly.

    If you know another issue please let me know.

    Thank you
    Sagar
    Last edited by sagar007; 10-25-2012 at 07:11 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1