Get cell value into text

Closed

Mats - 3 Aug 2010 à 03:47
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 3 Aug 2010 à 07:36

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

Get cell value into text
Cell phone codes - Guide
Excel cell color formula - Guide
How to insert rows in excel automatically based on cell value without vba ✓ - Excel Forum
Insert the current date and time in cell a1 ✓ - Excel Forum
Excel conditional formatting if another cell contains specific text - Excel Forum

1 response

Réponse 1 / 1

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
3 Aug 2010 à 07:36

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

How to use conditional format based on text?

If a cell contains any text then add a value

Excel - IF function with multiple words

Looking For a Value in a Cell

Similar discussions

Subscribe To Our Newsletter!