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 reply

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 547
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

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

15 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Copy Worksheet to another Workbook (unopened)
Josh -
Josh -

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

12 responses
Pate values
Jan -
rizvisa1 -

2 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response