Hello: I'm trying to use vba code to copy and paste cells A and B from Sh1 to Sh2 A and B, but it is triggered when a specific selection is made on a dropdown.
The 1st part of the code adds a hyperlink (and it works properly since I received help from this forum).
The 2nd part is the problem, I'm trying to trigger a copy and paste event the same way (and at the same time) it is done with the hyperlink , it is triggered when a selection is made in the active sheet column K and the dropdown selection of "Cable Assy" is made. I'm trying to copy Active row cell A and B and paste them in A and B on Sh2 (sheet name: CABLE_MATRIX) into the next blank row (using cell A as a reference). Which also happens to be the same row as what the automatic hyperlink attached to.
HTML Code:
Bookmarks