Hi All
Looking for a macro that can copy the link from a certain cell if YES is entered in another cell.
For example in F10 we have text "Link" with a link that links to a pdf in a certain folder. I want a macro that takes this link and add to any cell in column F only if text YES is entered. Then make the "YES" as a link as well with the link from F10.
This will be the same for G10, H10, I10, J10 and so on.
If this possible at all.
Looking for a macro that can copy the link from a certain cell if YES is entered in another cell.
For example in F10 we have text "Link" with a link that links to a pdf in a certain folder. I want a macro that takes this link and add to any cell in column F only if text YES is entered. Then make the "YES" as a link as well with the link from F10.
This will be the same for G10, H10, I10, J10 and so on.
If this possible at all.