Compare data and summarize on seperate sheet

Closed
ukwildcat98 Posts 1 Registration date Wednesday September 14, 2016 Status Member Last seen September 14, 2016 - Sep 14, 2016 at 09:41 AM
xpcman Posts 19530 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 - Sep 14, 2016 at 12:47 PM
Hello,

Each month I download a 1,000+ line of Part Numbers with inventory qty and value to an excel tab. I want to compare the part numbers to see which one inventory is increasing or decreasing.

The row header would look like:
Part Number - QTY on Hand - Value
123 1,000 $10,000

I would like to have a summary tab so each month we can see each part number and if its inventory is increasing or decreasing. Can I get the formula to do this?

Related:

1 response

xpcman Posts 19530 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,825
Sep 14, 2016 at 12:47 PM
I suggest you hire an Excel programmer to develop the application for you.
0