add info
 

If I have two spreadsheets, and on Total spreadsheet, I have a column (c) of
Police vehicle # and on the other Complete list spreadsheet, I have a column
(c) of police #'s with other infor. I want to look on column C in the Total
spreadsheet and search on Complete spreadsheet col (c) and if there is no
match I want to add this number at the end of column c (Complete
spreadsheet), is there an easy way to do this? I do no know how to write
code.

add info
 

Please upload your workbook on http://cjoint.com

You will need some VBA macro code I can write.

Cheers
--
AP

"Pam C" a écrit dans le message de
...
If I have two spreadsheets, and on Total spreadsheet, I have a column (c)
of
Police vehicle # and on the other Complete list spreadsheet, I have a
column
(c) of police #'s with other infor. I want to look on column C in the
Total
spreadsheet and search on Complete spreadsheet col (c) and if there is no
match I want to add this number at the end of column c (Complete
spreadsheet), is there an easy way to do this? I do no know how to write
code.