link columns from one worksheet to another

  • Thread starter link columns from one worksheet to other
  • Start date
L

link columns from one worksheet to other

We have a workbook which contains 3 worksheets. Columns A through C in
worksheet 1 need to be linnked to the other 2 worksheet. How do I do this?
thanks!
 
L

link columns from one worksheet to other

I did and it did nothing. sorry...

muddan madhu said:
Select the sheet1,sheet2 & sheet 3 using ctrl key. ( grouping )
Click to expand...
 
S

Shane Devenshire

Hi,

In general we wouldn't link 65,536*3 cells in a worksheet - so a little more
detail might help.

=Sheet2!A1

could be copied down or to the right (on sheet1) as far as necessary.

Or

=Sheet2!A1+Sheet3!A1

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 
Top