Given the following cell value: 037-1090000 in B29.
Is it possible to create a custom drag fill series where characters 5&6 (the "10" potion) would change instead of the last digits of the cell value? Furthermore, fill by numbers need to be divisible by 10 and the custom drag & fill would only be applicable to range("B29:B37'). Possible??
Finished result would look like this:
037-1090000
037-2090000
037-3090000
037-4090000
037-5090000
037-6090000
037-7090000
037-8090000
037-9090000
Thanks!
Bookmarks