R
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
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