I want to creat a workbook for our const equipment that has titles such as
quot;backhoesquot; 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
quot;pattygquot; wrote:
gt; I want to creat a workbook for our const equipment that has titles such as
gt; quot;backhoesquot; and then have repair sheet attached for each backhoe to keep track
gt; of repair costs for each. Example: Backhoes - #1, #2, #3, #4.
- Sep 10 Mon 2007 20:39
how to do a wookbook with sheets and subsheets?
close
全站熱搜
留言列表
發表留言