Hi,
I would like assistance to write a macro which creates a page center to read
from column data. I would like for example the text string to read "Wasuto
updates for Supervisor ?? data date ??. Wasuto would be placed if column 4
has "WAS" in the 12 character text (example:45WAS51302U35) or if "KEM" is
there instead I'd like the word "Kematsa" instead. Also I'd like the
Supervisor's name if column 5 lists his name greater than 50% of the time.
There could be up to 25 different Supervisors names. Lastly I'd like the
current date behind the word date in the string. I'm using excel 2003. There
could be up to 5000 rows of data. The firts row is the header row.
Any help would be greatly appreciated.
--
By persisting in your path, though you forfeit the little, you gain the
great.