Hello there,
New on this forum and looking for a hand, I didnt touch VBA since a while.
Most of the time im just using formula, but this time I have to manage >300.000 data in 1 sheet!!
For my job I analyse for every month data from a datalogger recorded every 5min (it is a solar photovoltaic installation with battery).
This datalogger give me 8640 rows and 36 columns every month to analyse!!
I collect these data a couple of time a month on a 1st sheet, and I update manually a 2nd sheet to do my analyses.
So Im trying to find a solution to update automaticly my 2nd sheet when I add data on the 1st one.
The update would consist of :
1/ Update the second sheet with some of the columns from the 1st sheet
2/ Update a chart showing the load every 5 min for all the period (max 1month)
3/ Update a table to get the maximum of 5 data selected for every day
Do you have any advice, thread already speaking about that, or macro to send.
I attache my document.
Thank you in advance for your hand
Julien
Bookmarks