i have a column (say column AA) of existing values. beside that column (AB) i want to have a vertical list of fill series which repeats itself after a certain value. for example, B0-B15 and then back to B0 again. I know that can be accomplished using fill series. But the problem is when it is not in sequence. For example, in column AA, row 1 to row 7 will correspond to B0 to B6 in column AB. But i want to skip the next 2 rows or so den continue B7 to B15. and then maybe skip a few rows again and continue back from B0. i tried using filter for column AA but the fill series dun work with filter on. any ideas?