Hello!
I am hoping to get some help with an excel spreadsheet I have been working on, the first sheet is called PasteBOM and the second sheet is called Kitting.
When we paste a customers parts list into the PasteBOM sheet, the user can then use the drop down for the heading. Selecting the required heading i.e. Item Number, Designator, Part Number. We are doing it this way because each parts list can be different and so I don't want the user having to manipulate the data, only to paste and select a heading for each column.
I am struggling with writing VBA that after pressing a button, will copy the data in the column they have called "Designator" and pasting it into the Kitting sheet under the heading "Designator". The difficulty is that the parts lists being pasted into the PasteBOM sheet will not always be in the same order.
I have uploaded two images showing the two tabs and what they look like.
I would really appreciate any help or tips!
Thank you
I am hoping to get some help with an excel spreadsheet I have been working on, the first sheet is called PasteBOM and the second sheet is called Kitting.
When we paste a customers parts list into the PasteBOM sheet, the user can then use the drop down for the heading. Selecting the required heading i.e. Item Number, Designator, Part Number. We are doing it this way because each parts list can be different and so I don't want the user having to manipulate the data, only to paste and select a heading for each column.
I am struggling with writing VBA that after pressing a button, will copy the data in the column they have called "Designator" and pasting it into the Kitting sheet under the heading "Designator". The difficulty is that the parts lists being pasted into the PasteBOM sheet will not always be in the same order.
I have uploaded two images showing the two tabs and what they look like.
I would really appreciate any help or tips!
Thank you