Excel to Display Room Booking Information

antfield

New Member
Joined
Mar 28, 2006
Messages
33
I have been playing around with Excel Trying to Get the following to occur ( automatically )

Example:

Sheet 1

A1 = Bluegum Room { Colunm Name }

A2 = Microsoft Luncheon { Function Name }
A3 = 10:00 { Start Time }
A4 = 13:00 { End Time }
A5 = Anthony { Delegates Name }

A6 = IBM Dinner { Function Name }
A7 = 18:00 { Start Time }
A8 = 21:00 { End Time }
A9 = Anthony { Delegates Name }

B1 = Wattle Room { Colunm Name }

B2 = Microsoft Luncheon { Function Name }
B3 = 10:00 { Start Time }
B4 = 13:00 { End Time }
B5 = Anthony { Delegates Name }

B6 = IBM Dinner { Function Name }
B7 = 18:00 { Start Time }
B8 = 21:00 { End Time }
B9 = Bruce { Delegates Name }

Sheet 2 { Bluegum Room }

Only Display the ;

Function Name
Start - End Time
Delegates Name

Based on the Function Time ( Only Display the Upcomming function ) 1hr prior or the

Sheet 3 { Wattle Room }

Only Display the ;

Function Name
Start - End Time
Delegates Name

Based on the Function Time ( Only Display the Upcomming function ) 1hr prior or the


I want to use a Java / Webpage or alike to display the output of Sheet 2 and Sheet 3, A Seperate screen in front of each room, displaying the function names etc ??

Is it too much of an ask for excel ?

Any Idea's would be greatly appreciated ?
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Watch MrExcel Video

Forum statistics

Threads
1,108,501
Messages
5,523,293
Members
409,508
Latest member
Afc

This Week's Hot Topics

Top