Help altering code to auto increment a particular cell

[Smeghead]

https://www.dropbox.com/s/2h71f03su89o98w/2012.xlsm

In that file, some kind person helped create some code which basically helps automatically fill in the entire row when I simply type in some unique data in the J column. E.g. Type in "JE100" in a J column cell, and it'll automatically copy the entire "JE100" row from the "Jeans" sheet. This is the code:

Please Login or Register  to view this content.

I'd like to know if there's any way to alter it so that after I type it in, it also auto-increments the last number in the L (Tote) column by 1. Right now I fill all the values I need in J column, and then once I've finished then I press the little black square in the bottom right of the cell to fill out the cells in sequence. If I could automate that it'd be nice.

Thank so much in advance.

[xladept]

Hi SmegHead,

Here's a quickie - you may want to use your auto-increment algorithm instead

Please Login or Register  to view this content.