Hi Kev,

To be honest, I would forget Excel for this and use Access.

You will be able to achieve your goals much easier using this.

HTH

Simon

subseauk wrote:
Hi all,
i am looking for some help and advice regarding how to set up several
different worksheets to interact.
Basically i wish to create the following:
1. a worksheet that will show total run time in hours & minutes of work
carried out sometimes stretching over more than one day through midnight.
2. an inventory of parts that can generate a stores order form each week of
spares required that have reached a minimum level.
3. a worksheet for defects that has an entry for spares used that will
interact with the inventory sheet.
4. a stores order / received sheet that is generated by the inventory and
when received will update the inventory levels.
5. a maintenance sheet that can interact with the inventory sheet when
spares are used,

Pretty easy i guess if you are familiar with excel but as a beginner it
looks like a very formidable task.

Can anyone point me in the right direction please?

Rgds
Kev

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via http://www.officekb.com