Excel 2000

[dabowles]

Hello,
Currently I have a workbook that has a page for each day of the week with data from every half-hour of the day. At the bottom of each sheet for each day I have a group of cells that lists groups the data into 4-Hour groups (8,12,4,8,and 12). Can anyone tell me how I would go about creating a drop-down list that has a list of times (8:00am, 12:00pm, 4:00pm, 8:00pm, and 12:00am) and based apon which time is selected from the drop down, it would take the data from the row with the specific time and populate another group of cells that I have formatted a specific way and link the 4 hourly data there? Just so that I haven't lost you, On each page I have a 4-hourly summary group of cells that contains all the 4-hour sets like I said above, (8am,12pm,4pm,8pm,12am) and then I have created one more group out to the side as well in a special format then just listing them out that I want the data to be formatted to if I pull a special 4-Hour period out. I could just take that special formatting and create 5 different groups of cells each linked to their own 4-hour grouping, but that would take up too much space. If I could just have one special formatted group up based upon the hour selected from the drop-down list, it would make it alot easier.

Thanks for your time and help,

David B.

 

[Zelandakh]

OK, here's what I think you want:

The table / section that has the 8, 12, 4, 8, 12. Put a column to the left that is numbered sequentially from 1 upwards. Including that column, name the range as range1 or whatever.

Do View, Toolbars, Form to get the right toolbar up and get a combo box. In there, your input range should be the column with the time; cell link should be the cell to the right of the combo box (just to put the answer in) and what ever number of drop down lines you want.

Then you vlookup(<cell to right of combo box>, range1, column number in range1 with answer in).

Sorted.

 

[dabowles]

I understand everything up until the 2nd paragraph where you talk about the form toolbar and about setting the input range to the column with the time, but past that I am pretty much lost, could you please explain the less a little more in detail?

Thanks again for your time and understanding,

David B.