3
1
I have 1 workbook with 2 spreadsheets. Spreadsheet 2 column A contains a long list of company names, Columns B - H contain critical information about the company.
Spreadsheet 1 contains all of the columns as Spreadsheet 2 plus some other columns. What I'm trying to achieve is that when you start to type in the first 3 characters of a company name on Spreadsheet 1 it would then have a drop down of the companies (as listed on Spreadsheet 2) that share the first 3-5 letters and you would select one. Upon selecting a company name all of the corresponding company information would populate in the other columns on spreadsheet 1 automatically. This is to avoid copying a row from Spreadsheet 2 and pasting it in Spreadsheet 1.
Any help with this would be greatly appreciated. Cheers!
Thank you for the answer! I figured it would be tricky. It was to serve as a temporary task management sheet for a month and so if it's not easy to do then I'll just go the whole copy and paste route. No Biggie. Thanks again for your time. Cheers! – Wendy Griffin – 2011-11-18T19:18:39.553