G
gone
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.
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.