I haven't done a thing in VBA for over a year, and now have to quickly come up with a solution to the following problem.
I have a bunch of data - names, addresses, etc, some with telephone numbers, some without. This is in 13 columns. After leaving a space, I have another bunch of data, which contains all the same names. Everything in this data is in uppercase. All these names have telephone numbers. There are more names in the first bunch than the second. Every name in the first bunch which ISN"T in the second bunch does have a telphone number.
Problem: I need to go down the first bunch of data, and, when I find a name with no tel number, then proceed to look up the information in the uppercase bunch of data to the right.
I think I could figure this out in 5 or 6 hours, but was wondering if anyone could give me a bit of quick code to speed things up. Any help appreciated.
I have a bunch of data - names, addresses, etc, some with telephone numbers, some without. This is in 13 columns. After leaving a space, I have another bunch of data, which contains all the same names. Everything in this data is in uppercase. All these names have telephone numbers. There are more names in the first bunch than the second. Every name in the first bunch which ISN"T in the second bunch does have a telphone number.
Problem: I need to go down the first bunch of data, and, when I find a name with no tel number, then proceed to look up the information in the uppercase bunch of data to the right.
I think I could figure this out in 5 or 6 hours, but was wondering if anyone could give me a bit of quick code to speed things up. Any help appreciated.