Hi there,
To start off, I'm not too bad with excel, but I'm not very familiar with macros.
Scenario:
- Working from 3 sheets (1)Payroll sheet (current), (2)Payroll sheet (previous period), (3)Values which have changed when comparing (1) and (2)
My dilemma:
The issue is that when new entries are added to (1), it creates a mismatch with (2). I am thinking maybe a macro that runs from an if statement which compares the name fields for each entry and then runs a macro that adds a blank row so that differences will be easier to isolate.
if('sheet1!'a1='sheet2!'a1,,run macro)
Am I on point or even at that realistic in my assumption or is there another easier way to get this to work that I am not thinking of.....


PS, I hope this makes some sort of sense!
**ALSO! The rule needs to apply uniqely to about 405,000 records...
To start off, I'm not too bad with excel, but I'm not very familiar with macros.
Scenario:
- Working from 3 sheets (1)Payroll sheet (current), (2)Payroll sheet (previous period), (3)Values which have changed when comparing (1) and (2)
My dilemma:
The issue is that when new entries are added to (1), it creates a mismatch with (2). I am thinking maybe a macro that runs from an if statement which compares the name fields for each entry and then runs a macro that adds a blank row so that differences will be easier to isolate.
if('sheet1!'a1='sheet2!'a1,,run macro)
Am I on point or even at that realistic in my assumption or is there another easier way to get this to work that I am not thinking of.....
PS, I hope this makes some sort of sense!
**ALSO! The rule needs to apply uniqely to about 405,000 records...