Hey guys! You have been a big help so far but I got another question (not surprisingly).
So I have this worksheet that has a database of about 20,000 items and on occasion we will have to input new ones. The items are organized by item number (column A) in numerical order. They also have a bunch of different values associated to them (columns B through L) but the most important ones are item number (column A), units (column E) and description (column L). We want to put in a row on top of the list (input in row 2, list would start at 7, headers at 5) where we can fill in the 3 main pieces we need filled out, item number (column A), units (column E) and description (column L), click a button, and have it automatically create a new row (based on numerical order) and input the values we entered. If there's a way for it to double check and see if the item already exists (so we don't add duplicates by mistake), that would be awesome, but its not necessary. Also we need column A to be formatted as text (even though we are inputting numbers). Any help you guys can offer would be much appreciated, thanks!
So I have this worksheet that has a database of about 20,000 items and on occasion we will have to input new ones. The items are organized by item number (column A) in numerical order. They also have a bunch of different values associated to them (columns B through L) but the most important ones are item number (column A), units (column E) and description (column L). We want to put in a row on top of the list (input in row 2, list would start at 7, headers at 5) where we can fill in the 3 main pieces we need filled out, item number (column A), units (column E) and description (column L), click a button, and have it automatically create a new row (based on numerical order) and input the values we entered. If there's a way for it to double check and see if the item already exists (so we don't add duplicates by mistake), that would be awesome, but its not necessary. Also we need column A to be formatted as text (even though we are inputting numbers). Any help you guys can offer would be much appreciated, thanks!
Last edited: