PDA

View Full Version : Macro - Copy values in column if any of them changes



Imbo
11-19-2021, 02:42 AM
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
11-23-2021, 02:58 AM
Hi Imbo,

Could you not acieve this with cell links?

Cheers