H
HammerJoe
Hi,
I currently have a workbook with 7 sheets.
One called Main and the other are named with the weekdays names
(monday-saturday)
Each sheet has on top a pie chart showing the number of fruit sold
(theres 4) and on the right to the graph I have several rows with
calculations like totals and stuff for this particular sheet.
I want to have on the main sheet the same graph and the info on the
right of the graph copied for the correct sheet.
Basically what I am asking is how do I make the rows reference the
sheet that matches todays weekday?
On cell A1 I have =weekday(now())
So instead of having on row p3, '=Monday!p3' something like
'=whatevertheweekdayis!p3'?
I guess it is the same for the graph source?
Thanks for the help.
I currently have a workbook with 7 sheets.
One called Main and the other are named with the weekdays names
(monday-saturday)
Each sheet has on top a pie chart showing the number of fruit sold
(theres 4) and on the right to the graph I have several rows with
calculations like totals and stuff for this particular sheet.
I want to have on the main sheet the same graph and the info on the
right of the graph copied for the correct sheet.
Basically what I am asking is how do I make the rows reference the
sheet that matches todays weekday?
On cell A1 I have =weekday(now())
So instead of having on row p3, '=Monday!p3' something like
'=whatevertheweekdayis!p3'?
I guess it is the same for the graph source?
Thanks for the help.