Macro - Copy values in column if any of them changes

[Imbo]

I'm a VBA neophyte and got stuck on a macro.


I have three excel sheets within the same workbook structured as a table. For each of these tables I am only interested in one column (so 3 columns in all, one per sheet).
I would like to insert in a fourth sheet in a row all the values of these 3 columns if only 1 value between these columns changes, regardless of the sheet.


Thank you very much!

[georgiboy]

Hi Imbo,

Could you not acieve this with cell links?

Cheers