Hi all,
Please see attached worksheet. The top table (blue) requires user entry in the quantity column only. The user can only put quantity in a maximum of 4 parts. I would like the bottom table (orange) to be able to recognize which values in column B from the top table have a quantity greater than zero and put their names in column A. Therefore if done correctly, {A14 = Part 2} {A15 = Part 4} {A16 = Part 6} {A17 = Part 8}. How would I accomplish this?
Thanks in advance
Book1.xlsx
Bookmarks