stefan0901
04-01-2010, 03:41 AM
Hello,
I am creating a macro concerning a camembert. When I go to "select data", I enter:
='20100331'!$A$1:$A$11;'20100331'!$J$1:$J$11
Every day I have to update my camembert for the new day. So today, I would have to replace 20100331 two times by 20100401.
Does somebody know how to work out a macro which does this automatically.
Thank in advance
I am creating a macro concerning a camembert. When I go to "select data", I enter:
='20100331'!$A$1:$A$11;'20100331'!$J$1:$J$11
Every day I have to update my camembert for the new day. So today, I would have to replace 20100331 two times by 20100401.
Does somebody know how to work out a macro which does this automatically.
Thank in advance