Add New Records Horizontally Not Vertically ?

.
This is the layout of the sheet where new entries will be added :

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Item ID	Equipment Piece	Out Time	In Time	Time Used	Equipment Piece	Out Time	In Time	Time Used	Equipment Piece	Out Time	In Time	Time Used	Equipment Piece	Out Time	In Time
2	A123	Drill 1	7:33	14:21	=D2-C2	Drill 23	15:00	15:38		Drill 18	16:00
3	A456	Drill 2	9:14	10:20	=D3-C3	Drill 6	11:11
4	A789	Drill 3	9:00	9:29	=D4-C4
5

I'm trying to determine how to add new CHECK OUT / CHECK IN times across a row rather than down a column.

The workbook will utilize a UserForm for new data entry.

The form will require selecting the ITEM ID ... then the EQUIPMENT PIECE the item is used with and finally the CHECK OUT or CHECK IN time. For this example let's say the ITEM ID refers to a drill bit. Each drill bit is different from all
the others and can be used in several different drills.

The employee checks out a specific drill bit and needs to enter the drill ID and the check out time. Then when the project is complete, they need to check the drill bit back in, placing the check in time immediately after their check out time.

I'm not certain how to accomplish the coding for use across a row.

Can you help ?

Without seeing your userform it's difficult to post code. However, when you're counting down a column (yes, I know, you want to count across a row but bear with me) you'd use a variable to count your way down the rows, like so:

Please Login or Register  to view this content.

However, since you want to count across the row you can use CELLS() instead, like so:

Please Login or Register  to view this content.

Unsure if this is helpful, if not then you'll def need to post the code you've currently got for data entry.


EDIT: I've just seen how many posts you've got on this forum. There's no way the above is helpful in any way cos you def know this already. Please post the code you're currently using.

.
If I were to use the "vertical" means of entering new data (without a means of going back to amend existing data, this is the basic code I would utilize :

Please Login or Register  to view this content.

I'm really not certain how to approach this project 'horizontally'. Please excuse my lack of knowledge in that regard.

Are you searching for the item ID and then wanting to add just time out and time returned?

Edit: I see now what you doing with the horizontal entries

.
nigelog :

Yes

Apologies for delay
from your simple database code

Please Login or Register  to view this content.

2 can be substituted for a "This Row" variable