i i have two files and i would like one sheet to grab data from the other one by using keywords, basicly if someone types in kitchen or bathroom the number that are associated with that are automaticly entered into the right collums same fields on the other file, at the moment i am using a formula like this
VLOOKUP(A6,'/Users/TheDirectoryItIsIn/[Roomsizes.xls]Rooms'!masterdims,(COLUMN(B6:F6)),FALSE)
Rooms is the name of the array i made on the sheet i wanted it to get the data from. But i would like to do it in VBA becuse i want a option where when i load up the script it will open up a inputbox or a openfile windows where u can select a file for it to read from is his possible, if so how???