Automatic recalculation without having to change formula

I have a worksheet that calculates the last 6 months of information. Is there a formula that will automatically change the cell range to the last 6 columns once you have entered another column? I need to keep the previous information. I usually add the new column, hide the oldest column, and then change the cell range manually. This leaves room for user errors and is a great big pain in the badonky donk. I would appreciate any help.I am wondering if you are talking about Reporting Services, as you are takling about cell ranges ?

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||

I really have no idea at all. I will give you an example.

6 month total Jan Feb Mar Apr May Jun July Aug

Kim 4639.00 492.00 875.00 921.00 785.00 567.00 924.00 567.00 824.00

Each month I add the new information to the spreatsheet. Now when I enter the totals for August I want Excel to automaticaly grab the last 6 months of information. So when I Enter August it will automaticaly drop off the February totals and pick up the newly entered August totals. I don't know if this is possible, but it would be really nice if Excel could do this. Right now I have to manually change the formula for each person. Each person has 4 different 6 month totals to calculate. For me this is not so bad because there are only 2 employees in our office, but I have received emails from other offices that have quite a few employees and this would be helpful. It would also reduce operator error.

A Greniger

|||Group your values to the month, use a matrix to display the data and put the month on the horizontal axis, and the user (seems in your case) on the vertical one.

Jens K. Suessmeyer.

http://www.sqlserver2005.de