ExcelBanter - Column link

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Column link (https://www.excelbanter.com/excel-discussion-misc-queries/261881-column-link.html)

James

Column link

This is great!
Ok Next question:
I need to link every cell in column e worksheet 1 with every cell in column
j worksheet 2.
Its for closing balance in Jan, and opening balance in Feb.
Thanks all
James

FSt1

Column link

hi
i think this might work..
on sheet2 cell J1 enter......
=sheet1!E1
copy down as far as needed.

regards
FSt1

"james" wrote:

This is great!
Ok Next question:
I need to link every cell in column e worksheet 1 with every cell in column
j worksheet 2.
Its for closing balance in Jan, and opening balance in Feb.
Thanks all
James

James

Column link

='[Customer record.xls]Sheet1'!J2
did it for me

"FSt1" wrote:

hi
i think this might work..
on sheet2 cell J1 enter......
=sheet1!E1
copy down as far as needed.

regards
FSt1

"james" wrote:

This is great!
Ok Next question:
I need to link every cell in column e worksheet 1 with every cell in column
j worksheet 2.
Its for closing balance in Jan, and opening balance in Feb.
Thanks all
James

All times are GMT +1. The time now is 02:35 AM.