Values from one workbook to another

Solved/Closed
Report
Posts
2
Registration date
Tuesday September 29, 2015
Status
Member
Last seen
September 30, 2015
-
Posts
2
Registration date
Tuesday September 29, 2015
Status
Member
Last seen
September 30, 2015
-
Hello,
I need help - I have two worksheets one with costs and formulas
I want to pull the answer from the formula block from the one worksheet to the other.

I've used this formula on worksheet 2 to pull in from worksheet 1 =+'[Complete cost price list OCTOBER 2015.xlsx]PG 1 - UG PIPE'!$F$7
but it only works where there is no formula in the block on worksheet 1

where there is a formula i get a error

Charmaine

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Charmaine,

You seem to have mixed up worksheet and workbook. A sheet is like a page and a book is like a file.

Try adding the formula VALUE for pulling data from a formula in different workbook.

As in:
=VALUE('[Complete cost price list OCTOBER 2015.xlsx]PG 1 - UG PIPE'!$F$7)

Best regards,
Trowa
Posts
2
Registration date
Tuesday September 29, 2015
Status
Member
Last seen
September 30, 2015

Thank you Trowa.
You rock
It worked :-)