S
subseauk
Hi all,
Originally this question was submitted in the Excel user group but a
suggestion was to contact Access as well as this may be a better method to
get where i want to go!!
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 / Access but as a
beginner it
looks like a very formidable task.
Can anyone point me in the right direction please?
Rgds
Kev
Originally this question was submitted in the Excel user group but a
suggestion was to contact Access as well as this may be a better method to
get where i want to go!!
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 / Access but as a
beginner it
looks like a very formidable task.
Can anyone point me in the right direction please?
Rgds
Kev