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
- How to copy data from one excel workbook to another using macro - Guide
- Based on the values in cells b77 b81 - Excel Forum
- Find values based on colum and sum in a table - Office Software Forum
- Fixing populating values into textboxes based on showing data in listbox ✓ - Excel Forum
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
547
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 :-)