Hi,

Having a little trouble.

I need to be able to select records in a sheet based on the same criteria in
one column.

I then need to look at all the values for the selected records in other
colums, and if a particular value exists I need to change all the cells in
that colum to that value.

Example:

1.) Select all records that have record ID of "1" in column A and show only
those records.

2.) In columns B (and C-F), if an "X" appears in any of the column cells,
then change all of these cells to a "X".

3.) repeat process for record Id's of 2 through 100 in Column A.

Seems simple, but I cannot figure it out.

Any ideas?

Thanks much,

Mark