Before you Autofill, make sure you select 2 sequential cells so XL can see
what pattern you are looking for.

In your scenario, you would need to select both G11776 and G11777
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Annie" wrote:

Hi I am using autofill and have some values with text. Example: G11774,
G11775 and G11776. This is just in general format and has now stopped
working when I try to fill it down using the AutoFill handle I am getting
G11777 over and over again - I need it to increment to G11778, G11779 etc.

Can anyone help. I am using 2000 (sorry but the company won't change)!!

Thanks
--
Kind regards

Ann Shaw