Hi there,
I don’t know much about Excel Macro, has been learning by trial & error as well as googling…..unfortunately, now I’m stuck with a problem and hopefully can get some help from the experts here.
I have 2 spreadsheets, one is like a form for users to fill in a customer number, then click the “Get data” button to initial a macro, which will connect to another Excel spreadsheet located in the company intranet, to search the records database which is over 10,000 rows, once found, to return the customer information like purchase date, what produce, what model….etc. back to the Result.xls
I have been using VLOOKUP, but when the database grows bigger, it seems that VLookup is slowing down especially when try to connect to the remote file to search for the data. I was told that Index & Match will be quicker so would like to give it a go….but it seems I can’t get the Index & Match to work in the macro.
I have attached the 2 files as well as the macro I wrote which keeping coming back with “#Value”, I have been searching for a while on the google without much luck……appreciate if anyone out there could shed me some light on what I have done wrong.
Thanks.
Bookmarks