|Sorry, here's the data in sheet Master.|
Name Pipeline Rank Annual Monthly Rep
Acme Corp PROSPECT A $12,000 $1,000 NC
Smith Corp MAP B $8,000 $667 NC
Jones Inc. PROSPECT B $20,000 $1,667 NC
I would like to see it grouped into the following sheet Summary.
Prospect Rank Annual Monthly Rep Map Rank Annual Monthly Rep
Acme Corp A $12,000 $1,000 NC Smith Corp B $8,000 $667 NC
Jones Inc. B $20,000 $1,667 NC
The reason is so that as the Name changes from Prospect to Map it will automatically move all the data with it. Thanks for any help.