Hi,
Let me explain
I have a column F with time data in it. The time is in this format 24:00 (24 hour). i want to know how many no. of rows have been covered in each minute.
for example in cells,
F4 21:28
F5 21:28
F6 21:28
F7 21:28
F8 21:28
F9 21:28
F4 21:29
in 28th minute 6 rows were covered.
I want a VBA Code that counts the no. of rows covered in each minute and write them in column H from cell H4. Please also note that in column F time data is not being added manually rather it is being updated from external source automatically.
Let i starts importing data at 21:28 then VBA Code should took 28 as reference and keep counting until time changes to 21:29. Code should write count data for 28th minute in H4. Then again it should start recounting from 29th minute as long as time changes to 21:30. and write data for 29th minute in H5 and so on.
(there is solution of using Pivot Table, but i don't need that because data in pivot table does not updates as data in column F changes automatically Live. So, i want such a VBA code that counts no. of rows covered in every passing minute and keep writing it from cell H4 onward. Also this VBA code should work with this live updating data)
(I have attached a file for further clarification)
Bookmarks