[RESOLVED] [EXCEL] using VBA copy one field from a column and concatenate with transpose

[unknowninator]

Hi All,

I am fairly new to VBA and I needed some help.

There is a data Set with one column as id and has different nos.

then, I have a row, with different names.

Now, I want to copy these ids first, into a new sheet and then copy the names one by one into the new sheet and concatenate the id + name together.

For e.g.

Id yellow blue orange
1 25 74 56
2 34 64 46
3 45 49 99
4 12 45 11
5 10 16 22
6 20 13 13
7 48 19 14

the columns are not consecutive as well.

What I want to do is:-

1yellow - 25
2yellow - 34
3yellow - 45
4yellow - 12
.
.
.

1blue - 74
2blue - 64
3blue - 49
4blue - 45
5blue - 16
6blue - 13

likewise for orange.

This all needs to be done, from a separate file where I have a command button, I press the button and then the data is pulled from file 1 which has yellow, blue and orange data, and then pushed into a new file say test.xls

both files are closed and have separate sheets as well.

Please let me know or help me with the code.
I am good with C++ bt never really worked with VB, worked with VC++ nd other languages.

so, all, i need is, if someone can help me with the code.

Many thanks,
Unknown