Hi,

Please help with the following inquiry.

I have 1 spreadsheet with 2 separate workbooks. I want to use the value in
a cell from workbookA to be used in a cell in workbookB. Is this possible?

Also, I have 2 different spreadsheets. I want to use the value in
spreadsheetA to be used in spreadsheetB. Is this possible.

Thank you in advance for any help given
--
emgVA

Ahhh, Terminology

First the answer is yes, just try
type = in first cell, then click on the second cell
doesn't matter where this second cell is
try same sheet, differetn sheet in same book, then a sheet in a different
book

Workbooks contains worksheets - typically Sheet1, Sheet2 etc

So not sure what you mean by spreadsheet with 2 workbooks,
but anyway as I said it works and will give you references similar to these

Book1, Sheet1 A1 refers to A1 in Sheet2 of same Workbook
=Sheet2!A1

Book2, Sheet1 A1 refers to A1 in Sheet1 of the first WorkBook
=[Book1]Sheet1!$A$1

The [Book1] will change to [filename.xls] when it is saved
and then to c:\path\[filename.xls]Sheet1!$a$1 when the first book is
closed.

Steve

On Sun, 28 Jan 2007 03:48:00 -0000, emgVA
wrote:

Hi,

Please help with the following inquiry.

I have 1 spreadsheet with 2 separate workbooks. I want to use the value
in
a cell from workbookA to be used in a cell in workbookB. Is this
possible?

Also, I have 2 different spreadsheets. I want to use the value in
spreadsheetA to be used in spreadsheetB. Is this possible.

Thank you in advance for any help given

Another way.

Select the "sending" cell
edit|copy
Go to the "receiving" cell
edit|paste special|click paste Link.

But often times, you'll want to modify that formula.

='Sheet 99'!a1
will return a 0 if that cell is empty.

You could use:
=if('Sheet 99'!a1="","",'Sheet 99'!a1)

If it's empty, return something that looks blank. Else return the value.


emgVA wrote:

Hi,

Please help with the following inquiry.

I have 1 spreadsheet with 2 separate workbooks. I want to use the value in
a cell from workbookA to be used in a cell in workbookB. Is this possible?

Also, I have 2 different spreadsheets. I want to use the value in
spreadsheetA to be used in spreadsheetB. Is this possible.

Thank you in advance for any help given
--
emgVA

--

Dave Peterson