Master Worksheets and Individual Worksheets

  • Thread starter Thread starter PADutchFireman
  • Start date Start date
P

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

linking multiple worksheets and master completes next available li 1
Linking Multiple Worksheets and Cells 1
Sorting Master Worksheet to Regional Worksheet 3
Using a Master Worksheet 1
combining data from multiple worksheets into one 6
instering rows in one worksheet that reflect another worksheet 1
Link from 1 worksheet to 4 different worksheets 1
Linking data from one worksheet to another... 2

Back
Top