Automatically insert new rows to linked worksheet

Hi everyone,

I have looked for this solution on the forum but I could not find anything relevant.

I have different worksheets in one single excel file. I want one of them to be the master. The latter would compile each data present in the other sheets. Basically, I want that every time I add a new value in one of my subsheets, excel adds it to the “mastersheet”.

For now, I have them automatically updated but when I insert a new value, it doesn’t update on the mastersheet.

Apologies for any mistakes, I am new to excel and VBA, but I seek to improve my knowledge.

Thanks you for your help

Salut !

Read the yellow banner at the top of this page …