Hi everyone,

I am not sure where to start here.

I have data that is exported to excel from an SaaS database . It is not very organized and has many blanks and skipped rows. In column A I have all headings and titles( I am looking for CASH in this column) if Coumn A has cash, I want to take the columns E and F on the same row as "CASH" and extract column G for that specific area (which is also in Column A as "Area: Various"

I am not sure where to start with this macro, please help. I hope I have explained this enough. Please let me know if more explaination is needed.