ironwood40
New Member
- Joined
- Sep 25, 2012
- Messages
- 7
Here is my question...I have a workbook that my sales reps use to input orders...we sell a variety of promotional products. What I need is when the sales rep is placing an order for apparel, on the cost sheet where they put all of their information, which then populates the estimate and P.O. tabs, I want to add a column before the count column that is titled “Apparel”. If they put a Y in any cell below that title, it will automatically take them to another worksheet in the workbook to input the following: item number, description, color, size and lastly quantity. When they are done inputting the info on that worksheet, they will go back to the cost worksheet and all the info has been sorted and counted but added as a text line under description, not on separate lines but as a summary by item number and color. As I mentioned, that info populates the estimate tab for the client and the P.O. tab for the vendor....
is this possible...I am a bit above novice excel user but programmer I am not...thanks for any help you all can give me...
is this possible...I am a bit above novice excel user but programmer I am not...thanks for any help you all can give me...