View Single Post
 
Old 07-23-2019, 11:59 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

It looks like you have a single row for customer, and a column for every month. This means, that you change the design of your table every month! And when you want to create some reports based on this table, then you have to edit them also in every month!


Instead consider more database-like design.
You will have a table with columns like Customer, Month, Value (Month being a date really - e.g. 1st of month - formatted like "yyyymm"), where you enter your data.
Then you can design report sheets, which read info from this table, and display it in any form you'll need.
And/or you can set autofilter on for data entry table, and add some SUBTOTAL formulas above your data entry table to calculate sum's or count's from filtered rows in data entry table.
Reply With Quote