I am trying to use a spreadsheet that was downloaded from our manufacturing
software. Now I need to sort the data by our sales rep and create a
worksheet for each rep. My problem is when I do a VLOOKUP to find a sales
rep it gives me the first account number over and over as I copy the formula
down. How do I get it to give me the next account information?

(The seemingly easy solution is to sort by Sales Rep and copy/paste the info
into a new worksheet but the is just an example, our reps and account are
very extensive and that would take a long time and I am going to have to do
this on a regular basis.)

Sales Rep Acct # Accssry1 Accssry2 Accssry3
Bob 12345 568 625 682
Sue 12413 700 757 814
Bob 12481 832 889 946
Sue 12549 964 1021 1078
Bob 12617 1096 1153 1210
Sue 12685 1228 1285 1342