Hi,
I have a worksheet (B) form that tracks specific people horizontally and
specific categories vertically:

Mary Joe Jim Frank
Sales
Calls
Results

The results are already compiled on a separate worksheet (A) but in reverse
format (people vertically, categories horizontally) . Ive linked the two
worksheets but cant figure out how to make the formula automatically
count/link in the correct order when I c&p it.

If you can think of a better way to tackle this problem, Im open to
suggestions. The format of Worksheet B cant be changed and there are 200+
people and 16 categories €“ a nightmare to do by hand.

Thanks!