I have a workbook that I am working in that has several worksheets. I have
the master and then it is broken down into different cateragories off of the
master sheet. I want to link the rows and columns to the master so when the
master is changed it will change the information in that particular
worksheet. Is that possible and if it is not to link entire rows or columns
is there a way to link it to the master with just using the reference #
instead of the row and column. Example: reference #'s are 12.3.2 in the
master. I would like to link it just to that file in the master instead of
rows or columns. I had some of them linked and the master got resorted so it
threw all of my links off. I would so much appreciate any help.
Thank You

On Nov 5, 8:31*am, charob wrote:
I have a workbook that I am working in that has several worksheets. I have
the master and then it is broken down into different cateragories off of the
master sheet. I want to link the rows and columns to the master so when the
master is changed it will change the information in that particular
worksheet. Is that possible and if it is not to link entire rows or columns
is there a way to link it to the master with just using the reference #
instead of the row and column. Example: reference #'s are 12.3.2 in the
master. I would like to link it just to that file in the master instead of
rows or columns. I had some of them linked and the master got resorted so it
threw all of my links off. I would so much appreciate any help.
Thank You

You should describe your data to make it easier to offer assistance.
Where is the reference number? What does the data look like (rows,
columns)?

You can probably use lookup functions to do this, VLOOKUP or MATCH/
INDEX, etc. Those would survive sorting.

I will try to describe my data as well as I can.
On the master I have rows like below
Column A-Assigned to
Column B - Standard #
Column C- Standard Title
Column D- Documents used
Column E- Time Frame when needed
Column F- Documents used
Column G- Notes

Changes are made more often in the Columns a and G. Instead of linking those
to =master!A1 I would like to link them to Column B Standard # so that if the
master gets sorted again it will follow that standard. I hope that makes
sense. Thank You for you help.

"Spiky" wrote:

On Nov 5, 8:31 am, charob wrote:
I have a workbook that I am working in that has several worksheets. I have
the master and then it is broken down into different cateragories off of the
master sheet. I want to link the rows and columns to the master so when the
master is changed it will change the information in that particular
worksheet. Is that possible and if it is not to link entire rows or columns
is there a way to link it to the master with just using the reference #
instead of the row and column. Example: reference #'s are 12.3.2 in the
master. I would like to link it just to that file in the master instead of
rows or columns. I had some of them linked and the master got resorted so it
threw all of my links off. I would so much appreciate any help.
Thank You

You should describe your data to make it easier to offer assistance.
Where is the reference number? What does the data look like (rows,
columns)?

You can probably use lookup functions to do this, VLOOKUP or MATCH/
INDEX, etc. Those would survive sorting.