Using Data Imported from another sheet

[rcm1946]

Hi

I wonder if someone could assist this an issue I am having.

I have a spreadsheet with Sheet1 and sheet2 - sheet 2 has data (a budget) and I am importing information from sheet 1 (i.e. ='Sheet 1'.B4) this data ends up in C8 on sheet 2 now I want to be able to use the imported data in a calculation i.e. +C7-C8 but I get an error #Value!

Many thanks for any help.

Richard

 

[venkat1926]

off the cuff

is B4 sheet 1 has formula or a string . what is in B4 sheet1 and c7 in sheet2

 

[rcm1946]

Hi

B4 has just data as is C7 i.e. $500.00 currency.

C8 on sheet 2 is the formula? ='Sheet 1'.B4 which I believe is the issue?

R

 

[venkat1926]

"i.e. $500.00 currency."
have you entered as text or number. suggest type just 500 and format as you like
now try

 

[GTO]

Hi

B4 has just data as is C7 i.e. $500.00 currency.

C8 on sheet 2 is the formula? ='Sheet 1'.B4 which I believe is the issue?

R

It may be a regional thing, but try ='Sheet 1'!B4

I am assuming a space exists in the name as shown, which is why the single-quotes got added.

 

[rcm1946]

Thanks Venkat,

I did that and it now works.