Is it possible to construct a VBA code to clear a row based on a column value?
The current worksheet I am using requires the end user to populate column C, which ranges from C14:C50 with one of the following values:
Current
Leaver
New Joiner
If either current or new joiner is selected, say in cell C14 then all the corresponding data in cells D14:U14 should remain as is. However if leaver is selected I would like corresponding data to be cleared. That said I should mention that columns P and M contain formulas which link elsewhere within my workbook.
My column range is C14:C50, and my row range is D14:U50.
If it helps I am more than happy to email a copy of my workbook across.
Any help would be greatly appreciated.
Thanks,
Sam
The current worksheet I am using requires the end user to populate column C, which ranges from C14:C50 with one of the following values:
Current
Leaver
New Joiner
If either current or new joiner is selected, say in cell C14 then all the corresponding data in cells D14:U14 should remain as is. However if leaver is selected I would like corresponding data to be cleared. That said I should mention that columns P and M contain formulas which link elsewhere within my workbook.
My column range is C14:C50, and my row range is D14:U50.
If it helps I am more than happy to email a copy of my workbook across.
Any help would be greatly appreciated.
Thanks,
Sam