With Find/Replace, the amount of work for you to replace 3 sets of values
should be the same whether it's 8 cells or 80,000 cells. If you're talking
about the number of different combinations of values you need to replace,
then yes it takes a lot of work to do Find/Replace for each of many different
values.

I'm guessing it's the latter case where you have a long list of unique
primary key values that you need to replace with 1, 2, 3,... all the way to
the number of unique values you have.

What you can do is make a list of unique values on a separate sheet, and put
the corresponding 1, 2, 3 values in the next column. Then on each of your 14
sheets, insert a column and use VLOOKUP to get the corresponding 1, 2, 3
values and copy formula down.

You'll have to do this 14 times, but better than doing 100+ times of
Find/Replace (assuming you have about 100 unique primary key values or more).

-Simon

"Emoshag" wrote:


Yes, you missed the part that there are a tad over 80,000 cells than
need to be replaced and I am working with about 3 days to do this. :)


I have done that before when the data was smaller and less
convoluted.... but this is just a giant mess of values and tables.

I remember reading in a book I have lying around somewhere that there
was a way to do this via a script.... but I can't find the book now. I
think I lent it to a co-worker....


--
Emoshag
------------------------------------------------------------------------
Emoshag's Profile: http://www.excelforum.com/member.php...o&userid=22190
View this thread: http://www.excelforum.com/showthread...hreadid=558894