• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    I need a formula to recognise if a word is in a cell containting a para, then copy row to sheet 2

    Ah ha! I have never used this function before! Now I understand! Thank you for your help and patience!
  2. S

    I need a formula to recognise if a word is in a cell containting a para, then copy row to sheet 2

    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.
  3. S

    I need a formula to recognise if a word is in a cell containting a para, then copy row to sheet 2

    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?
  4. S

    I need a formula to recognise if a word is in a cell containting a para, then copy row to sheet 2

    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...
  5. S

    I need a formula to recognise if a word is in a cell containting a para, then copy row to sheet 2

    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.
  6. S

    I need a formula to recognise if a word is in a cell containting a para, then copy row to sheet 2

    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...
  7. S

    I need a formula to recognise if a word is in a cell containting a para, then copy row to sheet 2

    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...
Back
Top