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
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
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
Related:
- Creating a Macro
- Creating music apps - Guide
- Creating samsung account - Guide
- Spell number in excel without macro - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Create a snapchat account - Guide
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
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
Oct 31, 2012 at 01:08 PM
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.
Oct 31, 2012 at 07:34 PM