IDW Parts list sorting with I logic

[Ikruse]

Hello all,

I am looking to setup an I logic rule to sort our parts list. I would like it to be in alpha numerical order by "part number", and then re arrange the "item" column in numerical order from 1-20 and so on. Is there anyone on here who can provide me the rule for this? I have found parts of this code online but nothing that meets this requirement. I would like to set this rule up on our active sheet template.

Any help in this matter would be greatly appreciated!

Thank you in advance!

Isaac Kruse

[rhasell · Accepted solution]

Hi

Set the column width to "1" this will hide it from view. (don't forget to update your template with the new parts list formats)

[ankurGCK9S]

It works !! thank you so much. 

I am trying few change to suit my requirement.

---

@rhasell wrote:

Hi

Set the column width to "1" this will hide it from view. (don't forget to update your template with the new parts list formats)

---