link columns from one worksheet to another

  • Thread starter Thread starter link columns from one worksheet to other
  • Start date 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!
 
Select the sheet1,sheet2 & sheet 3 using ctrl key. ( grouping )
 
I did and it did nothing. sorry...

muddan madhu said:
Select the sheet1,sheet2 & sheet 3 using ctrl key. ( grouping )
Click to expand...
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel VBA 1
multiple criteria from single worksheet 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
auto update to multiple worksheets 2
Linked cells between worksheets and sorting 2
linking one worksheet to another 2
Paste Values in linked Cells Only 4

Back
Top