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!