+ Reply to Thread
Results 1 to 3 of 3

Automatic Formula Updating

  1. #1
    Registered User
    Join Date
    04-08-2010
    Location
    Karachi, Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    22

    Automatic Formula Updating

    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

  2. #2
    Registered User
    Join Date
    04-08-2010
    Location
    Karachi, Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: Automatic Formula Updating

    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

  3. #3
    Registered User
    Join Date
    04-08-2010
    Location
    Karachi, Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: Automatic Formula Updating

    hmm oke sry, didn't knew that. I've also posted the same question on this forum http://www.mrexcel.com/forum/showthr...=1#post2387111

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1