Calculating and copying data into new sheet

[scottwilsonx]

Hi, by change (or report) I meant that I might only want to report on a
particular string or date and would like the macro to only look at
those rows where the value was, eg: "New York".

Thanks for your help and time, much appreciated.

 

[Bernie Deitrick]

Scott,

In code, you would change the

If CLng(myCell(1, 2).Value) = CLng(DateValue("12/1/2003")) Then

to

If myCell(1, 5).Value = "New York" Then

Otherwise, for more flexibility, try autofilter. That will just hide the
values you don't want to see, and show those that you do....

HTH,
Bernie
MS Excel MVP