Creating a Macro

Closed
Daeyiele
Posts
3
Registration date
Saturday October 27, 2012
Status
Member
Last seen
October 31, 2012
- Oct 27, 2012 at 01:28 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Oct 31, 2012 at 07:34 PM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Oct 28, 2012 at 12:16 PM
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
0
Daeyiele
Posts
3
Registration date
Saturday October 27, 2012
Status
Member
Last seen
October 31, 2012

Oct 31, 2012 at 01:08 PM
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.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Oct 31, 2012 at 07:34 PM
could you share what you have done so far so one can see how to improve upon it
0