Hello,
I need to create a sheet that that will have a general tab for entry, but it would then sort and send an entire
row of data to another tab based on the information of one cell. I realize that it is close to a vlookup, but don't know how to make a vlookup to apply to the entire row (not the entire row, maybe 5 cells out of the row).
<tbody>
</tbody>
I hope this makes sense, first time using this board. Thank you in advance!!!
Allen Worral
I need to create a sheet that that will have a general tab for entry, but it would then sort and send an entire
row of data to another tab based on the information of one cell. I realize that it is close to a vlookup, but don't know how to make a vlookup to apply to the entire row (not the entire row, maybe 5 cells out of the row).
Example | 1 | 2 | 3 | |||||||||||
Account | $ | Stage | Account | $ | Stage | Account | $ | Stage | Account | $ | Stage | |||
Smith | $100 | 1 | Smith | $100 | 1 | Jones | $200 | 2 | Kelley | $ | 3 | |||
Jones | $200 | 2 | ||||||||||||
Kelley | $150 | 3 | ||||||||||||
<tbody>
</tbody>
I hope this makes sense, first time using this board. Thank you in advance!!!
Allen Worral