I'm trying to create a workbook that pulls info for my, excel illiterate, boss.
Basically, we have collections of about 700 rows (and growing) of data with 3 columns (names, job titles, company names). What I'd like to do is create a macro on sheet 1 where he can use one of 3 drop down menus (names, job titles, or company name) select whatever he wants, hit enter, and it pulls the selected data to that spreadsheet. So if he wanted to see all of the information from Acme Company all he had to do was select it from a drop down menu, hit enter, and those 10 people show up. Make sense?
Seems so simple, but I can't seem to get started!
Thanks for your help!
Basically, we have collections of about 700 rows (and growing) of data with 3 columns (names, job titles, company names). What I'd like to do is create a macro on sheet 1 where he can use one of 3 drop down menus (names, job titles, or company name) select whatever he wants, hit enter, and it pulls the selected data to that spreadsheet. So if he wanted to see all of the information from Acme Company all he had to do was select it from a drop down menu, hit enter, and those 10 people show up. Make sense?
Seems so simple, but I can't seem to get started!
Thanks for your help!
