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>
<tbody>
</tbody><o></o>
<tbody>
</tbody><o></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></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>
File# | Start | End |
123 | 1/1/12 | 3/12/14 |
234 | 3/2/12 | 4/3/14 |
345 | 5/3/12 | 5/23/15 |
<tbody>
</tbody>
File#<o></o> | Text<o></o> | LName |
123<o></o> | Red<o></o> | Smith |
123 | Blue | Smith |
234<o></o> | Orange<o></o> | Jones |
234 | Green | Jones |
234 | Red | Jones |
345<o></o> | Yellow<o></o> | Johnson |
345 | Green | Johnson |
345 | Red | Johnson |
<tbody>
</tbody>
Last edited: