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

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

Based on the values in cells b77
Name Values - Excel Forum
Code to move rows into another sheet based on certain values ✓ - Excel Forum
Based on the values in cells b77 b81 c77 - Excel Forum
How do I get a value in a cell based on another cell - Excel Forum
Looking For a Value in a Cell - Excel Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

help me to add particular cells

Clear cell contents based on value of another cell range using VBA

Return Seq Values Until Blank value then return different set of seq values

Fill adjacent cell with number from text answer

Excel function question

Similar discussions

Subscribe To Our Newsletter!