Calculating and copying data into new sheet
 

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.


--
scottwilsonx
------------------------------------------------------------------------
scottwilsonx's Profile: http://www.excelforum.com/member.php...o&userid=11128
View this thread: http://www.excelforum.com/showthread...hreadid=263823

Calculating and copying data into new sheet
 

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

"scottwilsonx" wrote in message
...

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.


--
scottwilsonx
------------------------------------------------------------------------
scottwilsonx's Profile:
http://www.excelforum.com/member.php...o&userid=11128
View this thread: http://www.excelforum.com/showthread...hreadid=263823