Mirroring workbook

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
2,961
.
Good.

I don't see a correlation between all of the fields on the COMPANY SAT REQUEST sheet and the WIZARD sheet.

Would you be so kind to provide an 'equals' list for me, resembling like the following so I can understand the correlation ?




A
B
C
D
E
F
G
1
Company Sat RequestWizard
2
3
RequestorProgram Mgr / Last, First, Middle
4
5
RankRank
6
7
Duty PositionRHN
8
9
Mission TitleMission Title
10
11
etc.etc.
 
Last edited:

rbscott1989

New Member
Joined
Apr 25, 2019
Messages
9
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.
 

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
2,961
.

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
data.

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

etc.

etc.

It will take some time and effort to accomplish the above but it will clearly state where everything goes.

Additional Questions:

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 ?


PDF example : https://www.amazon.com/clouddrive/share/b1FnnmXY4Hx0CYkqeZGlgqZBYyhbb6HvWgfE3BGRFjW
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,090,293
Messages
5,413,591
Members
403,494
Latest member
Adilson MAchado

This Week's Hot Topics

Top