Formula needed to Autofill Custom Lists
Posted by Kurt on August 06, 2001 8:37 AM
I know you can drag and fill cells using data you created in a custom list. What I would like to do is have Excel fill in the list when a starting point in the custom list is presented.
Custom List = Q1-01, Q2-01, Q3-01, Q4-01.......
In Cell A1 I type Q2-01, I would like to have a formula that takes that info and continues the list from that point, i.e. Q3-01, Q4-01......
I want to avoid having to manually drag the list out each time I change the starting point.
I hope this presents a good challenge for someone.