• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by Manster

  1. Manster

    Export Specific Cells/Data from Google Sheet to Excel Desktop using VBA

    Ok, noted. I will learn from this. If I have any inquiries or problems related to this, hopefully, you will not be bored with me. Thank you so much Ninjas p45cal!
  2. Manster

    Print or Save as a PDF for each item in Pivot Slicer using VBA with Single Click Button

    Hi Experts, I have 20 items in the slicer pivot. Therefore, I want to print or save as a PDF for each item (in a separate file), as you can see in the tab sheet "Report" on my excel file (Sample.xlsx) below. Is there any code to run this? Your kind attention is really appreciated. Thank you in...
  3. Manster

    Export Specific Cells/Data from Google Sheet to Excel Desktop using VBA

    Wow..such amazing! Sir, can you teach me how you do that? I had done this using "Get Data > From Web." However, it is not 'good' like you did. Your kind attention is really appreciated.
  4. Manster

    Export Specific Cells/Data from Google Sheet to Excel Desktop using VBA

    Yes, I had added it already.
  5. Manster

    Export Specific Cells/Data from Google Sheet to Excel Desktop using VBA

    Sorry for the late reply. Thank you for your feedback on the VBA code above. I think it should go for Plan B, as you mentioned. Just to double confirm, is the Power Query on the Google Sheet or in Excel?
  6. Manster

    Export Specific Cells/Data from Google Sheet to Excel Desktop using VBA

    Thank you, Sir, for the reply. Do you mean writing like this? If yes, I ran this code, and it became an error, Sir. My apologies due to weak about this. . . . For i = 1 To 2 keyString = "1tNCvneyYlvlLJpVJLiina5T34edjXZYA5cq24K6v3a8" Select Case i Case 1 gidString = "0"...
  7. Manster

    Filter Pivot Chart without Changing the Chart Format

    Yes!!! Of course, I am pleased about this. You save my day, Sir! I spent around 8 hours yesterday searching on YouTube and Google. Then, I decided to ask in this great forum for help. Thank you again, Sir! May God bless you.
  8. Manster

    Filter Pivot Chart without Changing the Chart Format

    Hi Experts, I have a problem regarding the pivot chart when filtering using a slicer. My problem is: The chart format will change when I filter the data, for example, "Year". The "Target" line will change to the clustered column. Therefore, I hope anyone can help me to maintain the line of...
  9. Manster

    Export Specific Cells/Data from Google Sheet to Excel Desktop using VBA

    Hi p45c4l, There are two conditions here which I can simplify my explanation below: 1) When I try to delete/erase the values in the cells, for example, Sheet 1 B3:C5, then I update in the Excel file, the cells in the excel file could not follow with the Google Sheet which is B3:C5 is empty now...
  10. Manster

    Export Specific Cells/Data from Google Sheet to Excel Desktop using VBA

    Awesome!!! Thank you, p45cal! This works for me. So, I can go another step to configure this excel and google sheet. If anything problem or query related to this, I will raise it here. Thank you again!
  11. Manster

    Export Specific Cells/Data from Google Sheet to Excel Desktop using VBA

    Ok, I already deleted that posting in forum A, and I have sent a private message to the forum B moderator on how to delete that post as well. I am waiting for their reply. I should be alert about any forum's rules. It is hoped that you will accept my apologies and regrets. Sorry and thank you...
  12. Manster

    Export Specific Cells/Data from Google Sheet to Excel Desktop using VBA

    I would appreciate it if any excel ninjas here could assist or help me. I also google about this, and some advice using google API, and I do not know much about this. However, if any excel ninjas have another way, I appreciate it.
  13. Manster

    Export Specific Cells/Data from Google Sheet to Excel Desktop using VBA

    sorry about that sir, I didn't realize that rule and this is my mistake. I will edit this thread and put the link. Really sorry.
  14. Manster

    Export Specific Cells/Data from Google Sheet to Excel Desktop using VBA

    Hi everyone! First, apologize because I have no basic about the VBA. But I need a code/script to solve my problem. My asking is quite long, but I try to make it as short as possible. I want to copy the specific cells/data from Google Sheet to the Excel Desktop using VBA. Yes, Excel has a "Get...
  15. Manster

    Sorting selected columns by using VBA

    Sir, sorry for the late reply. Kindly please find an attachment for your kind attention.
Back
Top