[quote='Ron Rosenfeld[_2_];1603206']On Wed, 27 Jun 2012 15:00:07 +0000, ixara wrote:


dear Ron Rosenfeld..your codes works!...thank you very much..

Glad to help. Thanks for the feedback.[/QUOTE



*** IGNORE THIS - I FOUND A MUCH SIMPLER METHOD OF ACHIEVING WHAT I NEED THROUGH A SIMPLE VLOOKUP FORMULA - THANKS ANYWAY! ***




Hi

I have a requirement to do the same thing but with a slight twist! I tried to edit your code to make it work but am very new to this and am not having much success:

I have one workbook called "code" and the worksheets within it:

Output
Code
Data

In the Data sheet I have Column A as a part number "ARCP" in Column B I have the long description of what ARCP relates to "Anderson Premier" then in Column C I have the next part of the code (a colour option) "B" then Column D is the long colour description "B" and so on. The data sheet looks like this:

RANGE RESULT COLOUR RESULT SIZE RESULT
ARCP Anderson Pro B Black S Small

I have 6 different parts of the code in the Data sheet and then in the column immediately to the right of each code section is the long description


Then:

In the Code worksheet I have set up 6 columns for each of the 6 parts of the code (columns A to F) and a further 6 columns to the right of those for the long description (I to N)

What I would like to be able to do is type in a short code in columns A to F and the long description to automatically populate using the data worksheet as a reference point.

Finally: I would like to concatenate the 6 columns (A to F) into column A on the "output" worksheet and similarly rows I to N into Row B on the "output" worksheet in order to provide a customer friendly parts list with part code and description.

The last bit I guess is relatively straight forward but I am really struggling with how to get the code to reference what I have entered in the codes sheet with that of the data sheet and insert the result into the relevant columns of the codes sheet.

Any assistance you could provide would ba massively appreciated

Thanks in advance!