I need a chart to be made from a general ledger. I need the chart to find each cell with the word "inventory" in it and to plot how many sales for each type of inventory as there will be many different types. It has to specifically contain that word or else it will just plot every cell with a word in it such as cash or a/r or something.
I also need the chart to:
- ignore blank cells
- to be continuously refreshing as the amount of data will continue to grow
I've attached an example workbook.
Bookmarks