My inventory changes monthly so reports are hard to work with. Please help!

Hi all,

I'm new here & new to excel.

In brief, my pos system produces great reports but I have to export each month individually and trying to chart sales data is a pain as new inventory items are added regularly meaning each export has some items but not others. Is there an easy way to produce a report listing each item and the sales by month. At the moment, I have to highlight each item on each worksheet (I have a separate sheet in the workbook for each month and each has 3 columns, SKU, description & number) and then work with the data. This is very time consuming and also makes the data tough to work with.

Any help at all greatly appreciated.

Nick

Hi Nick,

try to use Macro. This will automate your report generation.

Hi Nick,

try to use Macro. This will automate your report generation.

Thanks for the advice so far. The issue is that I can't just add the data month by month as they don't match in position due to additional stock items having been added or deleted so for example, the SKU list for jean might go
001
002
005
007

And the list for February might be
001
002
003
008

This results in relative mismatches, and as the list is several hundred items long, manually sorting is killing me lol.

If I can sort this issue I can deal with the rest fairly easily bit I can't find a way to get excel to reorder the data to match and simply enter a zero or blank where there is no match.

Thanks again.

Nick.