• 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. G

    Does VBA macros have a max number of cells?

    I just used the Macro recorder and created this "Fill_Blanks" code. I have a column w many blanks. I want to fill in all the blanks by referring to the last non-blank cell above. (I tried the GoTo Special Blanks =cellref CTRL+ENTER trick, but the range was too big) I was wondering if I am...
  2. G

    Anyone ever use Tableau?

    Soooooo pretty! Just wondering if all this could also be done in excel? I have my hands full trying to wrap my head around vba and Access o_O I don't know if I have the intestinal fortitude to try yet ANOTHER software product... But the pictures sure are pretty!
  3. G

    How do I automate the YTD avg of previous yrs based on the # days in current yr

    How do I automate the YTD average of the previous years (i.e. 2008, 2009, 2010, 2011) to update as soon as I populate the data for the current year (i.e. 2012)? For example, as of June 22, 2012 we have 121 total trading days. How do I automate the average of 121 days in 2008, 2009, 2010 and...
Back
Top