brennaboy
07-08-2011, 09:30 AM
Hi,
I am trying to write a macro and I think I am going about it the wrong way. Here is an example of what I am trying to do:
Column A contains 500 cells of unique data
Column B contains 100 cells
I want to write a macro so that it takes the first cell of Column B and looks to see if it exisit in Column A. If it does not, then it highlights it, say Bold.
I then moves on to the second cell of Column B and goes down the list until the end.
Col B will remain static, but I will be pasting new data into Column A and re-running this process.
I was thinking that I will need to do a loop within a loop, but I can't quite picture how it should work.
Can anyone help me please?
Thanks,
B.
I am trying to write a macro and I think I am going about it the wrong way. Here is an example of what I am trying to do:
Column A contains 500 cells of unique data
Column B contains 100 cells
I want to write a macro so that it takes the first cell of Column B and looks to see if it exisit in Column A. If it does not, then it highlights it, say Bold.
I then moves on to the second cell of Column B and goes down the list until the end.
Col B will remain static, but I will be pasting new data into Column A and re-running this process.
I was thinking that I will need to do a loop within a loop, but I can't quite picture how it should work.
Can anyone help me please?
Thanks,
B.