Formula Question

[Guest]

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

 

[tina]

suggest you post your question to an MS Excel newsgroup. this ng answers
questions about MS Access relational database software.

 

[Wolfgang Kais]

Hello "emgVA".

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.

This is a Microsoft Access newsgroup, not Excel.
Also, I'n not sure if you mix up workbooks and sheets.
Nevertheless: You can create a formula entering the = character and then
insert the cell references by clicking the respective cells. These cells can
reside on different worksheets and in different workbooks. For using
different workbooks, make sure that both files are open and change to
the other workbook using the window menu.
Don't move or rename the referenced file afterwards.