| Home |
| Search |
| Today's Posts |
|
#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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
| Macro to delete data in 'green' cells only | Excel Worksheet Functions | |||
| How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Importing Data Into Formula Based Cells | Excel Worksheet Functions | |||
Linear Mode
