Thank you. The problem I have is that I can't see the macro to edit when I select Macros. I have changed all the security settings enabling macros but still cannot see it. Attached show what I mean ..... normally I can see macros I create myself.
Exactly!!!! I do have an issue with macros, we are completely locked down on them! but I can deal with his. Thank you so much.
How can I achieve this myself?
Ok, back in London and I have done a little mock up (attached). I need the formula to look at row F and wherever it sees the word 'payment' for example, I need that whole row copying to Sheet2. The word payment will sometimes be alongside other words. It then has to do the same for every row...
Apologies, I realised you need facts, I tried explaining without the example file only because, working for lawyers, I can't send a copy of what it is that I am working on and to create a 'sample' of the same will take me a moment and I was travelling from Munich at the time of writing.
Thank you.
Thanks however, this doesn't appear to work. Also Cell F2 will have a paragraph of text in that one cell and I need it to only copy the row if it contains the word 'payment' ..
This formula just keeps telling me that the formula is incorrect...
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...