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