Link two columns with updating

**touchofknowledge** · 12-15-2011, 05:36 PM

Hi all. I am currently working on a workbook with multiple worksheets. One of them, sheet A, has all the data. I would like sheet B to be a summary page with only the most important columns from sheet A.

The problem is, when you link cells normally (i.e. on sheet B, cell $A$1 would equal SheetA!A1, and that value would be pulled down the column), inserting and deleting rows is not reflected on the linked column.

I was wondering if there was an easy (or not so easy) excel or vba solution, so that if I insert a row in column A of sheet A, the row would be inserted in column A of sheet B as well.

Thanks a lot!

**TMShucks** · 12-15-2011, 05:40 PM

You can perhaps use VLOOKUP or SUMIF or SUMIFS.

No idea really based on what little information you have provided.

You may want to post a sample workbook and a more detailed description of what you want the output to look like.

Regards, TMS

**touchofknowledge** · 12-15-2011, 05:50 PM

Here's an example

**touchofknowledge** · 12-15-2011, 06:03 PM

And by insert, of course, I simply mean right clicking on column 5 (or whichever column) and clicking insert. I would like for that same row to be inserted on sheet B.

**TMShucks** · 12-15-2011, 06:10 PM

Try:

A2: =IF(ROW($A2)>MATCH(REPT("Z",255),SheetA!$A:$A),"",INDEX(SheetA!A:A,ROW(A2))) ... and copy down

B2: =IF(ROW($A2)>MATCH(REPT("Z",255),SheetA!$A:$A),"",INDEX(SheetA!D:D,ROW(A2))) ... and copy down and across.

Regards, TMS