Forum Discussion
Links
I have a workbook with 13 spreadsheets: 1 spreadsheet for each month plus a spreadsheet in which yearly totals are recorded. In each monthly spreadsheet, records are kept of items sold. The items a...
Gary_Brom Without seeing your workbook it's difficult to picture what you are doing exactly. But, perhaps you want to reconsider the overall design of your workbook. Best practice suggests that you capture all orders in one table/sheet. Make sure it has a column for the order date. When you spot a missing order numbers in January, just use it March in the same sheet.
Now you can utilise one of Excel's many built-in tools to summarise transactions by month, product, customer. Whatever.