View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mfn mfn is offline
external usenet poster
 
Posts: 1
Default copy a worksheet to new one with repeat rows 5 times

I have worksheet with 1000 rows.
i want to copy it to another one with repeat every row 5 times and put a
certain different values in column B every 5 times like:
B
32
42
654
76
4
..
..
..
32
42
654
67
4
and so on