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 Nov 11, 2022
Arghya Adhikary
from Gauteng, South Africa

---

---

Offer to work on this project closes in 30 days!
Are you interested in this Opportunity?

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