Code required to add details onto a separate sheet in order

[CPAC]

Hi, I'm trying to create a green "ADD" button on the "INPUT" sheet that will add any new codes and details (shown in RED) into the "CODES" sheet.

The "CODES" sheet needs to be automatically arranged in increasing code value 170045, 170046, 170047 etc... I'm not sure if this is possible?

Also if a current saved code is entered it needs to overwrite the old code, not add a new entry. I hope that makes sense.

Any help would be greatly appreciated.

[GC Excel]

Hi CPAC,

Here's a suggestion:

Please Login or Register  to view this content.

[CPAC]

Hi, Thank you for the help. It seems not to work when it gets to the sort codes, any ideas?

Thanks...

[CPAC]

'Sort codes
'ws2.Cells(1).CurrentRegion.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlYes

[GC Excel]

Are you data starting in A1 of the CODES sheets as in your sample workbook?

[CPAC]

Hi the "CODES" sheet needs to be automatically arranged in increasing code value 170045, 170046, 170047 etc... does this make sense?

Code values start in A2, A1 is text is this the issue?

[GC Excel]

I don't understand why it doesn't work. Sort is ok when I test with your sample file.
Can you share the file that has problems?

[daboho]

Of try using bubbleSort

Please Login or Register  to view this content.