ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Repeating a loop (https://www.excelbanter.com/excel-programming/401940-repeating-loop.html)

[email protected]

Repeating a loop
 
Hi
I am importing data that is taken hourly for and uncertain amount of
time. I need to take a total of flow rate daily and I wrote this:

x = 2
Do While Cells(x, 1).Value = Cells(x + 1, 1).Value
Cells(x + 1, 10).Value = Cells(x + 1, 9).Value + Cells(x,
10).Value
x = x + 1

Loop

So I'm comparing each entry's date to each other. But it only works
for the first 24 hours. I know its because it gets to the point where
the day does not equal each other but I cannot figure out a way to
over come it. Can anyone help me?





All times are GMT +1. The time now is 09:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com