Creating combo boxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cloudbuster - 01 Sep 2006 22:59 GMT

This is how I have my spreadsheet set up: in Sheet 1, the leftmost row has
every date between 7-1-06 and 6-30-07 in descending order, with the
corresponding day of the week next to the dates. Columns to the right of this
have numeric information pertaining to this date/day. I would like to make a
combo box that has me select a day of the week, searches the spreadsheet,
finds info for the dates that have that corresponding day, and pastes those
rows of data on Sheet 2, where the combo box is kept. Assistance is
appreciated.

Thank you!

Reply to this Message

Biff - 02 Sep 2006 05:31 GMT

>Columns to the right of this have
>numeric information pertaining to this date/day.

How many columns of data is there?

Biff

> This is how I have my spreadsheet set up: in Sheet 1, the leftmost row has
> every date between 7-1-06 and 6-30-07 in descending order, with the
[quoted text clipped - 9 lines]
>
> Thank you!

Reply to this Message

paul - 02 Sep 2006 06:22 GMT

if you have your combo boxes set up all you need to do is set up a series of
vlookup formulas,each returning the appropriate column
ie vlookup(date,datetable,day of week column,false),next column is,
vlookup(date,datetable,sales of week,false),next column is
etc etc etc

Signature

paul
paul.shepherd@nospamparadise.net.nz
remove nospam for email addy!

> >Columns to the right of this have
> >numeric information pertaining to this date/day.
[quoted text clipped - 16 lines]
> >
> > Thank you!

Reply to this Message