Hi all,
Macro help---I'm trying to rename a worksheet according to a persons name in a cell, but if that cell is black I need it to the sheet according to another cell.
So in this case, the sheet name would be A6 "John Doe", but if cell A6 is blank then sheet name needs to be A2 "Jane Doe"
Thanks
Macro help---I'm trying to rename a worksheet according to a persons name in a cell, but if that cell is black I need it to the sheet according to another cell.
So in this case, the sheet name would be A6 "John Doe", but if cell A6 is blank then sheet name needs to be A2 "Jane Doe"
Thanks