Fill value Dased on last cell with timestamp in Col B. Cut/Paste or PasteSpecial

[ShelbyMan]

Hello....


I have been trying to figure this issue out and I have spent many hours with no resolution, so I am coming here for some guidance. I need a macro to do this

I essentially have an Excel File in .xls format that has a login userform and a log sheet that records the username in Col B and the date/time in Column C.

I have userform with a text box that the user type a number in. Once they click the command button, it copies the textbox value onto the worksheet to cell J2.

That value from the text box, I need to go to the right of the last time stamp. and so on and so on until another timestamp is recorded. Then it will go to the 1st cell to the right of that time stamp etc....

Any ideas on how I can accomplish this via macro?

BookTest.xls

[AlphaFrog]

It may have been helpful to include the userform in the example workbook.

This example will put the textbox value in the next empty cell in row 15.

Please Login or Register  to view this content.

[ShelbyMan]

Thanks AlphaFrog!

I added the UserForm to the worksheet:
Sheet1=Excel Login and Date/TimeStamps in Column A & B. I am manually entering this info into this workbook. The real workbook uses a macro.
Sheet2=Is the Master List
Sheet3= Is the filtered list based on the 6 digit SO entered into the Text Box and after they click on the "Copy Button" in the UserForm.

I have 2 options:
1) Either use the 6 digit number from the text box after they click the copy button or....
2) Cut/Paste or Paste Special the value in Cell J2 in Sheet 3. After the cell is copied to the cell then, J2 will have it's contents cleared.

Your code works fine for a single login but when another login occurs, I need the value down 1 row. starting at column C3 and across until the 3rd login occurs, which will start at C4 etc...

What we are trying to do is to log each user and tracking what sales orders they are making tags for.....We have been having issues and trying to pinpoint who is doing what.

As a side note, any way to only show actual data in the userform instead of the blank cells also? I am currently using a Sheet range for the data in the master file.

I appreciate your time and assistance.
Thank YOU!
BookTest.xlsm