R

#### Rob

trying to do. In Excel 2003 I have four worksheets;

Worksheet 1 has unique values in Col "A" that I want to count in Worksheet 1

Col "D" where they match Worksheet 2 Col "A"

Worksheet 2 has values in Col "C" that I want to count in Worksheet 3 Col

"B" and place the total in Worksheet 1 Col "E" as they relate to Worksheet 1

Col "A" Through Worksheet 2 --- then I'd like to List the individual results

in Worksheet 2 Col "F" as well.

Worksheet 3 Col "A" has values that I want to count from worksheet 4 Col "A"

and place the total in Worksheet 1 Col "F" as they relate to Worksheet 3 Col

"B" & Worksheet 2 Col "C" and back to Worksheet 1 Col "A".

Now that I have confused everyone, I have detailed it in a layout below to

hopefully explain it better than what I could do in words.

Worksheet1

........A..........B.......C........D...........E............F

1.....23a.....???......Y......WS2#....WS3#....WS4#

2.....23b.....???......Y......WS2#....WS3#....WS4#

3.....23c.....???......Y......WS2#....WS3#....WS4#

4.....23d.....???......n.........-...........-.............-

5.....23e.....???......Y......WS2#....WS3#....WS4#

6.....23f.....???......n..........-...........-.............-

7.....23g.....???......Y......WS2#....WS3#....WS4#

Worksheet2

........A.........B........C.........D........E.......F

1.....23a.....???.....ABC......???.....???.....???

2.....23a.....???.....WER.....???.....???.....???

3.....23a.....???.....XYZ......???.....???.....???

4.....23b.....???.....SDF......???.....???.....???

5.....23b.....???.....JKL.......???.....???.....???

6.....23c.....???.....ASD......???.....???.....???

7.....23e.....???.....LMN......???.....???.....???

Worksheet3

........A..........B.........C........D........E........F

1.....234.....WER.....???.....???.....???.....???

2.....798.....WER.....???.....???.....???.....???

3.....008.....JKL.......???.....???.....???.....???

4.....123.....JKL.......???.....???.....???.....???

5.....798.....JKL.......???.....???.....???.....???

6.....654.....ABC......???.....???.....???.....???

7.....888.....XYZ......???.....???.....???.....???

Worksheet4

........A.........B........C.......D........E........F

1.....234.....???.....???.....???.....???.....???

2.....234.....???.....???.....???.....???.....???

3.....234.....???.....???.....???.....???.....???

4.....234.....???.....???.....???.....???.....???

5.....234.....???.....???.....???.....???.....???

6.....234.....???.....???.....???.....???.....???

7.....234.....???.....???.....???.....???.....???

Worksheet1 Results

........A.........B........C.......D........E.........F

1.....23a.....???......Y......003.....004.....007

2.....23b.....???......Y......002.....002.....000

3.....23c.....???......Y......001.....000.....000

4.....23d.....???......n.........-.........-..........-

5.....23e.....???......Y......001....WS3#.....WS4#

6.....23f.....???......n.........-.........-..........-

7.....23g.....???......Y......WS2#....WS3#....WS4#

Worksheet2 Results

........A..........B........C........D........E........F

1.....23a.....???.....ABC......???.....???.....654

2.....23a.....???.....WER.....???.....???.....234, 798

3.....23a.....???.....XYZ......???.....???.....888

4.....23b.....???.....SDF......???.....???.....???

5.....23b.....???.....JKL.......???.....???.....008, 123, 798

6.....23c.....???.....ASD......???.....???.....???

7.....23e.....???.....LMN.....???.....???.....???

I hope I have provided enough info to get the help I am wishing for.

Thanks in Advance and for your Patience,

Rob