Hi,
I'm close to what I need but my problem is although I've ammended this code to enter the Rand() formula if a name is entered in the adjacent cell. But it's not removing the formula if I remove the name from col A (I'm building a random draw so the amount of names can change).
can anyone help please?
Name col A3:A35
Formula Col B3:B35
Please Login or Register to view this content.
Bookmarks