I must create a report from two worksheets. Can someone point me to a site with how-to’s?
<o
></o
>
Column A in both sheets is the File# and the only common piece of info.
Sheet1 has one row of data per file number.
Sheet2 has between 1 and 8 rows of data per file number.
How can I create a report to pull the data in Sheet1 and the associated File# text from Sheet2?
<o
></o
>
I tried combining all into one worksheet but VLookup only provides the first text cell per File#. Is there a way to combine all the Text data into one cell per File#?
<o
></o
>
[TABLE="class: MsoTableGrid"]
<tbody>[TR]
[TD]File#
[/TD]
[TD="width: 48, bgcolor: transparent"]Start
[/TD]
[TD="width: 54, bgcolor: transparent"]End
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]123
[/TD]
[TD="width: 48, bgcolor: transparent"]1/1/12
[/TD]
[TD="width: 54, bgcolor: transparent"]3/12/14
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]234
[/TD]
[TD="width: 48, bgcolor: transparent"]3/2/12
[/TD]
[TD="width: 54, bgcolor: transparent"]4/3/14
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]345
[/TD]
[TD="width: 48, bgcolor: transparent"]5/3/12
[/TD]
[TD="width: 54, bgcolor: transparent"]5/23/15
[/TD]
[/TR]
</tbody>[/TABLE]
<o
></o
>
[TABLE="class: MsoTableGrid"]
<tbody>[TR]
[TD]File#<o
></o
>
[/TD]
[TD="width: 54, bgcolor: transparent"]Text<o
></o
>
[/TD]
[TD="width: 54, bgcolor: transparent"]LName
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]123<o
></o
>
[/TD]
[TD="width: 54, bgcolor: transparent"]Red<o
></o
>
[/TD]
[TD="width: 54, bgcolor: transparent"]Smith
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]123
[/TD]
[TD="width: 54, bgcolor: transparent"]Blue
[/TD]
[TD="width: 54, bgcolor: transparent"]Smith
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]234<o
></o
>
[/TD]
[TD="width: 54, bgcolor: transparent"]Orange<o
></o
>
[/TD]
[TD="width: 54, bgcolor: transparent"]Jones
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]234
[/TD]
[TD="width: 54, bgcolor: transparent"]Green
[/TD]
[TD="width: 54, bgcolor: transparent"]Jones
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]234
[/TD]
[TD="width: 54, bgcolor: transparent"]Red
[/TD]
[TD="width: 54, bgcolor: transparent"]Jones
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]345<o
></o
>
[/TD]
[TD="width: 54, bgcolor: transparent"]Yellow<o
></o
>
[/TD]
[TD="width: 54, bgcolor: transparent"]Johnson
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]345
[/TD]
[TD="width: 54, bgcolor: transparent"]Green
[/TD]
[TD="width: 54, bgcolor: transparent"]Johnson
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]345
[/TD]
[TD="width: 54, bgcolor: transparent"]Red
[/TD]
[TD="width: 54, bgcolor: transparent"]Johnson
[/TD]
[/TR]
</tbody>[/TABLE]
<o
></o
>
<o


Column A in both sheets is the File# and the only common piece of info.
Sheet1 has one row of data per file number.
Sheet2 has between 1 and 8 rows of data per file number.
How can I create a report to pull the data in Sheet1 and the associated File# text from Sheet2?
<o


I tried combining all into one worksheet but VLookup only provides the first text cell per File#. Is there a way to combine all the Text data into one cell per File#?
<o


[TABLE="class: MsoTableGrid"]
<tbody>[TR]
[TD]File#
[/TD]
[TD="width: 48, bgcolor: transparent"]Start
[/TD]
[TD="width: 54, bgcolor: transparent"]End
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]123
[/TD]
[TD="width: 48, bgcolor: transparent"]1/1/12
[/TD]
[TD="width: 54, bgcolor: transparent"]3/12/14
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]234
[/TD]
[TD="width: 48, bgcolor: transparent"]3/2/12
[/TD]
[TD="width: 54, bgcolor: transparent"]4/3/14
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]345
[/TD]
[TD="width: 48, bgcolor: transparent"]5/3/12
[/TD]
[TD="width: 54, bgcolor: transparent"]5/23/15
[/TD]
[/TR]
</tbody>[/TABLE]
<o


[TABLE="class: MsoTableGrid"]
<tbody>[TR]
[TD]File#<o


[/TD]
[TD="width: 54, bgcolor: transparent"]Text<o


[/TD]
[TD="width: 54, bgcolor: transparent"]LName
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]123<o


[/TD]
[TD="width: 54, bgcolor: transparent"]Red<o


[/TD]
[TD="width: 54, bgcolor: transparent"]Smith
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]123
[/TD]
[TD="width: 54, bgcolor: transparent"]Blue
[/TD]
[TD="width: 54, bgcolor: transparent"]Smith
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]234<o


[/TD]
[TD="width: 54, bgcolor: transparent"]Orange<o


[/TD]
[TD="width: 54, bgcolor: transparent"]Jones
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]234
[/TD]
[TD="width: 54, bgcolor: transparent"]Green
[/TD]
[TD="width: 54, bgcolor: transparent"]Jones
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]234
[/TD]
[TD="width: 54, bgcolor: transparent"]Red
[/TD]
[TD="width: 54, bgcolor: transparent"]Jones
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]345<o


[/TD]
[TD="width: 54, bgcolor: transparent"]Yellow<o


[/TD]
[TD="width: 54, bgcolor: transparent"]Johnson
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]345
[/TD]
[TD="width: 54, bgcolor: transparent"]Green
[/TD]
[TD="width: 54, bgcolor: transparent"]Johnson
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"]345
[/TD]
[TD="width: 54, bgcolor: transparent"]Red
[/TD]
[TD="width: 54, bgcolor: transparent"]Johnson
[/TD]
[/TR]
</tbody>[/TABLE]
<o


Last edited: