Gang - The following is a sample from a worksheet. The following
snippet is repeated for each of 88 counties, giving me a 900-record
matrix. I'm trying to verify the statewide totals (by summing across
counties) and I've reached the conclusion that I'm limited with options
because "Permits Issued" is found twice in each county. I need to find
a way to selectively change one of the Permits Issued values (or create
something new). The only thing that is unique is the text above it
(In-Season Permits in the first case and Out-of-Season Permits in the
2nd).

Something like the following is needed - but can it be done?

If text="Permits Issued" and previous text = "In-Season Permits" then
NewText=INSPI

else if text="Permits Issued" and previous text = "Out-of-Season
Permits" then NewText=OUTSPI,

else NewText=OldText

endif


In-Season Permits
Permits Issued 88
Deer Harvested 230
Out-of-Season Permits
Permits Issued 4
Deer Killed 26
Complaints


Any help at all on this would be very much appreciated.

Regards,

Mike