|You have done a great job of describing the purpose and the end, but I think there may be one thing missing. |
You gave us the code that puts the "1' in the next available cell in Column C, but not the code that tells us where the date and time are placed.
If we can assume that the Time is placed in the next available cell in Column B, then you can place the values in the same row by altering the Column your code looks at and Offset values it uses.
Since the syntax is .Offset(RowOffset, ColumnOffset) right now your code finds the last used cell in Column C and Offsets 1 Row and 0 Columns. i.e. the next empty cell in Column C.
This line will find the last used cell in Column B and Offset 0 rows and X columns, where X should be set to the (Column Number - 2) that you want the value placed in.
For example, if the "1" should be placed in Column 3 ("C") for a given button, X should be 1, which means Offset 1 Column from B.
Sheets("TALLY").Cells(Rows.Count, "B").End(xlUp).Offset(0, X).Value = "1"
i.e. Find the last cell in Column B and Offset 0 rows and X columns.