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!
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...
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.
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?
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"...
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.
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 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...
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!
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...
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.
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...
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?
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 =...
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...
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...
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...
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...
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...
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 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