I have a worksheet where I must insert a column every time the user selects 2 values (found in Pricelists sheet).
So Basically whenever a user chooses the Quote LP, or the Sell on web Values from the cell dropdown, I must insert a column adjacent to the value. (The dropdown values are referred from another worksheet in the same workbook)
So for example if a user selects cell A1 and selects Sell on web from the dropdown, a column must appear between A and B. The column must read "List Price", in cell B1.
If the new list price column can have a "collapse" button in cell H5 that will cause the column to hide, that would be amazing as well.
Thank you and I apprecaite any and all the help!!
So Basically whenever a user chooses the Quote LP, or the Sell on web Values from the cell dropdown, I must insert a column adjacent to the value. (The dropdown values are referred from another worksheet in the same workbook)
So for example if a user selects cell A1 and selects Sell on web from the dropdown, a column must appear between A and B. The column must read "List Price", in cell B1.
If the new list price column can have a "collapse" button in cell H5 that will cause the column to hide, that would be amazing as well.
Thank you and I apprecaite any and all the help!!
