VBA Code Paste Next empty Cell other sheet

hi friends,

i have workbook with 4 sheets
and table in each sheets
When I enter data in a table I want it to copy to a concentrated table that is in another sheet.
If nothing is listed it will not be copied.
How to make it copy the content always to a cell without content
Thank you for your smart help

One can write a workheet_Change event procedure to copy any new value in any given column to the next empty spot in another table/column location. If you share a sample file as per the yellow banner above we can assist.

hi,
attaced
thanks

When you hit enter on column C, the data in that row will populate into the all sheet. The code is in the sheet modules

Please Login or Register  to view this content.

Genius! Thank you very much.
If I delete it is not deleted from the "ALL" issue, how can I delete / synchronize it with any change in the other issue?
And one last question at your disposal.
How do I do the same thing but with several booklets that are on the same network-
That all the data will reach one issue
Thanks!

? help

Anyone know?

please helppp

??????????