auto fill sequancial data

A

Art

How can I setup, auto fill of data in Excel. For Eg: I want to start from
AAAAA and finisz with ZZZZZ, and let the program generate, everything in
between, but in sequance. AAAAA, AAAAB, AAAAC, AAAAD etc.etc.
 
J

Jason Morin

Not sure if this is the sequence you're looking for, but
put AAAAA into cell A1, then put this in A2 and fill down
to row 129:

=IF(ROW()>104,CHAR(CODE(LEFT(A1))+1),LEFT(A1))&IF((ROW()
78)*(ROW()<104),CHAR(CODE(MID(A1,2,1))+1),MID(A1,2,1))&IF
Click to expand...
((ROW()>52)*(ROW()<78),CHAR(CODE(MID(A1,3,1))+1),MID
(A1,3,1))&IF((ROW()>26)*(ROW()<52),CHAR(CODE(MID(A1,4,1))
+1),MID(A1,4,1))&IF(ROW()<=26,CHAR(CODE(RIGHT(A1))
+1),RIGHT(A1))

HTH
Jason
Atlanta, GA
 
Top