Linking Rows instead of just cells.
Does anyone know if you can link entire rows to each other rather than just
linking them cell by cell? Also can I link by other information in the master copy other than the colums and row that the information is in. Example Column A Row 1 Standard Assigned to Column B Row 2 Standard # Column C Row 3 Description of Standard I would like to link to the Standard # instead of column and Row. Thanks so much. |
Linking Rows instead of just cells.
Try setting up the whole row as a named range, For Example
Your Row2 Could be named "Standard" When you reference this whole row from a different cell, use the following sintax: =Standard Then you could do the same thing for the Column -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "charob" wrote: Does anyone know if you can link entire rows to each other rather than just linking them cell by cell? Also can I link by other information in the master copy other than the colums and row that the information is in. Example Column A Row 1 Standard Assigned to Column B Row 2 Standard # Column C Row 3 Description of Standard I would like to link to the Standard # instead of column and Row. Thanks so much. |
All times are GMT +1. The time now is 12:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com