Dynamic Range(Table) with column headings that are formulas
Posted on 2011-02-14
I am using MS Excel 2010 and I know that you can create a dynamic range using the Table feature. My problem is when I try to do that I get a message that says "Formulas in the header row will be removed and converted to static text. Do you want to continue". My header row contains the following formula:
So it will be just the weekdays when I copy it over.
I don't want to remove the formulas but I want to be able to copy the column over each day and have the range expand.
Is there a way to accomplish this?