VBA to select next row if first has been filled.

[jascheman]

Hi There,

First time post:

I am creating a Time Clock for employee's to clock in and out. I currently have a "clock in" button with attached macro that asks for an employee number and records the number, current system time, and date on a separate worksheet("Entry Log"). My issue is that I want the next employee that selects the "clock in" button to record their data on the next row.

I know I currently have is coded directly to the cells, but not sure how to write it differently and have it work.

The end goal is also to have each employee's data linked to their own time sheet in a separate worksheet, that is already being created with the Clock in Macro. So any Ideas on this are appreciated.

Thanks for any & help

Please Login or Register  to view this content.

[hectop]

As I understand it, you want to find the last row used on a sheet. You can use this code.
Adjust the sheet reference as required. This assumes that you will always have something in the first column. To get the next (blank) column, just add +1 to the end of the code line.

Please Login or Register  to view this content.

If this is what you're looking for, please click on the add reputation link

[Philb1]

Hi jascheman
If you want to find the first empty row you can use

Please Login or Register  to view this content.

The message box will display the row number below the last used row on the Entry Log Worksheet.
It looks up column A to get it.
Your code is going to produce a new worksheet for every entry.

[jascheman]

Thanks hectop and Philb1,

That is the info I needed! Problem solved!!