Result Proglem
Hi again:
Sorry to bother, but I do have another question: I am using two sheets. I need sheet 2 go gather the result from sheet 1 for a given cell (A1). This cell, A1, has a formula in it that works fine. Let's say the result of the formula is "apple". I need to be able to gather the result "apple", not the formula, from sheet one and place it into A1 on sheet 2. Anybody have an answer? As I am new to this forum, I hope to be able to contribute sometime myself. Thank you so very much. Prior Sayin |
=Sheet1!A1
-----Original Message----- Hi again: Sorry to bother, but I do have another question: I am using two sheets. I need sheet 2 go gather the result from sheet 1 for a given cell (A1). This cell, A1, has a formula in it that works fine. Let's say the result of the formula is "apple". I need to be able to gather the result "apple", not the formula, from sheet one and place it into A1 on sheet 2. Anybody have an answer? As I am new to this forum, I hope to be able to contribute sometime myself. Thank you so very much. Prior Sayin . |
once again - many thanks.
Prior Sayin wrote in message ... =Sheet1!A1 -----Original Message----- Hi again: Sorry to bother, but I do have another question: I am using two sheets. I need sheet 2 go gather the result from sheet 1 for a given cell (A1). This cell, A1, has a formula in it that works fine. Let's say the result of the formula is "apple". I need to be able to gather the result "apple", not the formula, from sheet one and place it into A1 on sheet 2. Anybody have an answer? As I am new to this forum, I hope to be able to contribute sometime myself. Thank you so very much. Prior Sayin . |
All times are GMT +1. The time now is 01:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com