ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How 2 tie cells in same row so they move as a ROW if table change (https://www.excelbanter.com/excel-discussion-misc-queries/131053-how-2-tie-cells-same-row-so-they-move-row-if-table-change.html)

Nat Maxwell

How 2 tie cells in same row so they move as a ROW if table change
 
I have a table of terms (listed in column A on one worksheet) which is LINKED
to column A on another sheet within the same workbook. On this second
worksheet, each term "picked up" from column A of the first worksheet is
displayed against its respective definition on the same line/row in column B,
and the matching cross-reference for each term is listed on the same line in
column C.
My problem is, every time I add a new term to the lilst in column A on the
first sheet, the linked column A on the second sheet throws everything out of
whack, and the terms no longer match up with their definitions and
cross-references in columns B and C respectively.
Is there a way to tell Excel to treat each row as an inviolable ENTRY and
ENTITY, and to shift the other two columns up or down every time I add or
delete a term in the first column of the first sheet?
Thank you in advance for any help!


All times are GMT +1. The time now is 03:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com