how to do a wookbook with sheets and subsheets?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to creat a workbook for our const equipment that has titles such as
"backhoes" and then have repair sheet attached for each backhoe to keep track
of repair costs for each. Example: Backhoes - #1, #2, #3, #4.
 
There is no 'subsheet' object in Excel and, even if there was, I'd suggest
that you are better of not segregating all of the data in different locations.

Set up a single sheet that has columns along the lines of

Col A Equip#
Col B EquipType
Col C RepairDate
Col D RepairType
Col E Cost
Col F Mechanic

This gives you a a ton of flexibility when it comes to reporting. You can
summarize expenses for ALL backhoes, or for certain date ranges for ALL
equipment. If desired, you can see how much you've spent for certain
mechanic's services.

All in all, a much better way of storing your data
 
Back
Top