Forum Discussion

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

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