I need to prepare a weekly progress chart of a construction project. For this purpose I maintain a sheet wherein I put the progrees of work after the end of each week. In this sheet progress of work for all the weeks can be found. In the second sheet I copy the progress of work of the current week from the database of the first sheet. Printout of the second sheet is taken at the end of the week to show to my seniors. To update the second sheet I need to change all the cell addresses against each items of progress with respect to the cell address of the current week of the first sheet. For example, suppose there are ten items against which I need to give the weekly progress. Also suppose, progress of n-th week in the database sheet (first sheet) are in cells A5,B5,......,J5. Then, these cells will be referred in the current week's progress in the second sheet. However, for the progress in the (n+1)th week the cell values to berefrred in the first sheet will be A6,B6,....,J6. I want to know how can this updating in the second sheet be done without changing all the cell addresses manually for all the ten items. Can any formula be used to change the cell address from A5 to A6 and like? Abhijit

You lost me.. Bryco may be able to help, but I have a suggestion.. You may want to consider Microsoft Project. It's perfect for scheduling projects and tracking...which is exactly what you're doing. Life is more painless for those who are brainless.

Personally, I'd do it the other way around; create the weekly and have it update the other sheet. Select A6:J6 and drag it down. Otherwise, I'll defer to Michael J. or another for a macro solution. Bryan

You could use vlookup to control which row from your first sheet is reported on. Add a column to the left of your data in the first sheet and enter the week number. In the second sheet create a cell to record the week number you want to report on (say AA1). Then make your report find it's data by using vlookup based on AA1. eg =vlookup($aa$1,'first sheet!a1:z500,2,false)

Thanks catch. Your solution really worked. Abhijit