ExcelBanter - Auto Repeat Data

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Auto Repeat Data (https://www.excelbanter.com/excel-worksheet-functions/37946-auto-repeat-data.html)

Mohd Rosdi

Auto Repeat Data

Dear Expert,

My data patern D, D, N, N, O, O, O, R . If I type D in a1 I want next to
follow with the rest of the pattern and repeat the same patern to as many
cell I want.

tq.

All times are GMT +1. The time now is 05:12 PM.