two way column mirroring VBA code

[lj_excel]

Hi all!

completely new to VBA. I have been searching and trying to learn a way to have two way mirrored columns on a master sheet and multiple sub sheets.

I have found a VBA code for two way mirroring individual cells but I am still searching or trying to figure out how to two way mirror columns.

MASTER (SHEET1) COLUMN A:B = SHEET2 COLUMN A:B
MASTER (SHEET1) COLUMN C:D = SHEET3 COLUMN A:B
MASTER (SHEET1) COLUMN E:F = SHEET 4 COLUMN A:B

Hope this makes sense and someone can help me. Thank you in advance for your time.

[lj_excel]

I found this code on another post.

Please Login or Register  to view this content.

what would be the proper syntax for a whole column instead of a single cell?