![]() |
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