N
njuneardave
Hi......big question here:
please look at this chart:
SHEET1 SHEET2
Shape | Color Shape | Color
------------------------
-------------------------
box blue box
blue
box red box
red
box pink box
pink
circle blue cirlcle
blue
circle green circle
green
circle pink circle
aquamarine
circle red circle
red
SHEET3
Shape | Color
---------------------------
circle pink
so, I want to verify that the contents in Sheet1 are the same as Sheet
2....if not, I want to record the changes in sheet3 (only show the
changes). How do I search Sheet2 for pink circle? What function would
I use?
please look at this chart:
SHEET1 SHEET2
Shape | Color Shape | Color
------------------------
-------------------------
box blue box
blue
box red box
red
box pink box
pink
circle blue cirlcle
blue
circle green circle
green
circle pink circle
aquamarine
circle red circle
red
SHEET3
Shape | Color
---------------------------
circle pink
so, I want to verify that the contents in Sheet1 are the same as Sheet
2....if not, I want to record the changes in sheet3 (only show the
changes). How do I search Sheet2 for pink circle? What function would
I use?