Previous Topic Next Topic

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

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

Similar discussions

Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses
AMD data change update new data to DMI
Luis -
dwebb -

1 response
VBA Compare 2 sheets and output difference to 3rd sheet
jmah -
TrowaD -

3 responses