Formula/Solution
Closed
RuthG13
Posts
1
Registration date
Wednesday 29 May 2019
Status
Member
Last seen
29 May 2019
-
29 May 2019 à 12:49
Blocked Profile - 29 May 2019 à 13:02
Blocked Profile - 29 May 2019 à 13:02
Related:
- Formula/Solution
- Driver pack solution - Download - Cleaning and optimization
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Credit summation formula - Guide
- Excel grade formula - Guide
1 response
This is callled data connections and it is possible, but you need to understand, the data is pulled from the other sheets, not pushed.
So you have a master sheet. This sheet is called MASTERSHEET, and is stored on the X drive (network share). This sheet is where you store your values.
Now, you have another sheet (named SECONDSHEET), that is stored on your local C drive. Your local machine is also mapped to the resource of X drive. Open SECONDSHEET, and click on the data tab.
Now click on CONNECTIONS. when new module pops up, click the add button. On the bottom of the new module, click BROWSE FOR MORE. Select ypur X drive and navigate to your MASTERSHEET file location. Finish the setting up of the data as you see fit.
Now, whenever SECONDSHEET is opened, it will pull the data from the MASTERSHEET.
So you have a master sheet. This sheet is called MASTERSHEET, and is stored on the X drive (network share). This sheet is where you store your values.
Now, you have another sheet (named SECONDSHEET), that is stored on your local C drive. Your local machine is also mapped to the resource of X drive. Open SECONDSHEET, and click on the data tab.
Now click on CONNECTIONS. when new module pops up, click the add button. On the bottom of the new module, click BROWSE FOR MORE. Select ypur X drive and navigate to your MASTERSHEET file location. Finish the setting up of the data as you see fit.
Now, whenever SECONDSHEET is opened, it will pull the data from the MASTERSHEET.
