Hi all:

New poster and complete Excel novice with a multi-part request (though eager to learn and VERY grateful for any help!!). I'm assuming I need a Macro to take care of all of this, though I'm open to any recommendations.

I've created a table in a worksheet where Column A will be a product ID number, Column B will be a drop-down list, Column C will be for manual entry, etc.; the table has headers, so data entry starts at row 2. I need to do four related things with this table:

1.) If Rows 2-9 are consecutively numbered 1-8 in Column A, when the user makes a drop-down selection in B10 and/or manually enters something in C10, I need A10 to automatically display the number 9 (and so on - the table will eventually have 200+ rows, with new rows added weekly).

2.) Users will sort the table according to what's in Column B or C - the ID numbers in column A need to stay associated with their original rows:

....A B C ==> Sorted alphabetically by Column B becomes: ....A B C
1 2 C Q 1 3 A X
2 3 A X 2 4 B R
3 4 B R 3 2 C Q

3.) Users will add content to Columns B/C while the table is sorted; the ID number that generates must be the existing maximum number in Column A + 1.

....A B C ==> The ID # in A4 should automatically fill in as 5
1 3 A X
2 4 B R
3 2 C Q
4 D S

4.) I need this numbering system to continue to work even if some rows are hidden, and even if certain rows get deleted.

I hope that's all clear; let me know if more information is needed.

Thank you so much!