User Profile
ankitsingh2063
Copper Contributor
Joined Mar 30, 2020
User Widgets
Recent Discussions
Importing Data from Google drive to Excel Power Query
Hello community, I am trying to write a Power Query to 'Get Data' from a Google Drive folder that contains multiple google sheets in the same format and same spreadsheet name across all files. I am not sure where to start and how to start.2.7KViews1like2CommentsMacro for filter in a pivot table
Hi Community, I am trying to create a macro that allows me to create a pivot table and the corresponding pivot chart. For example, within an organization, I have business units and for each business unit, there are regions. For each region, there is a % revenue of total in the pivot table. I need to create donut charts for the regional breakup of revenue for each of the 11 business units. I am still a beginner with respect to Macros, therefore, I recorded the macro. I have 2 questions: a. How do I create a repetitive macro that creates these 11 donut charts for me? b. When I run the macro, it gives me a Runtime Error '5' and it is not because of the folder name. How do I get rid of this? Thanks in advance Ankit706Views0likes0Comments
Recent Blog Articles
No content to show