complex linking data and files

[Ruth]

Hi

I have a file that has 3 different worksheet that someone can choose to fill
out depending on the number of ports that they go to. The data they input
has various dates and times-- when arrive, start.. depart. Each worksheet as
at least 2 ports.

I have another file that they need to fill out sometimes and it has some of
the same information required it-- tricky thing is that it could be in 3
different worksheets and at various location on each one depending on the
order they go to each dock, so a direct link would not work.

I was wondering if there is a way that if a port is selected on these sheets
if there could be an option created to add in information for the port to the
other document and it automatically takes certain cells over to the other
file, triggered by the port that is selected.-- the information that would
have to be carried over would be in the same cell relative to the cell with
the port name.... ei in cell A1 is the port name and A3 is where the cell is
with the information.
in Cell B1 is the port name and B3 is where the cell is with the information

 

[Jacob Skaria]

Dear Ruth

If my understanding is correct; the below will help.

To return a value from sheet2 of the same workbook use the formula
=Sheet2!A1

Likewise if you want to return value from a different workbook which is open
=[Book2.xls]Sheet2!A1
OR
=[Book2]Sheet2!A1
(if it is not a saved workbook)

Now if you want to add a condition use IF() statement/formula. The below
formula checks whether Book2 A1 contains a port and if found returns value
from Book 2 A3. If not returns a blank
=IF([Book2.xls]Sheet2!A1="Someport",[Book2.xls]Sheet2!A3,"")


You can adjust these forumlas to suit your requirement.

If this post helps click Yes

 

[Ruth]

Thank-you!

I think this is a bit beyond me-- I don't know how to explain what I want it
to do properly.
I will try again later when I can wrap my mind around it a bit more

Thanks again.
--
Thank-you!
Ruth

Dear Ruth

If my understanding is correct; the below will help.

To return a value from sheet2 of the same workbook use the formula
=Sheet2!A1

Likewise if you want to return value from a different workbook which is open
=[Book2.xls]Sheet2!A1
OR
=[Book2]Sheet2!A1
(if it is not a saved workbook)

Now if you want to add a condition use IF() statement/formula. The below
formula checks whether Book2 A1 contains a port and if found returns value
from Book 2 A3. If not returns a blank
=IF([Book2.xls]Sheet2!A1="Someport",[Book2.xls]Sheet2!A3,"")


You can adjust these forumlas to suit your requirement.

If this post helps click Yes
---------------
Jacob Skaria

Hi

I have a file that has 3 different worksheet that someone can choose to fill
out depending on the number of ports that they go to. The data they input
has various dates and times-- when arrive, start.. depart. Each worksheet as
at least 2 ports.

I have another file that they need to fill out sometimes and it has some of
the same information required it-- tricky thing is that it could be in 3
different worksheets and at various location on each one depending on the
order they go to each dock, so a direct link would not work.

I was wondering if there is a way that if a port is selected on these sheets
if there could be an option created to add in information for the port to the
other document and it automatically takes certain cells over to the other
file, triggered by the port that is selected.-- the information that would
have to be carried over would be in the same cell relative to the cell with
the port name.... ei in cell A1 is the port name and A3 is where the cell is
with the information.
in Cell B1 is the port name and B3 is where the cell is with the information

 

[Ruth]

Thank- you

I think this is a bit beyond me. I can't think of how to explain what I
want it to do properly.

I will try again once I can wrap my mind around it.

Thanks again!
--
Thank-you!
Ruth

Dear Ruth

If my understanding is correct; the below will help.

To return a value from sheet2 of the same workbook use the formula
=Sheet2!A1

Likewise if you want to return value from a different workbook which is open
=[Book2.xls]Sheet2!A1
OR
=[Book2]Sheet2!A1
(if it is not a saved workbook)

Now if you want to add a condition use IF() statement/formula. The below
formula checks whether Book2 A1 contains a port and if found returns value
from Book 2 A3. If not returns a blank
=IF([Book2.xls]Sheet2!A1="Someport",[Book2.xls]Sheet2!A3,"")


You can adjust these forumlas to suit your requirement.

If this post helps click Yes
---------------
Jacob Skaria

Hi

I have a file that has 3 different worksheet that someone can choose to fill
out depending on the number of ports that they go to. The data they input
has various dates and times-- when arrive, start.. depart. Each worksheet as
at least 2 ports.

I have another file that they need to fill out sometimes and it has some of
the same information required it-- tricky thing is that it could be in 3
different worksheets and at various location on each one depending on the
order they go to each dock, so a direct link would not work.

I was wondering if there is a way that if a port is selected on these sheets
if there could be an option created to add in information for the port to the
other document and it automatically takes certain cells over to the other
file, triggered by the port that is selected.-- the information that would
have to be carried over would be in the same cell relative to the cell with
the port name.... ei in cell A1 is the port name and A3 is where the cell is
with the information.
in Cell B1 is the port name and B3 is where the cell is with the information