Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help / Advice needed to setup interactive worksheets
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Advice Needed | Excel Discussion (Misc queries) | |||
advice needed | Excel Worksheet Functions | |||
Advice needed... | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Advice needed - counting tabs | Excel Worksheet Functions |