Please thanks
Please thanks
XL 2003 - Tools, Options , Custom list tab, click New List on the left and enter list values in the right hand side box, click Add, click OK
XL 2007 - Office Button, Excel Options, Popular, Edit Custom List, click New List on the left and enter list values in the right hand side box, click Add, click OK
Now you can use the fill handle to autofill with the previously defined list
hth
Last edited by teylyn; 11-14-2009 at 06:43 PM.
sol'n already posted
Last edited by protonLeah; 11-14-2009 at 06:54 PM. Reason: repeated
Ben Van Johnson
just paste this list in where teylyn suggested
Last edited by martindwilson; 11-14-2009 at 08:23 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks.
excelLENT!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks