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