Need Macro To Sequence And Auto Sort Data

Hi,

Need help to have a macro to do auto sequence

Macro will lookup to column F for the sequence under "Data" tab. Based on column F "number starts from 7xxx", sequence will be 1,2,3,4,etc, then "number starts from Axxx", sequence will be 1,2,3,4,etc. as long starting number/alphabet is different, sequence will restart to 1,2,3,4,etc

With the sequence determine, I need the macro to go to "Shortage" tab and do the auto sort of the whole data in it. Need the macro to sort column A based on sequence of the same material#.


TIA!

I have put in additional column called "Seq" in both tabs and do a macro. However, i do not want to add additional columns and would like the macro do the sequence background.

I cannot get the code right. Need help on this.

TIA

Try looking here for more info https://www.thespreadsheetguru.com/t...ort-cell-range. Cheers

Hi maniacb,
Thanks for the info. However, I want to sequence based on column F of the other tab "Data".

Also I need the sequencing to base on individual numbers starts from 7xxx, Axxx, Bxxx, etc.

Thanks, Karmapala. Nice! This does help me.

So I tried to add in all my other macros and try to sort it (first column B, followed by column AL) in "Shortage" tab. Seems like it does not work.

Need help to see what went wrong.

TIA

Hi Bubbles_A,
I'm very sorry for my late reply.

Originally Posted by Bubbles_A

Thanks, Karmapala. Nice! This does help me.

Glad that the code can do a little to your expectation.

So I tried to add in all my other macros and try to sort it (first column B, followed by column AL) in "Shortage" tab.
Seems like it does not work.

I downloaded your attachment sample workbook then run your code.
In my side it doesn't throw me an error.

So, the "does not work" that you mean is:
A. it throw you an error
B. it does not throw you an error, but the result is not that you are expecting.

Is it A or B ?

Hi,
I managed to get it solved. Thanks for all the help rendered.