Loop for substitution

[joshua1990]

Hey guys!


I have used concatenation to create a path which, depending on the month, references a specific cell in another table (= 'PATH ...... TBL! A1)
Unfortunately, these paths arenot active until I replace the "=" with a "=".I would like to automate this somehow by means of a button.
That I set in F2 a number which defines the calendar week and thus also the area.When pressing the button, all cells in C: C should be replaced by "=", which contain the corresponding calendar week in B: B.
Does anyone have an idea for this?

I've already used the recorder, but I can not develop a helpful approach.


Attached is an example file.Example.xlsx

greeting

[georgiboy]

Not quite sure what you are after here but, if you are making a reference to a cell using Concatenation or just & then you will need to use the indirect function.

=Indirect(“A” & 1)

maybe even hyperlink:

=Hyperlink(path)

hope this helps