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 ID's. 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 macro's in the Data Transpose file for your convenience. Maybe best to be ignored :)
About the recuiterMember since Nov 11, 2022 Arghya Adhikary
from Gauteng, South Africa