Sorry Paul, being very new to this and somewhat simple minded I can't get it to work despite you expansive instructions in the Macro itself. I have tried using the Record Macro feature with some success, however, it won't maintain sequential numbering and requires a button on the QAT which is sub optimal.
The document contains 3 separate tables and I wish in each case that when the row is complete a new row is automatically generated. Some departments will have a dozen or so rows to complete, others will have dozens hence not wishing to fix the number of rows.
My instinct is to restrict editing on this just allowing the user to fill in the form and not fiddle with the headings. Am I being too ambitious or is this achievable by a complete novice?
|