Paste the Data in different row or column through User Form

[Nisha Dhawan]

Hello Everyone,

I am creating a form in sheet 1 that I would like the data to be captured and saved in sheet 2. However, I am having a hard time with finding the next blank row n order to save the data. Codes that i have used either paste the data on the same row or paste the data on the next row but to a different column (instead of a it goes to b column). Any thoughts on how to correct this?

Thanks
Nisha

[Nisar.mohammed]

Dear Friend,
Would you like to Post Your File So it is easy to help you