Dear All,
I would like to share that, I hanve an AS400 Data converted to excel which consist of 2500 rows and 15 coloumns. Data in this file is related to HVAC parts here i need your expertise to find out that which part is repated many times and their quantaties with total. please need your sincere advise how can i arrange this file by using Pivot/VBA.
Regard
Mohd Jameel
I would like to share that, I hanve an AS400 Data converted to excel which consist of 2500 rows and 15 coloumns. Data in this file is related to HVAC parts here i need your expertise to find out that which part is repated many times and their quantaties with total. please need your sincere advise how can i arrange this file by using Pivot/VBA.
Regard
Mohd Jameel