hello everyone ,
I am very new in macros, so don't have much knowledge. I am trying to copy a selected row from Sheet named as sheet 1 to the next blank row on sheet named as data entry. But every time I am trying to do so, I am getting the same in Column A with Transpose set to True, but when I am setting transpose as False , getting Runtime error 1004 with paste method not correct.
I am attaching a sheet in which If I am using Module 2 I am getting the contents in same row on data entry sheet every time I select a new row on sheet 1 and press button 2, and when I am using module 3 I am getting the contents in next empty column every time I am pressing button Data Entry.
My requirement is that every-time I pressed a data entry button data should be copied in next blank row of Data entry sheet.
Hoping that someone help me out of this situation.
Thanks & Regards
Amandeep Singh
Bookmarks