G
Guest
i have a list of 4 periods from 1-4 located in cells B1 to B4 as follows
Period 1
Period 2
Period 3
Period 4
I would like the text TA inserted depending on the numeric value of Cell A1.
So if Al=2 TA would be inserted between Period 1 and Period 2 as follows:
Period 1
TA
Period 2
Period 3
Period 4
or if A1=3 the following would occur:
Period 1
Period 2
TA
Period 3
Period 4
I would perfer that a worksheet function accomplish this task rather than a
macro. Please help!
Period 1
Period 2
Period 3
Period 4
I would like the text TA inserted depending on the numeric value of Cell A1.
So if Al=2 TA would be inserted between Period 1 and Period 2 as follows:
Period 1
TA
Period 2
Period 3
Period 4
or if A1=3 the following would occur:
Period 1
Period 2
TA
Period 3
Period 4
I would perfer that a worksheet function accomplish this task rather than a
macro. Please help!