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

Get cell value into text
Run macro when cell value changes - Guide
If cell contains text then return value in another cell ✓ - Excel Forum
If a cell contains any text then add a value ✓ - Excel Forum
Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
Highlight cell if another cell contains text - 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

Excel - IF function with multiple words

How to use conditional format based on text?

Highlight cell if another cell contains any text

If cell = date return yes or no.

Counting cells containing only numbers

Similar discussions

Subscribe To Our Newsletter!