Excel '03 ?
Thread Starter
|
Posting Guru
Joined: Mar 2005
Posts: 1,460
Likes: 0
Excel '03 ?
Does anyone know if you can reference data from 'sheet 1' in excel to "sheet 2' in excel in the same workbook file? This is excel 2003. Just trying to keep from having to much on the same page......
Thanks,
RC
Thanks,
RC
Moderator
Joined: Aug 2005
Posts: 164,379
Likes: 82
From: MA
Sure can....
Just click on the cell then select the cells you want to include..
This is a sample formula..
=Sheet1!A3+Sheet2!A1
Notice if you are typing it out that the reference is Sheet1! then the cell number.
Just click on the cell then select the cells you want to include..
This is a sample formula..
=Sheet1!A3+Sheet2!A1
Notice if you are typing it out that the reference is Sheet1! then the cell number.
Thread
Thread Starter
Forum
Replies
Last Post
TheWiz427
General NON-Automotive Conversation
10
Dec 12, 2004 09:45 AM
