View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Prohock Prohock is offline
external usenet poster
 
Posts: 12
Default insert cell content and shift cells down

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!