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