Hi All,

Well, i was wondering if there could be any formula written where i have say four different columns suppose A having Week 1, B having Week 2, C having Week 3 and D having Week 4....i want the column A, B and C to change its numeric values when I change column D from Week 4 to Week 5....the column A, B and C should now show Week 2, Week 3 and Week 4 respectively.

chintu........