Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
nonduplicative merge
I have several sheets with the following 2 columns:
PersonnelCode Name The sheets share some, but not all, information. Generally each sheet has some PersonnelCode-Name pairs that are unique to the sheet. The PersonnelCode and Name sets are themselves one-to-one. I would like to write a macro that will produce, in 2 corresponding columns on a master sheet, a nonduplicative merge of all the columns of PersonnelCode and Name information. I can do this with hooks into Excel from some external DB/data processing apps, but would like to do it all from within Excel if I can. Many thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge two excel files like in word mail merge | Excel Discussion (Misc queries) | |||
Zip codes in mail merge - first digit doesn't display in merge | Excel Discussion (Misc queries) | |||
mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
Merge =( formula should retain fraction type numbers after merge. | Excel Worksheet Functions | |||
how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) |