View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SRK SRK is offline
external usenet poster
 
Posts: 7
Default Creating a variable print list

I have a list of 40 apartment names and want to print each name on 200 to 300
individual labels. My variable print software requires these in a continuous
list in one column: i.e. Name A, 300 times; Name B 200 times; Name C 250
times and so on. Is there an easier way than copying and pasting 40 names
into a column. I'm looking for a formula to do this.
--
Thanks for your suggestions.