On the first sheet (1) I want to type a list of ID numbers into a sheet down the page. i.e.
12345
35678
67832
...
On a second sheet (2) I already have a mailing list, where there are thousands of people listed down the page i.e<pre>Column A Column B Column C
john Smith 12345 12 Long St
Stan Black 22345 1 Short way</pre>
I would like to run something on sheet (1) to locate all those ID numbers listed on this sheet and actually flag them in some way on sheet (2). ie in the case above the result may be<pre>Col A Column B Column C Column D
X john Smith 12345 12 Long St
Stan Black 22345 1 Short way</pre>Where a new column is inserted and an X shown beside those that match the list on Sheet(1).
I understand this is probably very difficult but I would appreciate any help. I fiddled with Loops but got totally confused in how to move between the two pages and increment the row I am searching from. Also, if the numbers on sheet (1) end then the loop should end.
Matt
This message was edited by Juan Pablo G. on 2003-02-13 22:43
12345
35678
67832
...
On a second sheet (2) I already have a mailing list, where there are thousands of people listed down the page i.e<pre>Column A Column B Column C
john Smith 12345 12 Long St
Stan Black 22345 1 Short way</pre>
I would like to run something on sheet (1) to locate all those ID numbers listed on this sheet and actually flag them in some way on sheet (2). ie in the case above the result may be<pre>Col A Column B Column C Column D
X john Smith 12345 12 Long St
Stan Black 22345 1 Short way</pre>Where a new column is inserted and an X shown beside those that match the list on Sheet(1).
I understand this is probably very difficult but I would appreciate any help. I fiddled with Loops but got totally confused in how to move between the two pages and increment the row I am searching from. Also, if the numbers on sheet (1) end then the loop should end.
Matt
This message was edited by Juan Pablo G. on 2003-02-13 22:43
