|Hello! I have a spreadsheet for event tracking, but there need to be multiple rows/ event so there is one row per participant. Some information needs to remain constant, like the event date, time, etc, but some needs to be tailored to the participant, like type of participant, prep work to be done, etc.|
However, the problem is that if a "constant" detail were to change, not all the entries would be updated. The macro I had is
Dim i As Long
i = Selection.Row
Range("A" & i & ":I" & i + 1).FillDown
which worked fine, but I want it to somehow fill with =Rowabove, or be linked somehow. Is this possible?