Hey! I am not sure if this is possible but I would like to extract data from one excel spreadsheet (preferably even when the spreadsheet is closed) based on key words that i insert into the first sheet.
For example, the second spreadsheet is a list of names and their corresponding phone numbers. (There are hundreds of names and numbers on the list)
On the first spreadsheet I would like to insert a name and have the corresponding phone number, as mentioned on the second spreadsheet, automatically appear.
I am not sure if this is possible or if anyone may have a similar idea that I could use instead... all help will be much appreciated!
For example, the second spreadsheet is a list of names and their corresponding phone numbers. (There are hundreds of names and numbers on the list)
On the first spreadsheet I would like to insert a name and have the corresponding phone number, as mentioned on the second spreadsheet, automatically appear.
I am not sure if this is possible or if anyone may have a similar idea that I could use instead... all help will be much appreciated!