Automatic Formula Updating

**jamaljan** · 07-24-2010, 03:42 PM

Well...couldn't think of a better title. I'll explain here what is that I mean by this.

I'm collecting data from around 40 field staff per month. The data structure is not inform in a way that all of them don't have similar number of columns to add data to.

I've resolved the protecting workbook by unlocking the cells to which they can add data BUT the problem is that if they want to add more columns, its not happening after I protect the worksheet.

I need to do 2 things:

1. the staff can add columns to the structure
2. after they have added the column(s), the formula in the final column (Total) should update automatically, i.e. it should include the columns added by the user.

Please tell me if this can be done in excel or should I use some other tool. Point in case, the majority of the staff are novice when it comes to excel.

Thanks & Regards

**jamaljan** · 07-24-2010, 04:00 PM

well, figured it out BUT what should I do so that....

for example if there are A to F columns and the column for Total is G, that the user should add a column only before F and not G, so that the formula is automatically updated