Thread: How to format cells to duplicate for every 5 rows.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alicia Alicia is offline
external usenet poster
  
Posts: 34
Default How to format cells to duplicate for every 5 rows.
I am working on a sheet that already has ID numbers in column a. in the
format listed below. This goes on for about 300 rows

47846
47847

How can I format the sheet to look like this:
47846
47846
47846
47846
47846
47840
47840
47840
47840
47840
I need to list information in column b and c that corresponds to column a.
However, column a must contain the corresponding id number. Is there a way I
can automate this instead of doing it manually?
Reply With QuoteReply With Quote