I am trying to write a macro that will go through a worksheet (about 20,000 rows of data) and check every cell in column C and if the values are either "Cash" or "Paid" then change a cell in the same row but in Column N to become "Checked" and "Added" respectively. Does this make any sense? I have been trying to record some Macros but nothing seems to work. Note I want to solve this through a Macro not a formula appoach.
Thanks for looking at my question.