VBA to build table based on 2 spreadsheets

JamieT

New Member
Joined
Jun 23, 2014
Messages
1
Hi Guys & Gals - I really need some with VBA. I have two spreadsheets and i need to build a table out of them.
First spreadsheet tells me which builds are against which equipment numbers (the builds are the A numbers across the top)

Eq No.A465A506A507A508A510A511A514A525A561A557
(mm)
A560
96550153119001
965501571
965501581
965501601
965501621
965501631

<tbody>
</tbody>
Second spreadsheet tells me which spare parts and quantity are against which builds

Part NoA506A507A508A510A511A514A515A516A525A557A560
BAA4725923532
XLA06171212111
BAC171811211
BAE398222111

<tbody>
</tbody>

However I need to figure out how to make a table of equipment numbers and associated spare parts with sum quantities.

eqnumpart noQty
96550153 BAE39823
96550153 BAA472595
96550153 XLA06172
96550153 BAC17182

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Can anyone help? It doesn't necessarily have to sum the quantities, it could repeat part numbers with different quantities and then i could put it into a pivot table to get the quantities summed and remove the duplicate part nos.

Really hoping someone can help me - This seems impossible.
 
Last edited:

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Watch MrExcel Video

Forum statistics

Threads
1,099,699
Messages
5,470,261
Members
406,686
Latest member
BNR_ 1980

This Week's Hot Topics

Top