Dear Sirs,
In the attached workbook I have
- a master sheet of material with some of them has the hyperlink to the material folder.
- other sheets which also have some material similar to the material in Master sheets
- For each sheet in the workbook, I need to copy the hyperlink address of the same item code from the Master sheets to the same item code in each sheet
- At the moment I do it repetitively to manually to create the hyperlink to the same material code
I need help in copying the hyperlink address of the same item code from the Master Sheet to each sheet in the workbook by using macros-vba. (It only copied if the item code in master sheets have a hyperlink)
Looking forward to your further help in this regards
Many thanks and best regards
Arsil Hadjar