VBA help with time results

Tucker92

Board Regular
Joined
Jun 7, 2018
Messages
53
Hi Everyone,

I am trying to create a spreadsheet to work with my timer. At the moment my timer is ok and i can lap it and send the data to the active cells. My issue is that the amount of rows is varying. I write a number in the first column from one to however many i have. Im a bit stuck because when i get to the bottom its keeps going.

I was wondering if there is a way to check if the 1st column is empty and then start over at the top in the next column and then work my way down again. then do this over again until i get to 10 instances.

Thank you in advance for any help or advice

Here is an example of my spreadsheet of data

175
100:28
285
200:56
395
300:45

<tbody>
</tbody>

When i get to the bottom i want it to go back up to one in the next column
 
Last edited:

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Forum statistics

Threads
1,089,270
Messages
5,407,302
Members
403,131
Latest member
Lewas2019

This Week's Hot Topics

Top