Hi all,

I am trying to accomplish the following and can't seem to figure it out. I
have a tab of monthly data Jan - Dec where Jan is in Cell A1...

I have a second tab that links to tab 1. Tab 2 is a one month at a time
snapshot. So right now all cells are linked to January on Tab 1. Instead of
doing a Find/Replace on formulas on Tab 2 to switch the month to say Feb is
there a way I can put in box in cell A1 of tab 2 where the user can input a
month (A - L). Then instead of linking directly to A1 on the other tab I can
insert a formula that says Start with A1 if there is something in the box the
substitute the "A" with whatever is in the box? Ie for March it would be "C"
thus C1?

Thanks