Good Morning,

Currently I have one master sheet of employees. Every time I update this sheet I want the rest of the sheets to update with as well. This means I am constantly adding and removing columns.

I am currently using this formula:

=IF(OFFSET('Staff List'!$A$1,ROW(A1)-1,COLUMN(A1)-1)=0,"",OFFSET('Staff List'!$A$1,ROW(A1)-1,COLUMN(A1)-1))

However it only mirrors the values. I need to have the formatting mirrored as well.

I realize that I need to use VBA as formulas are not complex enough.Example.xlsx