A
Arlen
Hello, All! Happy weekend.
I must tally counts and sums for a year's worth of business archived as 52
workbooks that each tell one week's tale. Sounds simple, but problems abound.
Problem: The dates in the archives are not dates at all...somebody simply
typed in Sun 1/05/07, and sometimes Thur. 1/09/2007. In the same column,
there are entries like "Dr. Dale/Ernst", so the one unique characteristic of
all 'date' cells is that they have a yellow background.
Question: How do you write a macro that searches B4:B100 for yellow cells,
then converts the text inside to a real date with the ddd mm/dd/yy format?
I sure do appreciate ye.
Arlen
I must tally counts and sums for a year's worth of business archived as 52
workbooks that each tell one week's tale. Sounds simple, but problems abound.
Problem: The dates in the archives are not dates at all...somebody simply
typed in Sun 1/05/07, and sometimes Thur. 1/09/2007. In the same column,
there are entries like "Dr. Dale/Ernst", so the one unique characteristic of
all 'date' cells is that they have a yellow background.
Question: How do you write a macro that searches B4:B100 for yellow cells,
then converts the text inside to a real date with the ddd mm/dd/yy format?
I sure do appreciate ye.
Arlen