close

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.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()