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

'Find the last used row in Column G
LastRow = wsData.Range("G" & Rows.Count).End(xlUp).Row

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!!