I need a macro that will check each cell in column B to see if the cell contains "Available." If, say, B6 contains "Available," I need J6 to clear, and so on through all used rows in the worksheet. I know this should be simple, but I haven't been able to adapt other similar solutions I've found to this particular situation.
Thanks in advance for any help you can offer.
Bookmarks