I have an excel worksheet that stores hardware information for a particular job. Hardware is listed by type in columns. There are almost always duplicate listings in a given column (This is neccessary). What I would like to do is to have some summary type information (Part and Qty) on a separate worksheet. I have provided a sample of a column on my existing sheet and what I would like to see on another sheet.
Existing Sheet:
Hardware Type #1 | Hardware Type #2
A1 | Z9
A1 | Z9
A1 | Z9
A2 | Z10
A1 | Z9
New Summary Sheet:
Type#1
A1 | 4
A2 | 1
Type#2
Z9 | 4
Z10 | 1
Any advice is much apprechiated. I am fairly new to excel and VBA but am learning with your help!
-Zack
Existing Sheet:
Hardware Type #1 | Hardware Type #2
A1 | Z9
A1 | Z9
A1 | Z9
A2 | Z10
A1 | Z9
New Summary Sheet:
Type#1
A1 | 4
A2 | 1
Type#2
Z9 | 4
Z10 | 1
Any advice is much apprechiated. I am fairly new to excel and VBA but am learning with your help!
-Zack