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