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
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.
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