W
Wayne Burritt
Hi: I have the following data arrangement...
B C D E F G H I
J K L
2004
Q1
Column B year and quarter are input cells, which can be any quarter (Q1-Q4)
and any year. What I want to do program a macro that automatically fills in
historical data for the year and quarter up to column L. The data should be
declining, by quarter like this...
B C D E F G H I
J K L
2004 2003 2003 2003 etc
Q1 Q4 Q3 Q2 etc
Thanks. Wayne
B C D E F G H I
J K L
2004
Q1
Column B year and quarter are input cells, which can be any quarter (Q1-Q4)
and any year. What I want to do program a macro that automatically fills in
historical data for the year and quarter up to column L. The data should be
declining, by quarter like this...
B C D E F G H I
J K L
2004 2003 2003 2003 etc
Q1 Q4 Q3 Q2 etc
Thanks. Wayne