I've been work on this for weeks and still can't figure out how to auto fill data based on certain criteria with out leaving blank rows.
Here is what i'm trying to attempt, see attached: In my "Cathodic Protection Sheet", I what to auto fill data based on text in "Services" Column M. What i got so far is this Formula =IF(Services!M2="Steel",Services!B2,"") which works fine. However, I prefer it without the blank Rows.
I'd be greatly appreciated if anyone can help me. Sheers!
Bookmarks