Excel 2010 - IF statement as event to trigger macro?

[sdtownse]

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...

 

[Garf13LD]

You can use a vlookup to check for difference.
As for you If macro, it doesn't exist.
You can however get macro to add rows for you though.

 

[sdtownse]

Not sure how to use vlookup in that way, I hate to be a pest, but any chance you could provide an example?

Thanks!