Values from one workbook to another

Solved/Closed
charms72 Posts 2 Registration date Tuesday September 29, 2015 Status Member Last seen September 30, 2015 - Sep 29, 2015 at 10:14 AM
charms72 Posts 2 Registration date Tuesday September 29, 2015 Status Member Last seen September 30, 2015 - Sep 30, 2015 at 02:32 AM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Sep 29, 2015 at 11:43 AM
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
0
charms72 Posts 2 Registration date Tuesday September 29, 2015 Status Member Last seen September 30, 2015
Sep 30, 2015 at 02:32 AM
Thank you Trowa.
You rock
It worked :-)
0