I need to create a spreadsheet to track sales. My company has around 16,00 unique sku numbers/products. We use WASP for inventory and I can export all the data from there. In my head, I want to list all the Sku's down the side. Months across the top. Each sku will show incoming/outgoing for the month.
A bonus would be that when I run the report each month from WASP, the SS can pull the new information and automatically update my Spreadsheet.
i also need to make sure it will show a 0 instead of skipping the sku if there has been no activity that month.
My excel skills used to be great, but I haven't been using that part of my brain for awhile!
Any help would be greatly appreciated. I thought about pivot table? can i make it update automatically?
It's a blank slate! Thanks so much for the tips
A bonus would be that when I run the report each month from WASP, the SS can pull the new information and automatically update my Spreadsheet.
i also need to make sure it will show a 0 instead of skipping the sku if there has been no activity that month.
My excel skills used to be great, but I haven't been using that part of my brain for awhile!
Any help would be greatly appreciated. I thought about pivot table? can i make it update automatically?
It's a blank slate! Thanks so much for the tips