Formula/Solution

Posts
1
Registration date
Wednesday May 29, 2019
Status
Member
Last seen
May 29, 2019
- - Latest reply: ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
- May 29, 2019 at 01:02 PM
Hi,

Is there a way for me to link in one spread sheet the Leave Dates that will automatically apply to the specific date in a second/third/forth spreadsheet and then in a particular cell it would write: Away Surname.

For example:

They are on vacation from 2019/07/01 - 2019/07/05 documented
then
in each day (cell): July 1st, July 2nd, July 3rd, July 4th, July 5th
Would put the text Away Surname

If their wasn't a match to leave blank with the (,"")

Any help would be appreciated!
See more 

1 reply

Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1568
0
Thank you
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.

Respond to ac3mark