• 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

    Help with VBA code to search/compare and copy row

    Thank you for the time that you have put into this, however it doesn't seem to work? It just keeps returning an invalid inside procedure. I tried to fix it but my knowledge is limited and can't seem to do it!
  2. S

    Help with VBA code to search/compare and copy row

    Yes that's right except it needs to only search Column A of ASX300 for the sectors with consumer discretionary in them. Then copy the ones to consumer discretionary that aren't already there. Does that make sense? That code i sent is a nightmare. So many things wrong with it i think. I'm very...
  3. S

    Help with VBA code to search/compare and copy row

    Hello everyone, I am very new to VBA and am trying to create a piece of code (Button is in ASX workbook) that compares each row of data in column A of worksheet ASX300 with the data in worksheet Consumer Discretionary and if not found copy the entire row and display a text box highlighting new...
  4. S

    Return sheet name from search

    Oops, sorry. Please try this!
  5. S

    Return sheet name from search

    Ok no worries please see attached document. Thank you in advance!
  6. S

    Return sheet name from search

    Hello all, I can't seem to get this to work. I have multiple worksheets in a workbook and i need a formula that I can use to search the rest of the workbook and return the sheet name in the cell. For example i have a lot of seperate sectors within the stock market that are found on multiple...
Back
Top