cOPY PASTE FROM SHEET 2 TO SHEET1, last row

[moonbreakker]

Hello,

I have attached a workook.

I need to copy 1 single row from sheet2 to sheet1.. ON LAST empty row
I want to skip A of sr no. I will just drag manually. Column B of date can be =today()

And copy paste C to E from sheet2 to sheet1 starting to look from blank rows after row 5.. (1 to 4 is my header)


Thanks in advance.

[rtcwlomax]

It is not very clear what you are trying to achieve. I would suggest that you record a macro and cut/copy/paste the cells manually to show how you want it to work.

(View > Macros > Record Macro > Do Something > Stop Recording)

The macro will be saved in the workbook, so just post it again.