Use a helper sheet ..

Assuming source data in Sheet1, within A1:D20 (say)

In Sheet2,

Put in A1:
=IF(Sheet1!A1="","",IF(Sheet1!A1200,200,Sheet1!A1 ))
Copy A1 across to D1, fill down to D20
Then copy A1:D20, & paste and overwrite A1:D20 in Sheet1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Moshe Rosenberg" wrote:
I need to batch update all cell values in a sheet over the value of 200 to
become 200.

How can I accomplish this?