PDA

View Full Version : camembert



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

Bob Phillips
04-01-2010, 03:57 AM
Maybe

="'"&TEXT(TODAY(),"yyyymmdd"&'!$A$1:$A$11;'"&TEXT(TODAY()-1,"yyyymmdd")&"'!$J$1:$J$11
"

What is a camembert (apart from being a cheese)?

stefan0901
04-01-2010, 05:03 AM
camembert = pie

I am sorry, I am using a french version of excel

stefan0901
04-01-2010, 05:32 AM
I tried your code it doesn't seem to work. Can you check your formula for mistakes? Or is there another way to achieve this ?

Bob Phillips
04-01-2010, 06:30 AM
That got screwed up a bit. Try thius

="'"&TEXT(TODAY(),"yyyymmdd")&"'!$A$1:$A$11;'"&TEXT(TODAY()-1,"yyyymmdd")&"'!$J$1:$J$11"