Auto Populate by Contracts

[SiuL]

Hello everyone.

I'm a total newbie in Excel. I can manage the most basic functions and recently I was asked come up with a way to manage content through Excel.
I'd like to know if it's possible to auto populate number of bus through Excel basing off the below information.
For instance:

PO NUmber , Client X to run 50 Buses from April to May
PO NUmber , Client Y to run 145 Buses from mid April to mid May
PO NUmber , Client W to run 60 Buses from July to August

Is it possible to link this all information through the use of Excel?
I'm assuming, important information will be client, number of buses and calendar.....

Any help would be greatly appreciated.
Thank you

[ChemistB]

Sounds reasonable. Upload an example spreadsheet showing how your data will be set up and what you would want your result to be (Go Advanced> click on paperclip)