User Profile

shibshib

Copper Contributor

Joined Mar 15, 2023

3 Posts

View All Badges

User Widgets

Recent Discussions

Re: Macros and VBA to export data from excel file in specific order into a new excel spreadsheet
Thank you so much for your help. Unfortunately, I couldn't make it work so I found another solution which was much easier, so I created custom function in Power Query.
Apr 04, 2023 Place Excel
3.6KViews
0likes
0Comments
Re: Macros and VBA to export data from excel file in specific order into a new excel spreadsheet
Thank you, it doesn't show month and year. The output shows as below: A 10 0 A 60 0 A 101 0 B 20 0 B 70 0 B 201 0 C 30 0 C 80 0 C 202 0 D 40 0 D 90 0 D 302 0
Mar 20, 2023 Place Excel
3.8KViews
0likes
2Comments
Macros and VBA to export data from excel file in specific order into a new excel spreadsheet
Greetings, I need to rearrange my data to link it to my PowerBI Dashboard. I was wondering if you could advise me how to do it? I have 75 spreadsheets with 177 rows each. Is there any way to automate the process with Macros and VBA? Current data format: Dec-22 Feb-23 Mar-23 Category Budget Budget Budget A 10 60 101 B 20 70 201 C 30 80 202 D 40 90 302 E 50 100 400 Power BI Data foramt requires: Category Budget Month Year A 10 December 2022 B 20 December 2022 C 30 December 2022 D 40 December 2022 E 50 December 2022 A 60 February 2023 B 70 February 2023 C 80 February 2023 D 90 February 2023 E 100 February 2023 A 101 March 2023 B 201 March 2023 C 202 March 2023 D 302 March 2023 E 400 March 2023
Mar 15, 2023 Place Excel
excel
Macros and VBA
4.1KViews
0likes
4Comments

Recent Blog Articles

No content to show