sdownes1
09-25-2008, 08:37 AM
I am a novice and I am trying to use VBA to compare two columns (cell by cell) and place a number in the third column. I am transferring a large number of employees (approx 6000) between companies and need to select the new benefits packages the employees are to recieve in the new company.
I have tried IF statements and Select Case, to no avail. I have attached a file with a sample of data.
Written out, what I am attempting to do is: (see attached file)
IF Column F = ESI AND Column G = EQN THEN column H would be "1"
I believed that this was an easy Select Case but I can't get it to work when comparing TWO columns and placing a number in a third column!:banghead:
Any advice to get me "jump started" on writing a select case statement would be greatly appreciated!
I have tried IF statements and Select Case, to no avail. I have attached a file with a sample of data.
Written out, what I am attempting to do is: (see attached file)
IF Column F = ESI AND Column G = EQN THEN column H would be "1"
I believed that this was an easy Select Case but I can't get it to work when comparing TWO columns and placing a number in a third column!:banghead:
Any advice to get me "jump started" on writing a select case statement would be greatly appreciated!