Hello,
I'm sure this has been asked before, but I couldn't locate it. I have a range of cells that I'd like to have checked for data (it's always going to numbers) and if it's populated with a number, it copies those contents into a hyperlink text string. The hyperlink always stays the same, only the contents of the cell will have an effect on it. The only thing I'm really asking for is help with the if, next statements.
Sincerely any appreciate help in advance -
A.
I'm sure this has been asked before, but I couldn't locate it. I have a range of cells that I'd like to have checked for data (it's always going to numbers) and if it's populated with a number, it copies those contents into a hyperlink text string. The hyperlink always stays the same, only the contents of the cell will have an effect on it. The only thing I'm really asking for is help with the if, next statements.
Sincerely any appreciate help in advance -
A.