Hello,
I have what I think to be a tricky VBA job.
I have two tables, one with single names, and the other with full names. I am going to assign a numerical sum based on the combination of single names found in full names. For example: Bob = 5, Michael = 6, Scott = 7. With name and number residing in two columns in one table. This is the "lookup" range. The other table contains full names. The column with full names would be range "Flname." When I perform a lookup, I would like to sum and post the results of the relative values in range "sumrng." So, the name in flname "Bob Michael Scott" would sum to 18, "Scott Michael" to 13, "Bob Scott" to 12, and "Michael Scott" to 13 in sumrng.
This seems like something that is possible in VBA... but I have searched the interwebs far and wide and I couldn't think of the best way to describe this for my search parameters.
If anyone knows if this is possible, please let me know. All you VBAers out there are truly talented people.
I have what I think to be a tricky VBA job.
I have two tables, one with single names, and the other with full names. I am going to assign a numerical sum based on the combination of single names found in full names. For example: Bob = 5, Michael = 6, Scott = 7. With name and number residing in two columns in one table. This is the "lookup" range. The other table contains full names. The column with full names would be range "Flname." When I perform a lookup, I would like to sum and post the results of the relative values in range "sumrng." So, the name in flname "Bob Michael Scott" would sum to 18, "Scott Michael" to 13, "Bob Scott" to 12, and "Michael Scott" to 13 in sumrng.
This seems like something that is possible in VBA... but I have searched the interwebs far and wide and I couldn't think of the best way to describe this for my search parameters.
If anyone knows if this is possible, please let me know. All you VBAers out there are truly talented people.