I have two more questions:

I have multiple worksheets in my workbook, all of which I want the max
date of Sheet1. Is there a way to evaluate the date on Sheet2 using
the range from Sheet1 without copying and pasting?

I also have a second file that I would like to put these dates in
based on the first file, is there a way to use the range from one file
and put the output in another?

Am I just better off copying and pasting once the original calculation
is made?

Thanks for any suggestions.
Stacy


(Stacy) wrote in message om...
Works PERFECTLY!
Thanks so much!

Stacy

"J.E. McGimpsey" wrote in message ...
One way:

Dim rng1 As Range
Set rng1 = Range("J1:K7")
Range("A1").Value = Evaluate("MAX((" & rng1.Columns(1).Address _
& "=""FR"")*(" & rng1.Columns(2).Address & "))")
Range("A2").Value = Evaluate("MAX((" & rng1.Columns(1).Address _
& "=""MA"")*(" & rng1.Columns(2).Address & "))")

Adjust rng1 to suit your table.

In article ,
(Stacy) wrote:

I have 2 columns, one is a version one is the date:
Based on the version, I want to find the max date.

Version Date
- - - - - - -
MA 10/01/03
IH 10/07/03
FR 09/05/03
MA 10/08/03
FR 10/07/03

So I want to be able to get the Max Date for FR - 10/07/03 and put it
in cell A1 and get the max Date for MA - 10/08/03 and put it in cell
A2.