Overwriting data during transfer [Solved]

MUKUL_1308 8 Posts Friday June 15, 2018Registration date July 5, 2018 Last seen - Jun 21, 2018 at 06:31 PM - Latest reply: MUKUL_1308 8 Posts Friday June 15, 2018Registration date July 5, 2018 Last seen
- Jul 2, 2018 at 12:42 AM
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.
See more 

Your reply

3 replies

Best answer
ac3mark 10542 Posts Monday June 3, 2013Registration dateModeratorStatus September 24, 2018 Last seen - Jun 21, 2018 at 08:32 PM
1
Thank you
Add 1 to the variable if the variable is greater than 1!

Thank you, ac3mark 1

Something to say? Add comment

CCM has helped 1801 users this month

Respond to ac3mark
Best answer
TrowaD 2433 Posts Sunday September 12, 2010Registration dateModeratorStatus September 17, 2018 Last seen - Updated by TrowaD on 26/06/18 at 12:01 PM
1
Thank you
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

Thank you, TrowaD 1

Something to say? Add comment

CCM has helped 1801 users this month

MUKUL_1308 8 Posts Friday June 15, 2018Registration date July 5, 2018 Last seen - Jul 2, 2018 at 12:42 AM
Thank you so much Sir !
now it is working perfectly.
thanks a lot.
Respond to TrowaD