I need to Auto Fill the same value into 6 cells multiple times. My issue comes up during the auto fill. Rather than receiving A2(six times), A3(six times), A4(six times), A5(six times)... as a reference point, I'm getting A2 (six times), but its immediately screwing up if I try to auto fill after that.
Solved by G. E. in 11 mins