vba to subtract two column values and add new too if added in second sheet

sameple workbook with sheets of sample data and result is attached ,kindly assist


Subtract sheet 2 values from sheet 1 and give them in result

Hi Rohan,

Looking at your problem, it doesn't make sense to me. You have two sheets with Employee numbers and Pay on each sheet. Are these sheets different days of work? The Emp No on each sheet may not be the same. If you subtract the values of sheet 2 from sheet 1 the result for employee 9 should be negative 2 and not positive 2.


So - if your result sheet is correct, you want to add the values from both sheets but that is not what you suggest in your question.


This may be why you aren't getting much help with this.

thanx vraag

your code works fine as the result given

but by my mistake i left (-) minus sign in one


actually the result would be :

emp no ... pay
2 ... -9
9 ... 2
13 ... 3
124 ... 4


As employee 2 is not there in sheet 2 so it will be subtracted from zero so negative

rest everything is fine.

Kindly modify the code a bit. i apologize for my mistake in showing result.