Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I can do a vlookup for data from a closed workbook, but it requires me to code the formula to the destination cell.
as an example.
Is there a means of doing this without applying the formula to the cell? I suspect that after I save the workbook, and reopen it, I get flagged that cells contains links to other workbooks that I'd like to avoid.
Code:
worksheet("Sheet1") = “=VLOOKUP(RC[-3],(‘C:\exceltrainingvideos\[customers-email-mobile.xlsx]Sheet1’!R2C1:R10C3),2,FALSE)”
Is there a means of doing this without applying the formula to the cell? I suspect that after I save the workbook, and reopen it, I get flagged that cells contains links to other workbooks that I'd like to avoid.