View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jk jk is offline
external usenet poster
 
Posts: 109
Default Combine Multiple Worksheets into One with a Drop Down Box

Hello,

I was hoping someone could help me. I have a "master" template set up and
each of my sales reps goes in and fills out the required information. I was
wondering if there was a way to "combine" all of them into the master, so all
I would have to do to look through each persons sheet is click on a drop down
box on the master sheet, click on the person's name, and all of their
information would come up. Any help will be appreciated. Thanks.