Requestor information/Rank/Positon is just for our awareness (who to contact for questions) - This info becomes irrelevant to the rest of the workbook
RHN is what we select (the user will not have access to this)
Mission Title - correlates to the mission title on the WIZARD which in turn correlates to the NETWORK DIAGRAM
Base - is the base that mission will be conducted on - Lat & Long auto populate based on their selection. If the Location is not listed then they enter custom info. I have an IF statement to pull data based off of what is entered.
From your description so far what I envision is similar to another project I completed for a government client. They have employees in the field that perform construction site inspections
to insure everything meets required standards. The employee fills out the "form" (a sheet of fields pertaining to various standards), then that data is stored in a database sheet (hidden from
the user's view/access). When the employee returns to their office and connects to their intranet, they click the "SEND" button on the form and the data is transferred from their field
copy of the workbook to the master workbook database. From that master workbook database the Executive Staff are able to search any active project to review various standards.
The Executive form version matches the field employee's copy. All that data stored on the master workbook database populates all the form fields. There are other variations how the
data is recovered from the master database and displayed as well for different purposes.
The attached PDF is the other client's field employee's version. Most of the fields are drop downs from which they can select. That eliminates errors and provides a consistent input of
I appreciate your explanations / descriptions so far but I'm still a little lost.
Knowing what info your requestor's are submitting & does it go into the master database for later retrieval & how is the data subsequently pulled out of the database & to which sheet / fields does the
data go .... all of that is what is required to move forward.
The best method (for me) is :
Sheet2 / Field: Last Name goes to Sheet4 / Cell A2
Sheet2 / Field: First Name goes to Sheet4 / Cell B2
Sheet2 / Field: Mid Ini goes to Sheet4 / Cell C2
Sheet2 / Field: Rank goes to Sheet4 / Cell E2
Sheet2 Field: Requested Date goes to Sheet4 / Cell G2
It will take some time and effort to accomplish the above but it will clearly state where everything goes.
So the only thing they fill in that transfers to the WIZARD sheet is MISSION TITLE & BASE ? The remainder of the information disappears or it is needed to be stored in the database ?
What does your database look like ? Is it another Excel sheet ? What are the column headers ?