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