Constructing Tabs for Update-Ability
Using the Replace tab with new version using current user inputs menu option, users can replace an old version of a tab with the new version and push the user inputs from the old version to the new version of the tab.
For this to work properly, the tab must be constructed so that SDA knows where to push each user input.
There are two methods that SDA uses to determine where to push user inputs:
Part numbers in the PartDetailSection – When a user enters a value into column A (Qty Calcd) or column B (Qty Adj) for a row that contains a part number in column C, SDA will take the entered value on the old tab, look up the part number on the new tab, and enter the value into column A or B as appropriate.
This method requires no additional set up by the administrator.
Single-cell named ranges – When the named range exists on the old and new versions of the tab, SDA will push the user-entered value from the old tab to the new tab.
This method requires additional set up by the administrator.
The Administrator should name every unprotected (blue) single-cell input cell on the tabs other than those in columns A and B of the PartDetailSection.
Name a range by clicking on a cell and typing a name in the Name Box, which is just to the left of the formula box on the Formula Bar.
In both methods, SDA will only look to push values (not formulas) from unprotected cells.