Okay. I have a sheet that I created for other users. I want to be able to automate some of the entry for organizational and storting reasons.
Here is what my sheet looks like
Column A has the company name, Column B the Location and there are 4 blank dropdown cells in Column C for that Company.
In Column C, the user can select each product group from a dropdown for that company up to 4 different product groups. I don't want the user to have to type company B 3 more times, plus I would like it to fill like
Company A
Company AB
Company AC
Company AD
to keep the groups together. The trick is that Company A may be in the list for another reason, so it will need to stay with that group during a sort. I hope this makes sense...it is hard to explain.
Here is what my sheet looks like
Column A has the company name, Column B the Location and there are 4 blank dropdown cells in Column C for that Company.
In Column C, the user can select each product group from a dropdown for that company up to 4 different product groups. I don't want the user to have to type company B 3 more times, plus I would like it to fill like
Company A
Company AB
Company AC
Company AD
to keep the groups together. The trick is that Company A may be in the list for another reason, so it will need to stay with that group during a sort. I hope this makes sense...it is hard to explain.
