Overwriting data during transfer [Solved/Closed]

Report
Posts
8
Registration date
Friday June 15, 2018
Status
Member
Last seen
July 5, 2018
-
Posts
8
Registration date
Friday June 15, 2018
Status
Member
Last seen
July 5, 2018
-
Sir,
I had created vba code to transfer data from one workbook to another. it's working 1st time . but second time when I'm tapping the command button to transfer data it is overwriting the previous saved data. I want that when tap on command button it should submit data in the next empty row during each transfer.
Please help me for this problem.

2 replies


Add 1 to the variable if the variable is greater than 1!
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2669
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2020
446
Hi Mukul,

To find the first available row:
Dim lRow as integer
lRow=Range("A"&rows.count).end(xlup).offset(1,0).row

Best regards,
Trowa
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
8
Registration date
Friday June 15, 2018
Status
Member
Last seen
July 5, 2018

Thank you so much Sir !
now it is working perfectly.
thanks a lot.