1 reply to this topic

[Vandalised]

Hey everyone, I'm doing ICT at A levels and I need to know how to do the following as this will get me into the highest mark band.

I am using Microsoft excel spreadsheet system to create invoices for customers; the company is a van rental company.

I have a table with all the customers data arranged like the following:

ID|Forename|Surname|

1   John      Bryan

2   Stacy    Smith

Obviously more details but you get the idea, I then have a sheet with a table that has all of the vans details in:

VanID|VanSize|Weekly Rental Charge|

1      Small         £32.00

2      Medium      £32.00

3      Large         £32.00

So what I would like to do is make a tracking/record system, so when I enter a customers ID it will pull there customer details up as well as the van they have rented.

Looking something like the following:

Customer ID
             1

Forename: John
Surname: Bryan

[b]Rental Details[/b]

Van Size: Small
Weekly Rental Charge: £32.00

Now is there a way to do this other than creating a table on a new sheet that has customers assigned to vans, like a table that has customers linked with the van they have rented, because I know I could do that and then just use VLOOKUPS. Is there a more sophisticated way of doing this?

Cheers.

Edited by Vandalised, 25 September 2007 - 06:26 PM.

[Vandalised]

Nevermind, I'll read through the giant excel book I've been given today