Nostrmontis
New Member
- Joined
- Mar 13, 2018
- Messages
- 1
Hi,
I'm trying to sort individual columns, removing duplicates (keeping 1 original), and then sorting those columns alphabetically.
I currently have a code that copies a list of all of our beer names to column B:Y, and respective sizes to column A. (pasted values only)
I would like to delete cells column by column, if the cells in column A (Target Row) match specific text ("1/6 BBL", "1/2 BBL", etc..) OR match the column header if that works as well.
I would then like to eliminate all duplicates in each column so that only 1 name of each applicable type remains.
I plan to do all of this to create dependent drop down boxes in a separate inventory sheet, so that when someone selects a SIZE, the NAME of the beers available with that size are available.
This list must be dynamic, as we are always adding and removing products.
**I was able to figure out the sorting using formula's, and multiple copy & past iterations previously, but I accidentally crashed that sheet, and lost all data. One of the main issues I was having, was that the processing is taking so much time, upwards of 20+ seconds, if not crashing all together.
I'm trying to attach a few screenshots of what I would like to happen, but it says i cannot. Let me know how I can clarify. Any help at all is greatly appreciated.
Thank you,
-Nost
I'm trying to sort individual columns, removing duplicates (keeping 1 original), and then sorting those columns alphabetically.
I currently have a code that copies a list of all of our beer names to column B:Y, and respective sizes to column A. (pasted values only)
I would like to delete cells column by column, if the cells in column A (Target Row) match specific text ("1/6 BBL", "1/2 BBL", etc..) OR match the column header if that works as well.
I would then like to eliminate all duplicates in each column so that only 1 name of each applicable type remains.
I plan to do all of this to create dependent drop down boxes in a separate inventory sheet, so that when someone selects a SIZE, the NAME of the beers available with that size are available.
This list must be dynamic, as we are always adding and removing products.
**I was able to figure out the sorting using formula's, and multiple copy & past iterations previously, but I accidentally crashed that sheet, and lost all data. One of the main issues I was having, was that the processing is taking so much time, upwards of 20+ seconds, if not crashing all together.
I'm trying to attach a few screenshots of what I would like to happen, but it says i cannot. Let me know how I can clarify. Any help at all is greatly appreciated.
Thank you,
-Nost
