Hi everyone, really hoping you can help me on this one.
I'm creating a new Time in Motion sheet for my team, and I want to programme a Command Button so that when it's clicked on Sheet 1 it prompts for a reference number to be input, then that reference number is fed into (say) column D on Sheet 2, but then when the button is clicked again it adds the next reference number to the next empty row down in the column gradually generating a list.
The idea is that we have 8 different tasks performed throughout the day multiple times each so I want to create a list of the cases worked on for each task.
I tried searching the forum already and found a thread with this on it:
Dim ans As String
ans = InputBox("Enter a value", "Data Entry")
Range("D" & Sheets("Sheet2").Range("D" & Rows.Count).End(xlUp).Row + 1).Value = ans
... but it's not copying to sheet 2, and it's overwriting the first reference number that was input. I'd be really grateful for an explanation of what's wrong here too so I can learn from it - I'm brand spanking new to excel and have learned loads in the past week so I'm keen to learn more
Thanks so much xx
I'm creating a new Time in Motion sheet for my team, and I want to programme a Command Button so that when it's clicked on Sheet 1 it prompts for a reference number to be input, then that reference number is fed into (say) column D on Sheet 2, but then when the button is clicked again it adds the next reference number to the next empty row down in the column gradually generating a list.
The idea is that we have 8 different tasks performed throughout the day multiple times each so I want to create a list of the cases worked on for each task.
I tried searching the forum already and found a thread with this on it:
Dim ans As String
ans = InputBox("Enter a value", "Data Entry")
Range("D" & Sheets("Sheet2").Range("D" & Rows.Count).End(xlUp).Row + 1).Value = ans
... but it's not copying to sheet 2, and it's overwriting the first reference number that was input. I'd be really grateful for an explanation of what's wrong here too so I can learn from it - I'm brand spanking new to excel and have learned loads in the past week so I'm keen to learn more
Thanks so much xx