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

Values from one workbook to another
Transfer data from one excel workbook to another automatically - Guide
Run macro on opening workbook - Guide
Copy data from one workbook to another vba - Guide
Excel vba add sheet to another workbook - Guide
How to copy macros from one workbook to another - Excel Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

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 :-)

Similar discussions

help me to add particular cells

Fill adjacent cell with number from text answer

Excel function question

Return Seq Values Until Blank value then return different set of seq values

Clear cell contents based on value of another cell range using VBA

Similar discussions

Subscribe To Our Newsletter!