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
charms72 Posts 2 Registration date Tuesday September 29, 2015 Status Member Last seen September 30, 2015 - Sep 30, 2015 at 02:32 AM
Related:
- Values from one workbook to another
- Vba copy data from one workbook to another - Guide
- Transfer data from one excel workbook to another automatically - Guide
- Run macro on opening workbook - Guide
- Excel vba add sheet to another workbook - Guide
- Macro to copy data from one workbook to another based on criteria ✓ - Excel Forum
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
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
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
Sep 30, 2015 at 02:32 AM
You rock
It worked :-)