Adding a hyperlink and other cells to a list in another workbook?

[whahmira]

Hi there!

I am working on a macro that copies part numbers (PartNo) from an order form (Workbook A "A") to a shipments list (Workbook B "Sheet1"). The macro also exports sheets Worbook A "PackingList" & "ShipDoc" to their own unique shipments file. As of right now, those processes are working, but I also need the quantity, the order number (OrderNo), and the hyperlink to the newly created workbook to also be added into the shipments list for each PartNo added.

Here is where my code is currently at:

Please Login or Register  to view this content.

The silenced section of code is what I think I could do to add the hyperlink to the shipments list, but I need it to understand to add it for all of the PartNo added.
I have also added the workbooks to this file. They are color coded with what should end up in Workbook B in what location if the macro were to work properly.

Any help would be greatly appreciated!

[whahmira]

This is where the code is at now, but it is freezing and excel is "Not Responding" every time I try to run it.

Please Login or Register  to view this content.