Forum Discussion

Tobias Askholm Bülow's avatar
Tobias Askholm Bülow
Copper Contributor
Sep 27, 2018

Help with an autofill problem

We have a problem where we have to make 500 lines of the text ALARM{[NUM]} Where the single difference on each line is that num goes from 1 to 500, and Excell doesn't seem capable of this.   Is th...
excel
office 365
  • Lorenzo Kim's avatar
    Lorenzo Kim
    Sep 27, 2018

    pls see attached file.

    one by VBA - one by manual process.

    hope you can make something out of it.

    thanks..

Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
Sep 27, 2018

pls see attached file.

one by VBA - one by manual process.

hope you can make something out of it.

thanks..

Tobias Askholm Bülow's avatar
Tobias Askholm Bülow
Copper Contributor
Sep 27, 2018

Thank you Lorenzo, we ended up doing it manually, but have definitely learned something, and appreciates it :)

  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Sep 27, 2018
    welcome..

Resources