i have a question.
In my attached file, there are 2 worksheets; namely "DATA" & "BREAKDOWN".
I have a series of data in my WOrksheet "DATA"
I need to have a breakdown of these data, into WOrksheet "BREAKDOWN", with the ability of the user to specify which category of data to generate, refer to my "BREAKDOWN" worksheet for a view.
the criteria is for me to click the generate button in the "BREAKDOWN" worksheet and the data would be generated based on the data in the "DATA" worksheet, and everytime it generates, it will includes any new data updates.
bear in mind that the data is going to be used for 7 days 24 hrs.. and the data from the last hour would piled up continuously.. hence, the data in the "BREAKDOWN" would gradually build up as well.
can anyone help me with the coding?