Transfer Userform data on 1 worksheet to different worksheet (empty row = wrong sheet)

My UserForm is on sheet1 ("Dashboard") - but when the command button is clicked, I want the values to go the next empty row on the 3rd worksheet ("Data"), which is hidden.

The code I have works half way - it will transfer to the correct sheet, but it's reading the next empty row from the first sheet, the Dashboard, not from the Data worksheet.

Please Login or Register  to view this content.

Thanks!!

-HeyInKy

Please Login or Register  to view this content.

Perfect! Thanks you.