Link columns to rows

Question

Not being very good with formulas for this, here is what I want to do.

Link column data on a worksheet labeled, IVCC" in cells G3 thru G18 and link it to worksheet labeled, "year", row cells C41 thru C56.

Thanks,

Dan

Answer 1

Not being very good with formulas for this, here is what I want to do.

Link column data on a worksheet labeled, IVCC" in cells G3 thru G18 and link it to worksheet labeled, "year", row cells C41 thru C56.

Thanks,

Dan

In the Worksheet called:-

IVCC

 - highlight the range:-

G 3 to G 18

 - then:-

CTRL + C

 - to copy.

Go to the Worksheet called:-

Year

 - and click in cell:-

C 41

 - then:-

Home tab

Clipboard group

Click on the drop down arrow beneath the word:-

Paste

 - then in the section called:-

Other Paste Options

 - click on:-

Paste Link (N)

Answer 2

Just click in C41, type "=", then navigate to the worksheet labeled IVCC and click on G3 and hit return. Fill down to cell C56 and it will be done.

Alternately, if you are using Excel 365, after typing the "=", navigate to the IVCC sheet; then click and drag from G3 to G18; then hit return. The single spill formula will complete the task with no need to fill down.

Answer 3

Ah. Cool!

Answer 4

Thanks for the quick reply. That works if I want to copy/paste. I want to link them so they update automatically.

Cheers,

Dan

. . and that's exactly what my proposed solution'll do.

Answer 5

Thanks for the quick reply. That works if I want to copy/paste. I want to link them so they update automatically.

Cheers,

Dan