Luggage Transport Booking System
Built for a hiking tour operator. Each booking is entered once with its stretches, dates and luggage count, and the system distributes it to every supplier sheet (luggage car, boat, buses) so each supplier sees only their daily list.
- Industry
- Travel & Tourism
- Deliverable
- Luggage Booking System.xlsb
- Built with
- Excel VBA, UserForms
Before
Each booking was copied into several supplier lists by hand.
After
A booking is entered once and sent to every supplier sheet, so each supplier sees only their own daily list.
More like this
Related projects
Sales & Purchase Inventory Data Model
Trading
A relational data model in Excel with customers, suppliers, products and countries. Sales and purchase orders are entered through forms, stock levels update automatically and customs…
View project
Hotel & Restaurant Management System
Hospitality
A complete hotel system inside Excel. Rooms are shown on a building map with live status colours, and the restaurant module handles table bookings, orders, menu…
View project
Invoice Generator with Customer & Product Database
Wholesale Distribution
An invoicing system for a skincare wholesaler. Invoices are created from customer and product databases, saved, searched, reloaded and printed, and a best-selling report is updated…
View project