Hi Guys
I am trying to create some code for a mcaro but lack the knowledge to put it all together
I have column B filled with a name in each cell
I have column C filled with a number adjacent to each name in column B (Not all names have data in the adjacent cell)
I need to delete the data from each cell in column B if its adjacent cell in column C is blank
Any ideas how i can put this together?
Your help is greatly appreciated
Thanks,
Mick
I am trying to create some code for a mcaro but lack the knowledge to put it all together
I have column B filled with a name in each cell
I have column C filled with a number adjacent to each name in column B (Not all names have data in the adjacent cell)
I need to delete the data from each cell in column B if its adjacent cell in column C is blank
Any ideas how i can put this together?
Your help is greatly appreciated
Thanks,
Mick