Values from one workbook to another
Solved/Closed
charms72
charms72
- Posts
- 2
- Registration date
- Tuesday September 29, 2015
- Status
- Member
- Last seen
- September 30, 2015
charms72
- Posts
- 2
- Registration date
- Tuesday September 29, 2015
- Status
- Member
- Last seen
- September 30, 2015
Related:
- Values from one workbook to another
- Macro to copy data from one workbook to another based on criteria ✓ - Forum - Excel
- Creating multiple workbooks from a template and a list of names ✓ - Forum - Excel
- How to transfer data from one excel workbook to another automatically using macro - Guide
- How to transfer data from one excel workbook to another automatically - Guide
- Excel vba create new workbook and paste data ✓ - Forum - Excel
1 reply
TrowaD
Sep 29, 2015 at 11:43 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
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 :-)