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 4478 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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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