If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I enter a formula using data from cells in seprate worksheets
I want to take the results of a fromula on one sheet and use it on another
sheet. I want to know if I can put a formula in that can draw information from cells in a different worksheet. |
#2
|
|||
|
|||
On Tue, 10 May 2005 10:56:05 -0700, "Brannon"
wrote: I want to take the results of a fromula on one sheet and use it on another sheet. I want to know if I can put a formula in that can draw information from cells in a different worksheet. Could it be as simple as? =Sheet2!A1, which returns the value in A1 on sheet2. Per Erik |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel - cursor moves to other cells after I enter data, without h. | mitzi | General Discussion | 2 | March 2nd, 2005 04:22 AM |
Formula presumes cells have data | Pat | Worksheet Functions | 1 | February 24th, 2005 04:13 PM |
how do i enter data for a # of years using a formula? | en_kobe | General Discussion | 0 | February 10th, 2005 07:19 PM |
VBA Code problem error 9 | Speedy | General Discussion | 19 | October 15th, 2004 09:05 PM |