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.

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

software

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