Creating a Macro

[Closed]
Report
Posts
3
Registration date
Saturday October 27, 2012
Status
Member
Last seen
October 31, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I am trying to remember how to create a macro that will allow me to compare values in column A from sheet 1 to column A on sheet2 and if the value is different then past the value in Column A of sheet 3. I can not even remember how to get started with the formula but so if someone can help me get started it would be extremely helpful.

I the biggest thing I am trying to remember to how to write the formula in VB and the results to show on sheet3.

Thank you,
Daeyiele

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
if u know how to write formula, then you can start macro recorder, manually type in formula and stop the recorder. That will show you how your formula appears in vba
Posts
3
Registration date
Saturday October 27, 2012
Status
Member
Last seen
October 31, 2012

I have done that but not getting the results I am looking for.

What I need it to do is take Column B on Sheet1 and compare it to Column B on Sheet2, if the values from Sheet2 do not match any of the values on Sheet1 paste the values from sheet2 that are different.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
could you share what you have done so far so one can see how to improve upon it