On Thu, 22 Dec 2005 07:45:02 -0800, "Davin"
wrote:

I created concatenated fields of multipe other fields and then counts them
based on what is in the concatenated fields.

=COUNTIF('Master Recruit'!AC:AC,"24,de,sc,FAST TRACK")

I have to do this on 3,000 times on 15 different tabs and the only part that
needs to change is the "de". Next it will be "dc" then "dw" etc...

Is there a way I can just find and replace for each tab?

I don't want to spend my Holidy going, F2...backarrow...delete...delete...

Help me Obi-Wan, you're my only hope...

Thanks


What do you mean by a "tab"? Is that an abbreviation for table, or do you mean
a separate worksheet?

In any event, you could put your list of "d's" in a column of cells (or in an
individual cell if by tabs you mean a worksheet), and rewrite your formula:

=COUNTIF('Master Recruit'!AC:AC,"24," & cell_ref & ",sc,FAST TRACK")

where cell_ref contains de or dc or dw or ...


--ron