Data from Userform not going into last empty cell

[hstarr2021]

I need a little help! The attached workbook has a user form that someone enters daily data into. Everything works fine but instead of the data going into the last blank cell of the correct column it overwrites data on another row already containing data. The data needs to go into sheet 1. Can anyone tell me what I am doing wrong?

[berlan]

Hi,

you need to change the line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

or alternatively,

Please Login or Register  to view this content.

as Sheet1 in this case refers to the sheet "Monthly Metrics Summary" and not "Sheet1"

[Debraj Roy]

Please change the code for Command Button 1 to this..

Please Login or Register  to view this content.

Sheet1 and Sheets("Sheet1") are not same thing.. One is Sheets Code Name and another is Sheet's Display name..
Sheet(1) is Index Of that Sheet

[hstarr2021]

Dbraj.....you are awesome. I have been struggling with this all day!