Andy's Coach Business Scheduler

swaink · Jan 14th, 2002, 02:14 PM

Hi Aladin

That works a treat, may I ask a question of you before I post it.

I've now used CELL with the same formula to return the address of the field found by the formula.

The question? Is it possible to set the cell found to read "Booked" if the bookin is confirmed.

Kev

Aladin Akyurek · Jan 14th, 2002, 02:22 PM

Quote:

On 2002-01-14 13:14, swaink wrote:
Hi Aladin

That works a treat, may I ask a question of you before I post it.

I've now used CELL with the same formula to return the address of the field found by the formula.

The question? Is it possible to set the cell found to read "Booked" if the bookin is confirmed.

Kev

Hi Kev,

I know you had posted something, but I cannot see it in the listing of Excel Questions. I arrived here by typing "swaink" in the Search facility. Are you able to see yourself your own post?

Aladin

[ This Message was edited by: Aladin Akyurek on 2002-01-14 13:40 ]

Peter_Koski · Apr 8th, 2002, 08:46 AM

I am trying to computerize my Uncle's coach business using Excel.

He has five coaches A - E which are booked out for day trips or longer tours. Also every 6 weeks a coach has to be withdrawn from service for compulsory Government safety checks and maintenance work (PSV Test)

There is a single booking-in form which shows the dates of OUTBOUND and INBOUND journeys.

Also I have another workbook called "scheduler" which has 3 months display of each day across Row2 and the coaches listed in column A. As a coach is booked out the booking reference is entered in the appropriate cells for each day of use.

My problem is when a customer enquires whether a particular coach is available for a specified day I want to see this information on the booking form. Free or Booking Ref??

I have tried a HLOOKUP table but cannot get it to work other than for coach A? what am I doing wrong

Any ideas anyone?????

Many thanks
Andy

Morrissey · Apr 8th, 2002, 09:15 AM

pay someone to do it for you thats my best advice

Morrissey · Apr 8th, 2002, 11:43 AM

I think someone should help Andy I would but I don't know how to

Chris Davison · Apr 8th, 2002, 02:58 PM

try your logic, but use VLOOKUP....

if your coaches are listed vertically, you will need to look (V)ertically down your coach table rather than (H)orizontally

Mark O'Brien · Apr 8th, 2002, 03:05 PM

God, this sounds really familiar. It almost sounds like an A Level project.

Morissey and Chris both came up with good suggestions though.
_________________
[b] Mark O'Brien

[ This Message was edited by: Mark O'Brien on 2002-04-08 14:07 ]

Morrissey · Apr 9th, 2002, 03:57 AM

Gee Mark Ya Think?

swaink · Apr 9th, 2002, 07:15 AM

Hi Peter

Can you email me a copy of your workbooks

I have some Ideas that may work but can't promise

Kev

swaink · Apr 13th, 2002, 07:39 AM

Hi peter

Ive email you a sample workbook with a couple of macro's in it and a formula to enable you to acheive your lookup.

Let me know if it helped

Apr 8th, 2002, 02:58 PM	#6
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	try your logic, but use VLOOKUP.... if your coaches are listed vertically, you will need to look (V)ertically down your coach table rather than (H)orizontally __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Jan 14th, 2002, 02:14 PM	#1
swaink Board Regular Join Date: Feb 2002 Location: South UK Posts: 344	Hi Aladin That works a treat, may I ask a question of you before I post it. I've now used CELL with the same formula to return the address of the field found by the formula. The question? Is it possible to set the cell found to read "Booked" if the bookin is confirmed. Kev

Apr 8th, 2002, 08:46 AM	#3
Peter_Koski New Member Join Date: Feb 2002 Posts: 3	I am trying to computerize my Uncle's coach business using Excel. He has five coaches A - E which are booked out for day trips or longer tours. Also every 6 weeks a coach has to be withdrawn from service for compulsory Government safety checks and maintenance work (PSV Test) There is a single booking-in form which shows the dates of OUTBOUND and INBOUND journeys. Also I have another workbook called "scheduler" which has 3 months display of each day across Row2 and the coaches listed in column A. As a coach is booked out the booking reference is entered in the appropriate cells for each day of use. My problem is when a customer enquires whether a particular coach is available for a specified day I want to see this information on the booking form. Free or Booking Ref?? I have tried a HLOOKUP table but cannot get it to work other than for coach A? what am I doing wrong Any ideas anyone????? Many thanks Andy

Apr 8th, 2002, 09:15 AM	#4
Morrissey Board Regular Join Date: Mar 2002 Posts: 85	pay someone to do it for you thats my best advice

Apr 8th, 2002, 11:43 AM	#5
Morrissey Board Regular Join Date: Mar 2002 Posts: 85	I think someone should help Andy I would but I don't know how to

Apr 8th, 2002, 03:05 PM	#7
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	God, this sounds really familiar. It almost sounds like an A Level project. Morissey and Chris both came up with good suggestions though. _________________ [b] Mark O'Brien [ This Message was edited by: Mark O'Brien on 2002-04-08 14:07 ]

Apr 9th, 2002, 03:57 AM	#8
Morrissey Board Regular Join Date: Mar 2002 Posts: 85	Gee Mark Ya Think?

Apr 9th, 2002, 07:15 AM	#9
swaink Board Regular Join Date: Feb 2002 Location: South UK Posts: 344	Hi Peter Can you email me a copy of your workbooks I have some Ideas that may work but can't promise Kev

Apr 13th, 2002, 07:39 AM	#10
swaink Board Regular Join Date: Feb 2002 Location: South UK Posts: 344	Hi peter Ive email you a sample workbook with a couple of macro's in it and a formula to enable you to acheive your lookup. Let me know if it helped