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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help / Advice needed to setup interactive worksheets
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help / Advice needed to setup interactive worksheets
Thanks for the response Simon
Whilst i am slightly familiar with Excel for day to day stuff i have no experience or dealings with Access. Can it do what i am after? ie can it total up hours run etc and link inventories to spares used in fault logs etc? Best Rgds Kev "smw226 via OfficeKB.com" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help / Advice needed to setup interactive worksheets
Hi Kev,
Access will be easily able to handle your needs but if you have never used it before it may take you a while. However, if you need any tips or pointers I am more than happy to help and also check out this site's sister www.accessmonster.com for a whole community of helpers. All the Best Simon subseauk wrote: Thanks for the response Simon Whilst i am slightly familiar with Excel for day to day stuff i have no experience or dealings with Access. Can it do what i am after? ie can it total up hours run etc and link inventories to spares used in fault logs etc? Best Rgds Kev Hi Kev, [quoted text clipped - 28 lines] Rgds Kev -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via http://www.officekb.com |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help / Advice needed to setup interactive worksheets
Many thanks Simon
Off to check out the other site now and also see if i can find any idiots guides for access !! :) Rgds kev "smw226 via OfficeKB.com" wrote: Hi Kev, Access will be easily able to handle your needs but if you have never used it before it may take you a while. However, if you need any tips or pointers I am more than happy to help and also check out this site's sister www.accessmonster.com for a whole community of helpers. All the Best Simon subseauk wrote: Thanks for the response Simon Whilst i am slightly familiar with Excel for day to day stuff i have no experience or dealings with Access. Can it do what i am after? ie can it total up hours run etc and link inventories to spares used in fault logs etc? Best Rgds Kev Hi Kev, [quoted text clipped - 28 lines] Rgds Kev -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via http://www.officekb.com |
Reply |
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 |