Find last used cell from a col with specific header

hi all, need a bit of help.. I'm using this to find last used row in a known column

Please Login or Register  to view this content.

problem is, my known col is sometimes G, sometimes H, and maybe a difft col altogether. So I would like to check for last used cell in the col that has a heading name which CONTAINS a given string value.. Also, I want to check the VALUE of that last cell once I find it, if value=0 (cell contains a sum fx) then I don't want to copy this sheet.

e.g.,

find a header cell that contains "remit" (always on row4, A4:P4)
find the last used cell in that col
check the value of that last used cell, if >0 [do something else]

any quick help would be appreciated, thanks!!

thanks so much, will try it out now