I'm new here (and to any forum) so apologies in advance if I am not clear or my title isn't correct! I am desperate for help.
I have Sheet 1 with paragraphs of text (I work for lawyers!), if cells in column F contain the word 'payment' I need that row from A1:F1 to be copied to Sheet 2.
The cell in F will contain various words such as payment, contract .... etc.
Any ideas? I have tried the =IF(ISNUMBER(SEARCH("payment",F5)),Sheet!2B2,"")
Which is along the correct lines but I need it to copy the full row not just one cell....
I have Sheet 1 with paragraphs of text (I work for lawyers!), if cells in column F contain the word 'payment' I need that row from A1:F1 to be copied to Sheet 2.
The cell in F will contain various words such as payment, contract .... etc.
Any ideas? I have tried the =IF(ISNUMBER(SEARCH("payment",F5)),Sheet!2B2,"")
Which is along the correct lines but I need it to copy the full row not just one cell....