joshua1990
01-29-2018, 11:21 AM
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.21471
greeting
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.21471
greeting