Master Worksheets and Individual Worksheets

[PADutchFireman]

I am trying to create a database of Self Contained Breathing Apparatus for
the Fire Department where I work. What I would like to do is have the first
worksheet in the workbook as a Master List of all of the SCBA, and have
individual worksheets for each SCBA.
The individual worksheets would be locked and information could only be
added from the Master Worksheet (Form). I'm pretty sure I can do this, but I
would like to add a cell for "Maintenance/Repairs Performed" on the Master
Worksheet. This information would then transfer over to the individual
worksheets and NOT delete the prior entry. I hope my question is
understandable. Any help would be greatly appreciated.

 

[Mike H]

Hi,

This dooable in Excel but is quite a large undertaking and I doubt you'll
get a bespoke solution in a single answer. A good start would be to try and
find a ready made template which you can adapt. I Googled for this and got
thousands of hits and this one looks promising, especially the equipment
inventory template

http://office.microsoft.com/en-us/templates/CT101172541033.aspx

Mike