Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
link cell in to different worksheets in same workbook excel 2003
I have four pages in an excel workbook and want to link North, South, Mid to
Results, I have entered = into cell C6 in Results but I can only link one worksheet and I need all three, please help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
link cell in to different worksheets in same workbook excel 2003
Hi,
I assume that your tabs are named "North", "South" etc and the result you want to pull out is in cell C6 so enter =North!C6+South!C6+Mid!C6 change range or sheet name to fit your needs "Jimmpy" wrote: I have four pages in an excel workbook and want to link North, South, Mid to Results, I have entered = into cell C6 in Results but I can only link one worksheet and I need all three, please help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
link cell in to different worksheets in same workbook excel 2003
Do you mean something like this:
=TRIM(North!A1 &" "& South!A1 &" "& Mid!A1) ? If you have numbers that you want to add together then you can do this: =North!A1 + South!A1 + Mid!A1 Put the formula in A1 on the Results sheet and copy to other cells as appropriate. Hope this helps. Pete On Jul 29, 12:28*pm, Jimmpy wrote: I have four pages in an excel workbook and want to link North, South, Mid to Results, I have entered = into cell C6 in Results but I can only link one worksheet and I need all three, please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link text between different worksheets within a workbook | Excel Discussion (Misc queries) | |||
no worksheets in a workbook - Excel 2003 | Excel Discussion (Misc queries) | |||
Link Worksheets within a Workbook | Excel Discussion (Misc queries) | |||
Synchronizing multiple worksheets in a workbook (Excel 2003) | Excel Discussion (Misc queries) | |||
how do I link worksheets in the same workbook? | Excel Worksheet Functions |