Link to home
Create AccountLog in
Avatar of Wilder1626
Wilder1626Flag for Canada

asked on

VBA - Before After macro

Hi

I have a Excel file with 3 sheets:
Before
After
Recap

I need to validate the differences between the Before and After sheet and put transfer the results in sheet called  Recap.

In attachment, if you look at sheet Before in the Test4 column, you will see some values. I need to search for the values not showing in sheet After in the same column and transfer the values missing in the sheet Recap column A starting at Row 2 going down.

I need to also do the same thing with Sheet After column Test 4 not showing in Sheet Before column Tes4. Result of missing value will go into Recap column B.

How can i do that?

In attachment you will have a sample and the final result i should get in the Recap sheet.
Thanks
before-after.xlsm
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Wilder1626

ASKER

Thanks for your help. This is what i was looking for.