Hi -

I am relatively new to macro. I have one workbook with three sheets. I would like a macro that will compare Sheet1 ('Onboarded') and Sheet3 ('Attendance'). Sheet3 should have row A that matches row A of Sheet1. However, when a new column is added to Sheet1, I want it to add into Sheet3 in the same place, with the rest of the column empty.

Ex:
Sheet 1

1. blah blah blah blah blah
2. blah blah blah blah blah
3. bleh blah blah blah blah
4. blah blah blah blah blah
5. blah blah blah blah blah

Sheet 2

1. blah bleh bleh bleh bleh
2. blah bleh bleh bleh bleh
3. bleh bleh bleh bleh bleh
4. blah bleh bleh bleh bleh

After:

Sheet 2

1. blah bleh bleh bleh bleh
2. blah bleh bleh bleh bleh
3. bleh
4. blah bleh bleh bleh bleh
5. blah bleh bleh bleh bleh

Can anyone offer something?

Thank you!