|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
08-27-2004, 03:07 PM
|
#1 |
|
Member (7 bit)
Join Date: Feb 2002
Posts: 70
|
excel
Hello everyone, just a quick question ,with excel if you are using for example,three sheets,can you call on a range of cells from one worksheet to the other,is there a way to merge them,hope i havent confused you all
|
|
|
|
08-27-2004, 04:06 PM
|
#2 |
|
Barefoot on the Moon!
Staff
Premium Member
Join Date: Aug 2002
Location: Northeastern USA
Posts: 13,384
|
Do you mean from 3 seperate files, into one file with seperate sheets, or 3 seperate sheets in one file into one sheet?
__________________
There are two secrets to staying young, being happy, and achieving success. You have to laugh and find humor every day, and you have to have a dream.
|
|
|
|
|
08-27-2004, 04:53 PM
|
#3 |
|
Member (7 bit)
Join Date: Feb 2002
Posts: 70
|
what i mean is if im working in sheet three ,im in cell b3,and i want to referance cells in b3 to b40 in sheet one, i hope that makes it clearer,thanks for replying.
|
|
|
|
|
08-27-2004, 07:07 PM
|
#4 |
|
Member (7 bit)
Join Date: Feb 2004
Location: NL, Canada
Posts: 78
|
You bet you can. I use Office XP so I don't know if you're using something different but go to the sheet where you want to make the reference in, put in the classic = sign and then go to the sheet the other info is held and highlight it. Hope that helps.
Edit: To do it by hand it would look something like this. ='sheetname'!cellstoref need the = sign of course, need to put the sheetname in single quotes add the ! mark and then the cell name like D16 or whatever. Beautiful he says, beautiful! Last edited by Gibble; 08-27-2004 at 07:11 PM. Reason: add info |
|
|
|
|
08-27-2004, 07:17 PM
|
#5 |
|
Member (11 bit)
Join Date: Jan 2002
Location: british columbia canada
Posts: 1,361
|
Thanks for the help
|
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
