Need formula help for pulling data

[argentraven]

Using Excel 2003 SP3, I am trying to build a simple (hah!) dinner reservations spreadsheet. I have a working form built to populate data into the worksheet. Date, Time, Guest Name, Comments and # in Party.
The date pulls from a drop down list (combobox) and there are four choices;
Wednesday Aug 17
Saturday Aug 20
Wednesday Aug 24
Saturday Aug 27

The times are also pulled from a drop down list (combobox), from 5:30pm to 8:30pm in increments of 30 mins.

When I input data into the form, it populates everthing in the order it was input. For instance;
Wedneday Aug 17, 5:30, "Guest Name", "Comment", Party of 2
Saturday Aug 27, 7:00, "Guest Name", "Comment", Party of 4
Wedneday Aug 17, 7:30, "Guest Name", "Comment", Party of 2

And so on...

On a seperate worksheet titled WedAug17, I would like to pull all of the reservations for Wed Aug 17 and list them in cronological order by reservation time. I would like a seperate worksheet for each Date. I am unsure of how to sort the data to get this done.

However, since this needs to be dynamic, I need the worksheet to automatically update is a new reservation gets added.

Ultimately this will be used by our front desk person and needs to be simple to input and simple to print.

I hope this makes sense. Thank you in advance for any help.

Argentraven

[tlafferty]

Use a pivot table for each date, and set the date you want as a filter. Refreshing the tables or saving the book should update the pivot.

[argentraven]

The issue I am running into is that I need the data to be printable to give to the hostess. I only want one date's data per table and I cannot configure the pivot table to show the data in the way that I need.

[MarvinP]

Hi,

See the attached. I think I'd do this using a single long table and a Pivot Table. It needs a little work to refresh the pivot table when you added a new guest but may be what you were thinking.

After reading the above I made the data a filter. See second attached.

[tlafferty]

I have an idea about how to go about this - can you attach a sample workbook?

[argentraven]

I have attached the spreadsheet so you can see how it is layed out.