VBA Macro needed with a loop to transpose some data

I have an excel file with hourly prices in it per day per sheet (Auction Clearing Price [EUR/MWh]). Each sheet is a day with multiple Auction IDs. Each workfile a month.

I need a VBA code with a transpose and a loop so that I can extract the data (Used to be able to do it myself). The data, Auction Clearing Price [EUR/MWh], should come out horizontal with the day and the Auction ID to the left of it.

I will share the original data sheet and the example how the result should look with shortlisted candidates. Each Auction ID should have its own sheet. I have made the first 2.

In short, I need every Auction Clearing Price [EUR/MWh] of every Auction ID in a horizontal format.

Please only apply if you can do this like in an hour or so as it really should take you no more then 10 minutes to make the code.

I am okay with tweaking it myself to extract and so forth.

ps. no need for you to take into account the daylight saving times effects in previous month.
ps2 I have added some old macros in the Data Transpose file for your convenience. Maybe best to be ignored :)
About the recuiter
Member since Sep 8, 2017
Milan
from Zuid-Holland, Netherlands

---

---

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions