Hyperlinking/linking cells in different worksheets/books

[rjc_29]

Is there a way i can link cells in two different workbooks in particular individual cells. For example

workbook 1 has several worksheets and in one of the worksheets say Jun_07
cell c174 contents include aa/123456/07

workbook2 worksheet 2
cell k202 contents include aa/123456/07, 14/06/07

[oldchippy]

Is there a way i can link cells in two different workbooks in particular individual cells. For example

workbook 1 has several worksheets and in one of the worksheets say Jun_07
cell c174 contents include aa/123456/07

workbook2 worksheet 2
cell k202 contents include aa/123456/07, 14/06/07

If you have both Workbooks open, go to WB1 cell A1, press = click cell c174, then type "&" without quotes, then click WB2 cell k202, i.e

=[WB1.xls]Sheet1!$C$174&[WB2.xls]Sheet1$K$202

[rjc_29]

Hi

I can't type the formula in cell a1 as this has the column headings, and those cells were just an example as the majority of the cells in the worksheets/workbooks have stuff in them of a similar nature.

Is there another way

[oldchippy]

It doesn't have to be in cell A1, that was just an example, you can use any cell. Give it a try in a set of "dummy" workbooks.