Search:

Type: Posts; User: Pranesh; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    0
    Views
    18

    VBA to expand pivot table

    Hi,

    I have 24 pivots in sheet1 and in sheet2 I have a dashboard which will have the numbers from the Pivot output. I have used GETPIVOTDATA to fetch the data from Pivot to my dashboard Table.

    ...
  2. Re: Vba to move emails from Inbox to personal folder

    Hi Domenic,


    Your genius. It worked out perfectly. Thanks a ton for all your help.
  3. Re: Vba to move emails from Inbox to personal folder

    Hi Domenic,


    Thank you so much for your response and help.


    I applied the code you provided it is moving emails received till 1:00 AM.


    I think i didnt clearly explain what im looking...
  4. Re: Vba to move emails from Inbox to personal folder

    Hi Domenic,


    Sorry to disturb you again.


    Everything is working fine in this Macro. I have one small correction to be made. Please help me if you can.


    Now if i give the date as 6/26/2019...
  5. Replies
    0
    Views
    178

    Copy data from IE using VBA

    Hi All,


    I have a VBA code which will open a website. Now i want an information to be copied from the website to the excel sheet.


    In the website at the top right corner there will be a text...
  6. Replies
    2
    Views
    237

    Re: Unable to connect IE

    Hi Girish,

    Thanks for your response.

    I have made the comment active. But i still get the debug at this line - Do While IE.READYSTATE = 4: DoEvents: Loop
  7. Replies
    2
    Views
    237

    Unable to connect IE

    Hi All,


    Im trying to connect a webpage using a code which i got from a website. When I tried with the default URL available in the code it worked perfectly.


    I changed the URL to the URL...
  8. Replies
    9
    Views
    249

    Re: How to use GETPIVOTDATA

    Hi,

    I found the solution in the below link. Thanks for your help and time.


    https://www.excelforum.com/excel-charting-and-pivots/1121401-getpivotdata-problem-data-model.html
  9. Replies
    9
    Views
    249

    Re: How to use GETPIVOTDATA

    Yes it works.



    Yes, Im trying to link the formula to a cell so i can change the year and month by changing the value in a cell.


    In A1 i have Jun and in A2 i have 2019
  10. Replies
    9
    Views
    249

    Re: How to use GETPIVOTDATA

    Hi Twollaston,

    Thanks for your help here.

    It is not using Power bi pivot, but its actually a data model pivot.

    If i use a normal pivot i can easily change what im expecting but in data model...
  11. Replies
    9
    Views
    249

    Re: How to use GETPIVOTDATA

    Hi mole999,

    Sorry, i couldn't understand what you meant.
  12. Replies
    9
    Views
    249

    How to use GETPIVOTDATA

    Hi All,


    I am trying to get a value from a pivot table using GETPIVOTDATA formula. Below is the formula.



    GETPIVOTDATA("[Measures].[Distinct Count of...
  13. Replies
    4
    Views
    114

    Re: Distinct Count Formula

    Thank AlanY. I looked into it. It will give the unique count but i want this to be in a SUMIFS formula because i need to drive this Unique count with some criteria.
  14. Replies
    4
    Views
    114

    Re: Distinct Count Formula

    Hi AlanY,

    I tried it but no improvement. Actually I'm trying to get count of unique number from a column using SUMIFS function. But SUMIFS wont give unique count, so how to modify it
  15. Replies
    4
    Views
    114

    Distinct Count Formula

    Hi All,

    Is there a formula to find distinct count in a column without using COUNIF function. Currently I'm using the below formula, but it takes more time to complete 9000 rows of data i have. Can...
  16. Re: Vba to move emails from Inbox to personal folder

    Hi Domenic,


    This is what i expected. Your code works perfect. You made my work easier with help of your code. Thank you so much for all your time and help till now. I hope and wish your help...
  17. Re: Vba to move emails from Inbox to personal folder

    Hi Domenic,


    Thank you so much for your help till now. The code works perfectly for the #1 & #2 . I will create a new thread for the remaining.


    Meanwhile I'm trying to just copy the table...
  18. Re: Vba to move emails from Inbox to personal folder

    Hi Domenic,


    As you said i took post#6 and run it but it was not working and found that the receipient address is the only issue. Senderemailaddress is not only taking the email id or name, but...
  19. Re: Vba to move emails from Inbox to personal folder

    Hi Domenic,


    It is not a shared folder. I will explain it clearly now. I receive emails from a Distribution List(DL). In that DL there will be few users mail IDs who are part of that DL, and...
  20. Re: Vba to move emails from Inbox to personal folder

    Hi Domenic,

    Tested with name as well but not working. If you can try with some dummy data might help. I'm not sure how to fix it.
  21. Replies
    2
    Views
    172

    Re: VBA to filter a pivot table

    There us no reply from anyone. If this cannot be done, please help me to close this thread.
  22. Re: filter a pivot table with values in an array of cells?

    Hi Jerry,


    I know this an old post. Im looking for the same kind of scenario for my code but unable to get exactly what i need. So thought of asking you help in this post.


    In this scenario...
  23. Replies
    2
    Views
    172

    Re: VBA to filter a pivot table

    Hi All,

    I have managed to record a code and modified it. This will work for one item(Smith) in cell I2, but if i have 2 items in cell I2 (Smith, Dave) it wont work.


    Can someone help me to...
  24. Re: Vba to move emails from Inbox to personal folder

    Hi Domenic,
    I will receive the emails from a common Mail box, but i dont have that common mail box in my Outlook. So as of now the emails has been received in my Inbox.


    I also opened an email...
  25. Re: Vba to move emails from Inbox to personal folder

    Hi Domenic,


    I applied your code in Outlook and as a output i got the email name. For example my email ID is EMAILSUPPORT@ABC.COM after applying your code i it gave me the email name...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4