• 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.

Search results

  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.
  16. Manster

    Sorting selected columns by using VBA

    Sir, I already run your coding above. That's what I need actually. However, I facing another problem, "to do this all the merged cells need to be the same size". Ya, I admit that my cells are merged. What should I change that code to suit the cells that i merged already?
  17. Manster

    Sorting selected columns by using VBA

    Hi Sir, Thank you about the command you give it to me and it really works! Sir, can you check my VBA (Actually, i'm not created from scratch, I just copy it from other files & altered it). Sub ClickButton() Dim ws As Worksheet Set ws = ThisWorkbook.Worksheets("AT") lr =...
  18. Manster

    Sorting selected columns by using VBA

    Hi Chihiro, Thanks response my thread. Basically when we are sorting in excel; Once we click a button (in excel by create VBA), A1:A10 --> Sorted accordingly from A to Z; A column is Student Name B1:B10 --> Sorted accordingly from A to Z; B column is Student Class C1:C10 --> Sorted accordingly...
  19. Manster

    Sorting selected columns by using VBA

    Hi expert, Sorry, I'm very novice in VBA. I have a problem regarding the sorting issue. Is it possible to sort selected columns by using VBA? Example: Once we click a button (in excel), A1:A10 --> Sorted accordingly from A to Z B1:B10 --> Not Sorted, it still maintain the values (This what I...
  20. Manster

    Check Box Concept [SOLVED]

    Wow, amazing+brilliant!! Thank you very much Master Narayan and Master Hui. Both of you trully Excel Ninja!!
  21. Manster

    Check Box Concept [SOLVED]

    Dear Hui, It doesn't mean we count/sum the values. Just shows the values B8 in F8 when we tick P1 (45), then we tick P2, suppose it shouldn't show the value in F8 (value is 6), then when we tick P3, it shows the value like we done in P1. After that, we tick P4 and shouldn't shows the value in...
  22. Manster

    Check Box Concept [SOLVED]

    Thanks Narayan replied my post. Your formula is approaching to the objective now. However, the objective is when we CLICK the P2 checkbox, normally it will show C8 value, but the objective is we don't want F8 showing the value in C8 without we untick the P2 box. Then, we continue as normal...
  23. Manster

    Check Box Concept [SOLVED]

    Here below my table that need solution from Chandoo's members. https://www.dropbox.com/s/xfb47rkvjwhgqb1/Book1.xlsx Current flow When we tick P1 on the check box, it will show 45. Followed by P2 will show 6, P3 shows 21 and last P4 shows 20. Problem: What is the formula if I want to...
  24. Manster

    Check Box Concept [SOLVED]

    Hii all, First of all I wish to thank who are now reading my post for this time. Actually, I need to understand the concept to do this task in excel as per below: Situation: I have 5 Check Boxes. (Developer>Insert>Form Control) A1 column is a main, which means the result will show...
  25. Manster

    complex IF statement

    Hi Narayan, I tried your statement..however seems like not follow the execute when I key in start from 50.98 up in B5. Here attached file for your further details. http://www.4shared.com/file/p2H8kB4H/MANUAL_2.html
Back
Top