Get cell value into text
Closed
Mats
-
Aug 3, 2010 at 03:47 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 3, 2010 at 07:36 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 3, 2010 at 07:36 AM
Hello,
I'm having trouble to get an automatic update of filename in function
='[Time_report_August.xlsm]Time report'!$AH$20
I want to read the August part in the filename from a cell in order to be able to have this dynamically changeable.
How should I do?
BR
M
I'm having trouble to get an automatic update of filename in function
='[Time_report_August.xlsm]Time report'!$AH$20
I want to read the August part in the filename from a cell in order to be able to have this dynamically changeable.
How should I do?
BR
M
Related:
- Get cell value into text
- If cell contains date then return value ✓ - Excel Forum
- Excel formula to check if cell contains a date - Excel Forum
- If cell A1 has text then cell B2 has today's Date ✓ - Excel Forum
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Excel send value to another cell - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 3, 2010 at 07:36 AM
Aug 3, 2010 at 07:36 AM
So are you saying that you want to build this "Time_report_August.xlsm" string dynamically and then excel evaluate it to you the result. In that case you have to use address and indirect functions, I would imagine