Hello all,
This is my first time posting to the forum, and I am also extremely new at working with VBA/Macros, so please bear with me. I'll try to explain this the best I can using the following example image:

Untitled-2.jpg

In the project I am working on, I need to use data from Books 1 and 2 to create book 3. The matching reference column between books 1 and 2 are the shapes. For every number/shape pair in Book 1, I need a pairing with its corresponding shape/letter pair in Book 2. Thus, because book 2 has 6 triangles lettered A-F, I need book 3 to have six 1's (from book 1) and all the corresponding triangle letters from book 2...and I need this done down a line that has several thousand rows.

I'm sorry if this makes little sense. I've been trying to wrap my mind around this for hours. I'd be happy to offer any clarification I can if this is confusing.