Compare data and summarize on seperate sheet [Closed]

Report
Posts
1
Registration date
Wednesday September 14, 2016
Status
Member
Last seen
September 14, 2016
-
Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
-
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?

1 reply

Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,773
I suggest you hire an Excel programmer to develop the application for you.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!