View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default link columns from one worksheet to another

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

"link columns from one worksheet to other" wrote:

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!