Hi Excel members,
Understand the concept of a vlookup and how i can search within another sheet or document however i'd like to automate this. This could be easily done however the files are different each week. I'm sure i can name the files to be the same but need help with the code behind it all.
I have a macro that filters my raw data into columns however i now need to do the lookups.
Essentially the columns look like:
UserID ¦ User number ¦ Name ¦ Vlookup1 ¦ vlookup2...and so on.
The lookups will be along the lines of "=VLOOKUP(A178,'LOCATION AND NAME OF FILE'!$W:$W (This being the column the data is pulled from, this is always the same),1,FALSE)"
How can i create within my macro that says go to vlookup 1 and do a vlookup for A1 (the user ID) against the specified file (i want to choose the file, like a popup menu thing...maybe this is a button? i don't know) and then extend this for all User ID's (A:A) i then want to do the same for Vlookup 2 and so on but with different files.
If anyone can help me with some sort of mock up or code that can help me understand how to do this i would appreciate that.
Understand the concept of a vlookup and how i can search within another sheet or document however i'd like to automate this. This could be easily done however the files are different each week. I'm sure i can name the files to be the same but need help with the code behind it all.
I have a macro that filters my raw data into columns however i now need to do the lookups.
Essentially the columns look like:
UserID ¦ User number ¦ Name ¦ Vlookup1 ¦ vlookup2...and so on.
The lookups will be along the lines of "=VLOOKUP(A178,'LOCATION AND NAME OF FILE'!$W:$W (This being the column the data is pulled from, this is always the same),1,FALSE)"
How can i create within my macro that says go to vlookup 1 and do a vlookup for A1 (the user ID) against the specified file (i want to choose the file, like a popup menu thing...maybe this is a button? i don't know) and then extend this for all User ID's (A:A) i then want to do the same for Vlookup 2 and so on but with different files.
If anyone can help me with some sort of mock up or code that can help me understand how to do this i would appreciate that.