Sort entire Rows to different tabs based on one cell of information.

aworral

New Member
Joined
Oct 18, 2017
Messages
1
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).
Example123
Account$StageAccount$StageAccount$StageAccount$Stage
Smith$1001Smith$1001Jones$2002Kelley$3
Jones$2002
Kelley$1503

<tbody>
</tbody>

I hope this makes sense, first time using this board. Thank you in advance!!!

Allen Worral
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Watch MrExcel Video

Forum statistics

Threads
1,099,536
Messages
5,469,266
Members
406,645
Latest member
jasondabsher

This Week's Hot Topics

Top