mogambo
12-28-2008, 11:20 PM
Hello Sirs/ madames,
I have a folder on my network drive. In this folder there are over 100 excel files. Each and every file will have a name in cell H2 and address in cell H3. Now, there would one more distinct file in the same folder. Let's say the filename is "home.xls". Home.xls will contain the list of all the names alongwith their respective addresses in cell range A1:B500, in those 100 other files.
What I am wanting to do is create some sort of a macro, if the name in cell H2 in all / any of these 100 files matches the name in cell range A1:A500 of "home.xls" (sort of vlookup) then return the text present in the next column of the match in cell range B1:B500. This should happen in all 100 files.
Basically the name in each of these 100 files will find a match in "home.xls" and I want to vlookup the values in cell range A1:B500 of "home.xls" and return the text in the second column (Column B) of "home.xls" to cell H3 of these 100 files.
I know this is very tough and so I am stuck and I could not find a way even to start this on my own. Can someone please help me to get this started ? I willing to work hard for getting this done.
Thanks you very much for your help :(
I have a folder on my network drive. In this folder there are over 100 excel files. Each and every file will have a name in cell H2 and address in cell H3. Now, there would one more distinct file in the same folder. Let's say the filename is "home.xls". Home.xls will contain the list of all the names alongwith their respective addresses in cell range A1:B500, in those 100 other files.
What I am wanting to do is create some sort of a macro, if the name in cell H2 in all / any of these 100 files matches the name in cell range A1:A500 of "home.xls" (sort of vlookup) then return the text present in the next column of the match in cell range B1:B500. This should happen in all 100 files.
Basically the name in each of these 100 files will find a match in "home.xls" and I want to vlookup the values in cell range A1:B500 of "home.xls" and return the text in the second column (Column B) of "home.xls" to cell H3 of these 100 files.
I know this is very tough and so I am stuck and I could not find a way even to start this on my own. Can someone please help me to get this started ? I willing to work hard for getting this done.
Thanks you very much for your help :(