aletheapyre

Thanks for your prompt response! I had some problems when I tried your suggestions. I hope your or someone else can suggest solutions. 1. I thought of this, but unfortunately the form has some very strict requirements, and I cannot have a blank line between the subtotal and the the items when we submit it. As the forms are frequently amended, if someone initially deletes the extra row, then adds it back later, the function will not work. If I change the size of the extra row to something very small, then my people would have difficulty adding rows above it. I dont think this option will will be practical. 2. I really like this suggestion, but when I tried it said I was creating a circular reference (which is true). How can I fix this?

I very rarely use excel, so if theres an easy solution to this, feel free to pat me on the head. I have a very basic excel inventory tally sheet, which has a number of subcategories (ie properties, investments, debts, etc). The item value in each subcatagory needs to be summed up. Now, I can manage this, but the problem is this: the basic template only has 1 row in each subcategory, and when you add more rows, they wont add correctly in the total cell. So I want a formula that will add the 1 row with any subsequent rows that are inserted. I want to keep things as simple as possible, as the people who will use this sheet are even worse at excel than I am.

I encountered a similar problem. What I did was 1. insert a text form field where the person would enter their name. in the Properties of the text field, check the box labeled "Calculate on exit". 2. With your cursor at the point where you want the name to automatically update, click Insert > Reference > Cross-Reference 3. Select “Bookmark” from the “Reference Type” pull-down menu. Select “Bookmark Text” from the “Insert Reference To” pull-down menu. 4. Select the name of the text field you want referenced under the “For Which Bookmark” box. 5. Click “Insert”, then “Close”. The Calculate on Exit box ensures that after you enter your text into the text field and hit tab, it automatically updates all cross references that are linked to the text field. Hope that helps (even if its late...)

Is there any way to keep the 1st and 2nd-end footers the same while seperating the 1st page header? Also, the document itself is a Form template. Is there any way I can put a text field into the footer so my people can update it without unprotecting the document and messing everything up? (not that I'm bitter) On a related note, is there any way I can cross-reference a text field in a document itself that will update automatically into the footer? I have put cross-references in in footers before, but I always have to rightclick them and select "update field", instead of them doing it automatically. Thank you.

There is likely an easy solution to this, but I'm not as computer literate as I think I am. I have created documents that contain text form fields, but my coworkers often accidentally delete them. I can't use the Protect Form button, as the protected text often needs to be changed case by case. Is there any way I can lock or embed the text fields so that they cannot be deleted? Thanks.