For the next few days I will be compiling a very large database (four sheets) on Microsoft Office Excel 2003 (Windows 2000 Office). Three of the sheets are pretty much complete but I am having some issues with the last.

(1) I have headings on both the rows and columns; some rows (Companies) do not have any values as there was no action in these accounts last year. All columns (Deals) have some sort of dollar figure as you scroll down. What I want to do is: to be able to see any criteria either row or column and see where there are active cells relating to that field and have the corresponding label with that data compiled into one place so that when you look up a field it automatically states what criteria fits under it

For example

say ABC company bought three deals this year Deal 1, Deal 2, Deal 3

and also that In Deal 1, not only ABC but CDE and EFG and GHI also participated in the deal.

because I have about 700 companies and 250 deals there is a lot of empty space between all the data its hard to have and overal picture of one company or one deal

So i would like to have something like this


Deal 1 ABC 1000 CDE 476544 EFG 365432 GHI 642357
Deal 2 CDE 2355 FGS 245786 ABC 654321 ADF 735433
Deal 3 EFG 8567 SGF 134754 OEJ 684325 ABC 732515
Deal 4 GHI 4576 SDG 245745 JAO 732183 ASD 7325485

AND ALSO


ABC Deal 1 2345 Deal 2 3456 Deal 34 35685 Deal 9 354684
CDE Deal 3 6534 Deal 7 7653 Deal 43 76567 Deal 8 65468
EFG Deal 4 238654 Deal 8 6547 Deal 245 7678 Deal 4 964653
GHI Deal 6 3473546 Deal 9 8769 Deal 234 8467 Deal 5 46446
HJK Deal 8 34563 Deal 24 98567 Deal 34 24365 Deal 7 568764

Please let me know if you can help me out. Thank you very much for your time and attention and hopefully I will hear from someone sometime in the near future.