Copy from 1 workbook to another one

Hello all,

I have 2 files. The first one is a logbook, every other day somebody goes to the next empty row and fill data on cells.
I'm trying to create a macro that, after filling a row, it recognizes the last row filled, copy the cells and paste it in another workbook, but in different locations (for example, A2 in the first one will be pasted in B2 in the second one.

See files attached.

Thanks in advance!

If someone has a solution for you, it helps to know if the "Destination" Workbook is open or not.
If it is not open, where is it? (Need full path)

If Both Workbooks are open, this should do it.
Change references if and where required.
The code is in the "Source" Workbook and macro is run from the "Source" Workbook.

Please Login or Register  to view this content.

Hi,
I had some problems and I tried to fix it by myself and now I'm stuck...
I uploaded a table with additional cells to be copied.
The cells from that specific row need to be copied to another workbook, on 1 specific row.
See attached the file named "FORUM - 8-7-20".
Thanks very much for the help.