January 17, 2020
I have a relatively basic question.
I want to set values to a range of cells in Excel, using the formula = $A$1 & "." & 1. (or ="Question."&1, not to complicate my question too much)
In my case A1 is the title of the section, say 'Question', but that varies from section to section.
A2 Question.1 (formula =$A$1&"."&1)
A3 Question.2 - this is how I want it to be, and the next cells should be Question.3, Question.4 etc.
Now Question.2 is what I want to be written in A3 but dragging the formula from A2 doesn't work. And I really want this to work automatically (drag the formula), because I'm operating with cca. 1000 cells.
Does anybody have a solution?
Many thanks, Peter