View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
uncreative uncreative is offline
external usenet poster
 
Posts: 12
Default Macro to populate data (repeating rows)

Hello,

Need help with code for repeating an entire row (x) amount of times. Data
exists in columns A, B, C, and the (x) is the qty listed in column B. I.e.
in the example below, I would want apples to repeat 18 times, and pears to
repeat 12 times.

A B C
APPLES 18 4.95
PEARS 12 2.95

Thanks!