• 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

    VBA improvement on development of stock prices

    Hi guys. I have with assistance from you experts learnt a code that keeps track of the development of a stock price on a daily basis. The problem is that the code becomes useless when I forget to update the sheet one day. Can you please take a look and explain if I can make a code that skips...
  2. S

    Copy paste values from daily web query

    Hi. I have a web query which is updating stock prices daily (sheet 2). I have an IF formula in sheet 1 which retrieves the daily quote if there is a match on the current date. The problem is that I have to copy/paste values each night to prevent the formula to mess up yesterdays quotes. Is there...
  3. S

    Can't substitute and remove spaces

    Hi. I have tried both the TRIM and the SUBSTITUTE formula but the spaces won't go away in row G. Please help.
  4. S

    Copy row to different sheet if criteria is met

    Hi. I have a worksheet with values from A1:K1901. Lets call it Worksheet1 The critical values are in the K column. I want to copy all the rows to Worksheet2 if a text criteria is met in the K column. I am not familiar with macros, so a formula would be much appreciated :)
  5. S

    Autocopy the first cell with more than 30 characters after a criteria is met

    Hi. I want to take my last question a bit further (history from last session): "Hi. I am using Excel 2010. I have a workbook with a web query. Is it possible to autocopy the first cell that has more than 30 characters to a different sheet? It would help me a lot, because I then could see...
  6. S

    Autocopy the first cell with more than 30 characters to a different sheet?

    Hi. I am using Excel 2010. I have a workbook with a web query. Is it possible to autocopy the first cell that has more than 30 characters to a different sheet? It would help me a lot, because I then could see if there were any changes from the Website. Example: "Sheet1" Range F1:F238...
Back
Top