ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can I enter a formula using data from cells in seprate worksheets (https://www.excelbanter.com/excel-worksheet-functions/25555-can-i-enter-formula-using-data-cells-seprate-worksheets.html)

Brannon

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.

Per Erik Midtrød

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


All times are GMT +1. The time now is 09:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com