Hi I am a completely new to VBA and have a question.
Is there any way to create a formula that will either highlight (in red lets say) an entire row, or move the entire row to another worksheet, if one cell has "Y" in it. Moving the entire row would be preferable.
I have been able to highlight the one cell, but I need to either highlight the entire row, or move it completely, and this seems to be way beyond my capabilities.
Any help would be much appreciated.
Bookmarks