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!
Bookmarks