View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mball37 mball37 is offline
external usenet poster
 
Posts: 2
Default Insert combobox in excel to complete lookup function

Hi all
I have been asked to create an excel workbook within this workbook I have
been requested to produce a ineractive report where I can choose the select
criteria from a combobox...
I have a large amount of data spaning several columns and numerous rows
wherethe only column I wish to sort on is a company number. How can i create
a combobox on a new sheet which will enable me to display records relating to
a specific company no...
Say select company no (1) once selected all company (1) rows and all
adjacent columns relating to these records within the new worksheet..
Any help or a piont in the right direction would be much apprieciated...