Is the 160 a fixed number of repeats or can the number of ABC's vary? If
they can vary, are the ABC's (and DEF's and whatever follows them) always
group together, one after the other as your limited example shows; or can
they be scattered all about)? Also, is Column G always fully filled in, but
Column A only has a single value in Row 1?

--
Rick (MVP - Excel)


"KrimerJ" wrote in message
...

Put the same number in A1 for 160 rows and change that number to the
next highest (ex. from 29 to 30) based on a value in cell G.

......A.............................G.
1.....29.........................."ABC"
2.....29.........................."ABC"
3.................................."ABC"
4.................................."ABC"
160..29.........................."ABC"
161..30.........................."DEF"
162..30.........................."DEF"
..................................."DEF"
..................................."DEF"

Need help..just a beginner in Excel VBA


--
KrimerJ
------------------------------------------------------------------------
KrimerJ's Profile: http://www.thecodecage.com/forumz/member.php?userid=227
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=84541