Macro Help

Is it possible to create macro/VB that can generate something like the below example.

Input data:

NAME ID CODE NUM SOURCE
JEEY 3 HYX 11 B
JEEY 33 HYX 55 A
JEEY 43 HYX 1 B
FRAN 88 BTY 5 A
FRAN 78 BTY 88 B


Using Name,Code and the Source as the key - the report should look like this:
Desired result:

NAME ID CODE NUM SOURCE
JEEY 33 HYX 55 A
............................ JEEY 3 HYX 11 B
............................ JEEY 43 HYX 1 B
----- ----- ----- ----- ----- ----- -----
FRAN 88 BTY 5 A ...... FRAN 78 BTY 88 B

The actual result:
A - Left side
B - Right side

Thanks
Jimmy

Originally Posted by sanjimmy

Is it possible to create macro/VB that can generate something like the below example.

Input data:

NAME ID CODE NUM SOURCE
JEEY 3 HYX 11 B
JEEY 33 HYX 55 A
JEEY 43 HYX 1 B
FRAN 88 BTY 5 A
FRAN 78 BTY 88 B


Using Name,Code and the Source as the key - the report should look like this:
Desired result:

NAME ID CODE NUM SOURCE
JEEY 33 HYX 55 A
............................ JEEY 3 HYX 11 B
............................ JEEY 43 HYX 1 B
----- ----- ----- ----- ----- ----- -----
FRAN 88 BTY 5 A ...... FRAN 78 BTY 88 B

The actual result:
A - Left side
B - Right side

Thanks
Jimmy

So, you want to list source A items on the left, source items B on the right, << just read the rest of your post, you said that.
is there a source other than A/B ?
Is the list pre-sorted ?
what is the required sort sequence if not pre-sorted ?
Incrementing ID or decreasing Num ?
---

perhaps the question should have been:
if FRAN 88 BTY 5 A ...... FRAN 78 BTY 88 B
ie, Fran BTY A & B
fit on a row, why doesn't
JEEY 33 HYX 55 A
............................ JEEY 3 HYX 11 B
ie, JEEY HYX A & B
?

Originally Posted by sanjimmy

Bryan,
Here is what I would like to see in my result.

In my input data:
If the Code and Name matches by source ( A and B) then would like to
list the records from source A on the left side (ex. column A1 B1 C1 D1 E5) and Source B (ex. column F1 G1 H1 I1 K1) on the Right side.

Another words, I would like to move all the record's from the Source B on the right side of the spreadsheet ..underneath the corresponding Source A record.

Let me know if this NOT clear yet.

Thanks.

Jimmy

That is a re-statement of what you want, but does not answer my question, which was:

if FRAN 88 BTY 5 A ...... FRAN 78 BTY 88 B
ie, Fran BTY A & B
fit on a row, why doesn't
JEEY 33 HYX 55 A
............................ JEEY 3 HYX 11 B
ie, JEEY HYX A & B

Try the attached (version 2). (run Macro4)

---