software

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,quot;24,de,sc,FAST TRACKquot;)

I have to do this on 3,000 times on 15 different tabs and the only part that
needs to change is the quot;dequot;. Next it will be quot;dcquot; then quot;dwquot; 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
On Thu, 22 Dec 2005 07:45:02 -0800, quot;Davinquot; gt;
wrote:

gt;I created concatenated fields of multipe other fields and then counts them
gt;based on what is in the concatenated fields.
gt;
gt;=COUNTIF('Master Recruit'!AC:AC,quot;24,de,sc,FAST TRACKquot;)
gt;
gt;I have to do this on 3,000 times on 15 different tabs and the only part that
gt;needs to change is the quot;dequot;. Next it will be quot;dcquot; then quot;dwquot; etc...
gt;
gt;Is there a way I can just find and replace for each tab?
gt;
gt;I don't want to spend my Holidy going, F2...backarrow...delete...delete...
gt;
gt;Help me Obi-Wan, you're my only hope...
gt;
gt;Thanks
gt;

What do you mean by a quot;tabquot;? Is that an abbreviation for table, or do you mean
a separate worksheet?

In any event, you could put your list of quot;d'squot; 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,quot;24,quot; amp; cell_ref amp; quot;,sc,FAST TRACKquot;)

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

They are tabs and each tab is for a different set (like quot;dequot; and quot;dcquot; and
quot;dwquot;). Otherwise the formulas for each tab will be exactly the same.
So the formulas for each tab will be exactly the same except that I have to
change those two little characters.quot;Ron Rosenfeldquot; wrote:

gt; On Thu, 22 Dec 2005 07:45:02 -0800, quot;Davinquot; gt;
gt; wrote:
gt;
gt; gt;I created concatenated fields of multipe other fields and then counts them
gt; gt;based on what is in the concatenated fields.
gt; gt;
gt; gt;=COUNTIF('Master Recruit'!AC:AC,quot;24,de,sc,FAST TRACKquot;)
gt; gt;
gt; gt;I have to do this on 3,000 times on 15 different tabs and the only part that
gt; gt;needs to change is the quot;dequot;. Next it will be quot;dcquot; then quot;dwquot; etc...
gt; gt;
gt; gt;Is there a way I can just find and replace for each tab?
gt; gt;
gt; gt;I don't want to spend my Holidy going, F2...backarrow...delete...delete...
gt; gt;
gt; gt;Help me Obi-Wan, you're my only hope...
gt; gt;
gt; gt;Thanks
gt; gt;
gt;
gt; What do you mean by a quot;tabquot;? Is that an abbreviation for table, or do you mean
gt; a separate worksheet?
gt;
gt; In any event, you could put your list of quot;d'squot; in a column of cells (or in an
gt; individual cell if by tabs you mean a worksheet), and rewrite your formula:
gt;
gt; =COUNTIF('Master Recruit'!AC:AC,quot;24,quot; amp; cell_ref amp; quot;,sc,FAST TRACKquot;)
gt;
gt; where cell_ref contains de or dc or dw or ...
gt;
gt;
gt; --ron
gt;

On Thu, 22 Dec 2005 08:21:01 -0800, quot;Davinquot; gt;
wrote:

gt;They are tabs and each tab is for a different set (like quot;dequot; and quot;dcquot; and
gt;quot;dwquot;). Otherwise the formulas for each tab will be exactly the same.
gt;So the formulas for each tab will be exactly the same except that I have to
gt;change those two little characters.

The only definition for quot;tabquot; that I can find that is specific to Excel (USA)
is a reference to the label for a worksheet. Since the only data in that
location is the name of the worksheet, I presumed you meant something else,
although I'm still not sure what.

In any event, you should be able to adapt the solution I posted to your
problem. Let me know how it works.--ron

Sorry Ron,

I should have clarified:

I have a workbook containing multiple worksheets, one for each set of
two-letter characters (de, dc, dw...) that are counting from a quot;masterquot;
worksheet. The problem is that in the field that it is counting there are a
number of different variables, including one that specifies a date. Otherwise
I could just do a find and replace.
Each worksheet has the exact same format and formulas except the
two-character code.

I have resigned myself to manually changing each individual field at this
point as all of my attempts at automating the process have failed.

Thanks for your help, if you think of anything I would love to know about it.

Happy Holidays!
quot;Ron Rosenfeldquot; wrote:

gt; On Thu, 22 Dec 2005 08:21:01 -0800, quot;Davinquot; gt;
gt; wrote:
gt;
gt; gt;They are tabs and each tab is for a different set (like quot;dequot; and quot;dcquot; and
gt; gt;quot;dwquot;). Otherwise the formulas for each tab will be exactly the same.
gt; gt;So the formulas for each tab will be exactly the same except that I have to
gt; gt;change those two little characters.
gt;
gt; The only definition for quot;tabquot; that I can find that is specific to Excel (USA)
gt; is a reference to the label for a worksheet. Since the only data in that
gt; location is the name of the worksheet, I presumed you meant something else,
gt; although I'm still not sure what.
gt;
gt; In any event, you should be able to adapt the solution I posted to your
gt; problem. Let me know how it works.
gt;
gt;
gt; --ron
gt;

On Thu, 22 Dec 2005 10:05:02 -0800, quot;Davinquot; gt;
wrote:

gt;Sorry Ron,
gt;
gt;I should have clarified:
gt;
gt;I have a workbook containing multiple worksheets, one for each set of
gt;two-letter characters (de, dc, dw...) that are counting from a quot;masterquot;
gt;worksheet. The problem is that in the field that it is counting there are a
gt;number of different variables, including one that specifies a date. Otherwise
gt;I could just do a find and replace.
gt;Each worksheet has the exact same format and formulas except the
gt;two-character code.
gt;
gt;I have resigned myself to manually changing each individual field at this
gt;point as all of my attempts at automating the process have failed.
gt;
gt;Thanks for your help, if you think of anything I would love to know about it.
gt;
gt;Happy Holidays!

OK, now I understand what you mean by quot;tabsquot;.

I'm still not sure exactly what you are doing, though.

Does all the data get entered into 'Master Recruit'!AC:AC with the COUNTIF
formula on the individual worksheets?

If so, and if, for example you had the appropriate two-letter code on each
worksheet -- let us say in cell A1, then you should be able to use the formula
I posted in my initial response.

=COUNTIF('Master Recruit'!AC:AC,quot;24,quot; amp; cell_ref amp; quot;,sc,FAST TRACKquot;)

substituting A1 for cell_ref.

Just use this formula on each worksheet and it should pull out of A1 the
appropriate d.. reference.--ron

Wonderful!!!

You made me a happy boy this holiday season.

I should've fully tried your initial idea. That worked like a charm.

You're the best, Thanks a ton!quot;Ron Rosenfeldquot; wrote:

gt; On Thu, 22 Dec 2005 10:05:02 -0800, quot;Davinquot; gt;
gt; wrote:
gt;
gt; gt;Sorry Ron,
gt; gt;
gt; gt;I should have clarified:
gt; gt;
gt; gt;I have a workbook containing multiple worksheets, one for each set of
gt; gt;two-letter characters (de, dc, dw...) that are counting from a quot;masterquot;
gt; gt;worksheet. The problem is that in the field that it is counting there are a
gt; gt;number of different variables, including one that specifies a date. Otherwise
gt; gt;I could just do a find and replace.
gt; gt;Each worksheet has the exact same format and formulas except the
gt; gt;two-character code.
gt; gt;
gt; gt;I have resigned myself to manually changing each individual field at this
gt; gt;point as all of my attempts at automating the process have failed.
gt; gt;
gt; gt;Thanks for your help, if you think of anything I would love to know about it.
gt; gt;
gt; gt;Happy Holidays!
gt;
gt; OK, now I understand what you mean by quot;tabsquot;.
gt;
gt; I'm still not sure exactly what you are doing, though.
gt;
gt; Does all the data get entered into 'Master Recruit'!AC:AC with the COUNTIF
gt; formula on the individual worksheets?
gt;
gt; If so, and if, for example you had the appropriate two-letter code on each
gt; worksheet -- let us say in cell A1, then you should be able to use the formula
gt; I posted in my initial response.
gt;
gt; =COUNTIF('Master Recruit'!AC:AC,quot;24,quot; amp; cell_ref amp; quot;,sc,FAST TRACKquot;)
gt;
gt; substituting A1 for cell_ref.
gt;
gt; Just use this formula on each worksheet and it should pull out of A1 the
gt; appropriate d.. reference.
gt;
gt;
gt; --ron
gt;

Glad it worked! Thanks for the feedback. And I hope you enjoy the rest of the
holiday, too.
On Thu, 22 Dec 2005 11:46:02 -0800, quot;Davinquot; gt;
wrote:

gt;Wonderful!!!
gt;
gt;You made me a happy boy this holiday season.
gt;
gt;I should've fully tried your initial idea. That worked like a charm.
gt;
gt;You're the best, Thanks a ton!
gt;
gt;
gt;quot;Ron Rosenfeldquot; wrote:
gt;
gt;gt; On Thu, 22 Dec 2005 10:05:02 -0800, quot;Davinquot; gt;
gt;gt; wrote:
gt;gt;
gt;gt; gt;Sorry Ron,
gt;gt; gt;
gt;gt; gt;I should have clarified:
gt;gt; gt;
gt;gt; gt;I have a workbook containing multiple worksheets, one for each set of
gt;gt; gt;two-letter characters (de, dc, dw...) that are counting from a quot;masterquot;
gt;gt; gt;worksheet. The problem is that in the field that it is counting there are a
gt;gt; gt;number of different variables, including one that specifies a date. Otherwise
gt;gt; gt;I could just do a find and replace.
gt;gt; gt;Each worksheet has the exact same format and formulas except the
gt;gt; gt;two-character code.
gt;gt; gt;
gt;gt; gt;I have resigned myself to manually changing each individual field at this
gt;gt; gt;point as all of my attempts at automating the process have failed.
gt;gt; gt;
gt;gt; gt;Thanks for your help, if you think of anything I would love to know about it.
gt;gt; gt;
gt;gt; gt;Happy Holidays!
gt;gt;
gt;gt; OK, now I understand what you mean by quot;tabsquot;.
gt;gt;
gt;gt; I'm still not sure exactly what you are doing, though.
gt;gt;
gt;gt; Does all the data get entered into 'Master Recruit'!AC:AC with the COUNTIF
gt;gt; formula on the individual worksheets?
gt;gt;
gt;gt; If so, and if, for example you had the appropriate two-letter code on each
gt;gt; worksheet -- let us say in cell A1, then you should be able to use the formula
gt;gt; I posted in my initial response.
gt;gt;
gt;gt; =COUNTIF('Master Recruit'!AC:AC,quot;24,quot; amp; cell_ref amp; quot;,sc,FAST TRACKquot;)
gt;gt;
gt;gt; substituting A1 for cell_ref.
gt;gt;
gt;gt; Just use this formula on each worksheet and it should pull out of A1 the
gt;gt; appropriate d.. reference.
gt;gt;
gt;gt;
gt;gt; --ron
gt;gt;

--ron