VBA - How to check for certain string in cell and paste into other between sheets

[UsmanBPD]

is it possible to do this:

Stock number is in Column A , Listing Title is in Column D. Template is in same excel file in a new sheet.

Attachment 160960

This is a picture of the Stock number (column A) and product-name (column D)

Attachment 160961

This is the template that will be on a new sheet (First sheet will be called "Seller Central Category" and the second sheet will be called "Sheet1"), this contains all of the colours to be filled.

Attachment 160963

This is the end result, before and after.

Each spreadsheet this macro will be used on can have upto 8 sizes, this is the reason for blank lines in the following picture. (for example sizes 2-9 would work in the macro).

Attachment 160966

This is the example of the kind of data we will be working on.

So to recap..

1. Macro switches to the second sheet which will be named "Sheet1"
2. Macro then takes the colour from cell B2 and adds it to the end of the contents of cells in sheet 1 : column d, for 12 sizes (if blank it will just leave blank)
3. It then gets the size from the end of stock number
4. adds to end of the colour that was just added in column D

Here is some sample data
Attachment 160967


Also, how do we learn more about VBA programming? Are there any good resources you can recommend for learning?[

[MarvinP]

See if this helps with how to learn more about VBA.
http://www.excelforum.com/excel-prog...-in-class.html