Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare info in on sheet to info in another? | Excel Discussion (Misc queries) | |||
Concatenating info from several cells into the one above | Excel Discussion (Misc queries) | |||
Reflecting info between an excel file and a word one or two excel file. | Excel Worksheet Functions | |||
Reflecting info between an excel file and a word one or two excel file. | Links and Linking in Excel | |||
Reflecting info between an excel file and a word one or two excel file. | Excel Discussion (Misc queries) |