lynx653
New member
- Joined
- Jan 7, 2015
- Messages
- 8
- Reaction score
- 0
- Points
- 0
hi,
here is a formula
='C:\Users\Lynx\Google Drive\mpppm\mpppmP\t2mpppmP\[Modul_Offline_KHB_PERT_T2.xls]BORANG PEREKODAN'!D3
I need to substitute the T2 (in Modul_Offline_KHB_PERT_T2.xls) with a string value in a cell (say it the cell C1)
The C1 shall be T1 or T2 or T3
Help(s) most appreciated
here is a formula
='C:\Users\Lynx\Google Drive\mpppm\mpppmP\t2mpppmP\[Modul_Offline_KHB_PERT_T2.xls]BORANG PEREKODAN'!D3
I need to substitute the T2 (in Modul_Offline_KHB_PERT_T2.xls) with a string value in a cell (say it the cell C1)
The C1 shall be T1 or T2 or T3
Help(s) most appreciated