Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
copy a row from one worksheet to another, based on criteria
wy -
vcoolio -

15 responses
Macro-Copy data from one workbook to another
Krishna -
Dvibe -

12 responses
Lookup across whole workbook (muliple sheets)
mad -
Mark -

6 responses
Copy worksheet from one workbook to another workbook in MS Office Excel
SrinivasNittala -
ac3mark -

1 response