Forum Discussion
PeterBowen
Jun 26, 2023Copper Contributor
Product Count and Number Sold
I have a series of Excel worksheets in a single workbook that I create every month to track sales of products so I have columns for ITEM purchased and QUANTITY which is always one. There are up to 90...
mtarler
Jun 26, 2023Silver Contributor
why not CREATE them in 1 worksheet to start with? Then if you want to see just 1 month you can just filter by that month. I would recommend a column for date to start and to 'Format as a Table' (from the home menu). Once all the data is in 1 table in addition to filters you can use pivot tables or other functions to break the data out by month, or item or customer or whatever you want. Basically it is easier to start with a single data source than having man y fragmented sources.