• 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

    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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. Manster

    complex IF statement

    Hi... How can I create a function/formula in this case: If either values of 35.54 or 45.54 show up, it should be subtract to 0.94. "=If(or(35.54,45.54),35.54-0.94,35.54-0.94)" I realize that this function is incorrect,so how can I create the right function which follow the sentence...
  7. Manster

    Need your tips..

    Hi..I'm a beginner in excel and I need solution about my task. Anyone know how to breakdown the value using excel? Example: 100.1 = 50+50+0.1 Situation is I want to create formula when I enter the value "100.1" for example , automatically its breakdown the values like "50+50+0.1". TQ
Back
Top