P/N and Description Generation

**IMPAK** · 05-29-2013, 01:03 PM

Hi All,

I am looking to develop a excel file that will assist in creating standardized product descriptions. Ideally the form would allow both drop down selection and a manual entry for each of the following items:

Dimensions
Material
Color
Classification
Feature1
Feature2
Feature3
Feature4
Qty

Once the information has been entered, I would like for the user to be able to click a button or some other function and have the description be auto generated in a format similar to:

(Dimensions);(Material);(Color);(Classification)
(Feature1);(Feature2);(Feature3);(Feature4);(Qty)

I have other similar projects I am working on, so a format that is easily adjustable would be ideal.

Thanks in advance for the help.

IMPAK

**FDibbins** · 05-29-2013, 01:07 PM

Hi and welcome to the forum

I would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

**Harribone** · 05-29-2013, 01:13 PM

So let's say a user enters the values A B C and D for each of these - (Dimensions);(Material);(Color);(Classification). You want another cell to output A;B;C;D ?
If so then its just a case of typing =B1&";"&B2&";"&B3&";"&B4 which will join the values together.

As for a drop down selection you can create a list in excel with each option you want to be able to choose. Then select the cell which will have the drop down list and click on Data Validation. Choose limit to list and set it to the range which contains your values (=A1:A10 for example). You can check 'limit to list' so that the user can only choose/type values contained within that range if so required.

Does that help with your needs?

**IMPAK** · 05-29-2013, 02:42 PM

I believe the file is attached.

I appreciate anyone who is able to build the functions into the file and attached it. I should be capable of follow basic instructions and functions.

Cheers

BDK

**IMPAK** · 05-29-2013, 03:32 PM

Originally Posted by Harribone

So let's say a user enters the values A B C and D for each of these - (Dimensions);(Material);(Color);(Classification). You want another cell to output A;B;C;D ?
If so then its just a case of typing =B1&";"&B2&";"&B3&";"&B4 which will join the values together.

As for a drop down selection you can create a list in excel with each option you want to be able to choose. Then select the cell which will have the drop down list and click on Data Validation. Choose limit to list and set it to the range which contains your values (=A1:A10 for example). You can check 'limit to list' so that the user can only choose/type values contained within that range if so required.

Does that help with your needs?

Thanks for the help! The first part was a success, but I believe the drop down menu is beyond me. I am going to revisit it tomorrow and see what i can come up with.