Copy paste to last empty row

[moonbreakker]

Hello,

My previous post was may be complicated.

1. I want to copy a row in sheet2 to sheet1.
Just single row.. Sheet1 has sr nos., i dont care much about about it, i will copy paste date using today().

In sheet 2 i need a macro that can copy a single rown and post it in sheet1, the last free row where NO data exists. Some may be blank like no date, no mechanic and service, no amount etc,... but entire blank row is our row where i need to paste data..

So excel has 2 sheets only. As attached. Need to copy from sheet "main" to 1


I just need code to copy paste from sheet 2 to sheet 1 into LAST EMPTY ROW..
Thanks

[alansidman]

Unable to open your file. Get the attached message.

Capture.PNG

[alansidman]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.