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
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)?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
camembert = pie
I am sorry, I am using a french version of excel
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 ?
That got screwed up a bit. Try thius
="'"&TEXT(TODAY(),"yyyymmdd")&"'!$A$1:$A$11;'"&TEXT(TODAY()-1,"yyyymmdd")&"'!$J$1:$J$11"
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
