Cypris2369
New Member
- Joined
- May 5, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
The following will obviously work so as long as SourceWorkbook.xlsx has a sheet named Sheet1:
=[SourceWorkbook.xlsx]Sheet1!$A$1
but what I want is this..
A1 = "SourceWorkbook.xlsx"
A2 = "Sheet1"
A3 = "$A$1" (as text)
A4 = =[A1]A2!A3
This obviously does not work.
Is there a way to achieve my goal? So far the only thing I can think of is to populate A1-A3 and then have a button to execute a VBA script that will assemble the formula for A4.
=[SourceWorkbook.xlsx]Sheet1!$A$1
but what I want is this..
A1 = "SourceWorkbook.xlsx"
A2 = "Sheet1"
A3 = "$A$1" (as text)
A4 = =[A1]A2!A3
This obviously does not work.
Is there a way to achieve my goal? So far the only thing I can think of is to populate A1-A3 and then have a button to execute a VBA script that will assemble the formula for A4.
