How do I Increment a particular woksheet number?
I have the following entry:
=CONCATENATE(Master!$R$2,Master!$R$3,A4,Master!$R$ 4,Master!$C$4)
I would like the successive lines to increment both the A4 (which it
does) but also the final Master!C$4. I would like the column to look
like this when I'm done dragging it down:
=CONCATENATE(Master!$R$2,Master!$R$3,A4,Master!$R$ 4,Master!$C$4)
=CONCATENATE(Master!$R$2,Master!$R$3,A5,Master!$R$ 4,Master!$C$5)
=CONCATENATE(Master!$R$2,Master!$R$3,A6,Master!$R$ 4,Master!$C$6)
=CONCATENATE(Master!$R$2,Master!$R$3,A7,Master!$R$ 4,Master!$C$7)
etc....
Is there a way to write it so that the final number also increments
when I drag it down?
Thanks in advance.
Nicolai
|