M
muster
I need to do a report in a workbook, the file is like this,
there are tabs for each year named 2005, 2006, etc. On each tab, there
are quarters, like
Q1 Q2
data1 data2 data1 data2
I'd like to link a data based on current quarter and year, for example,
I want on Report sheet,
A1 -> 2006.Q2.data2
in which 2006 and Q2 are variables (referenced by names like CurY,
CurQ).
How to construct the lookup or offset? Thank you.
there are tabs for each year named 2005, 2006, etc. On each tab, there
are quarters, like
Q1 Q2
data1 data2 data1 data2
I'd like to link a data based on current quarter and year, for example,
I want on Report sheet,
A1 -> 2006.Q2.data2
in which 2006 and Q2 are variables (referenced by names like CurY,
CurQ).
How to construct the lookup or offset? Thank you.