| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
link columns from one worksheet to another
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
link columns from one worksheet to another
Select the sheet1,sheet2 & sheet 3 using ctrl key. ( grouping )
On Dec 3, 12:32*am, link columns from one worksheet to other <link columns from one worksheet to 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
link columns from one worksheet to another
I did and it did nothing. sorry...
"muddan madhu" wrote: Select the sheet1,sheet2 & sheet 3 using ctrl key. ( grouping ) On Dec 3, 12:32 am, link columns from one worksheet to other <link columns from one worksheet to 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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
| How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
| How do I link columns from one worksheet to another in the workbo. | New Users to Excel | |||
| How do I copy a link that is in columns to another worksheet down. | Excel Discussion (Misc queries) | |||
| How to link Excel worksheet tab names to dates in each worksheet? | Excel Worksheet Functions | |||
Linear Mode
