Hi,

I'd like to automate the following procedure using a
macro. Please help.

1) i have 2 sheets: Sheet1 & Sheet2
2) In Sheet1, Cells B2,D2,F2 has the formulas "=Sheet2!
F2", "=Sheet2!K2", "=Sheet2!P2" correspondingly.
3) Every month when i do my work, i'd have to manually
rekey the formulas to reference the subsequent columns,
ie, Cell B2,D2,F2 will change from above to "=Sheet2!
G2", "=Sheet2!L2", "=Sheet2!Q2" and in the following
month, I have to change manually again to "=Sheet2!
H2", "=Sheet2!M2", "=Sheet2!R2". Is it possible to have a
macro to perform this manually?
4) The above shld apply to the whole column, ie, Cell
B10, D10, F10 should reference "=Sheet2!H10", "=Sheet2!
M10", "=Sheet2!R10".

Thank you!
Val