Linking Cells
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 |
Linking Cells
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. |
Linking Cells
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. |
All times are GMT +1. The time now is 09:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com