Please see the updated sample workbook. I have used two sheets: Current Stock and Expenses. Each contains one Structured Table. If you type a new entry immediately below the table, the table will be extended to include it. Formulae and formatting will automatically be copied into the new row.
Structured Tables allow you to create "more readable" formula as they reference the column headings. For example:
I have added a unique ID so that you can differentiate between the different furniture items ... as time goes on, you will have more than one desk, chair or mirror. This allows you to link specific expenses with specific furniture items. I guess you might want to apportion the cost of bulk items like sandpaper, paint, varnish, screws, etc.
I have also adjusted the formatting. I think you are mixing up presentation with content ... in my opinion, less is more. It will make it easier should you wish to print the sheets.
You'll see that the two sheets are linked together. The expenses for an item are a total of the relevant amounts on the Expenses sheet. And the Description on the Expenses sheet uses a VLOOKUP:
Anyway, some ideas to be going on with. I'm sure it will evolve over time.
Bookmarks