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...

Insert combobox in excel to complete lookup function
 

It almost sounds like you want a filter.
Try Data|Filter|Autofilter from your Excel menu.
This will create dropdown boxes on all applicable columns.
--
Trent Argante
[DC.J(n/a)]


"mball37" wrote:

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...

Insert combobox in excel to complete lookup function
 

Cheers thanks for reply

Have looked into this but seems a bit messy

would it be possible to create the following with an excel using a combbox
and and a function within the combobox using vbe or a function within the
spreadsheet. to filter or sort the specified records...???

"Trent Argante" wrote:

It almost sounds like you want a filter.
Try Data|Filter|Autofilter from your Excel menu.
This will create dropdown boxes on all applicable columns.
--
Trent Argante
[DC.J(n/a)]