View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Davin
 
Posts: n/a
Default Formula help! Find and replace in formulas

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