freshwattrout
New Member
- Joined
- Jul 17, 2021
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
I have two workbooks, "Production Schedule" with a pivot table A in sheet "Daily", and "Kitting List" with a pivot table B in sheet "Kitting Priority".
I need to create a macro that would lookup a name in a column in pivot table A, match the name in a column in pivot table B, and use a number originating from the Production Schedule to update the corresponding number in the Kitting list.
This is the code I came up with, but it returns a subscript out of range error. Does anyone know what is wrong with it?
I need to create a macro that would lookup a name in a column in pivot table A, match the name in a column in pivot table B, and use a number originating from the Production Schedule to update the corresponding number in the Kitting list.
This is the code I came up with, but it returns a subscript out of range error. Does anyone know what is wrong with it?