#1
|
|||
|
|||
Macro for deleting cell contents based on another cells contents
Hi Everyone,
I would appreciate assistance with the following problem if possible. I require a Macro that will clear the contents of cells in row BD8:BI8 when the corresponding cell AT8 is either blank or zero (0). As soon as cell AT8 contains a value greater than zero (0) then any contents in cell range BD8:BI8 must remain undeleted. I require the same functionality to apply to all subsequent rows up to BD40:BI40 when the corresponding cell AT40 is subject to the conditions outlined above. Is there a solution? Thanks Very Much. SC |
#2
|
|||
|
|||
can you add an example workbook so we dont have to waste time recrerating the data
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Event macro: insert row with formulae based on current row, clear selected contents | emsa | Excel Programming | 5 | 04-17-2020 09:03 AM |
Copy a cell's contents across many cells | cloa513 | Word Tables | 13 | 09-19-2016 11:11 PM |
Macro to read cell contents and compare data | jrfoley3 | Excel Programming | 7 | 07-09-2016 12:25 PM |
Selection from cell with list contents autopopulates contents of another cell | markharper80 | Excel | 3 | 02-16-2015 04:18 PM |
Can anyone here tweek this macro for renaming Excel files based on a cell's contents? | chrisd2000 | Excel Programming | 6 | 07-01-2014 01:53 PM |