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

[ROHAN999]

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

[ROHAN999]

Plz somebody assist

[ROHAN999]

Shall i modify or upload other sample

[ROHAN999]

Plz somebody take it up

[MarvinP]

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.

[Vraag en antwoord]

There is no structure in your example file. A possible solution in the appendix.

Please Login or Register  to view this content.

Sample data.xls

[ROHAN999]

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.

[Vraag en antwoord]

with a small change

Please Login or Register  to view this content.

[ROHAN999]

.Cells(1).CurrentRegion.Sort .Cells(1), , , , , , , 1

Error msg coming here sir
Unable to get the sort property of range claśs

Except this code is working fine

[Vraag en antwoord]

If your data does not start in A1 then you will have to adjust the range. Cells(1) is Range("A1")

https://www.excel-easy.com/vba/examp...entregion.html

[ROHAN999]

Thank you sir