Need a simple program that runs in excel which will perform
several find and replace operations.
Due to the enormous size of the files we are using, it is
necessary to use this method in order to expedite things.
The program needs to:
Run in a table cell in Excel
that contains text.
Find and Replace four keywords
of end users choosing.
Limit the times that a single
separate Main Keyword appears in
(limit to 1.5 percent of text,
assuming text is 200 words so
Go to each of the three examples
of the Main Keyword, place
a hyperlink in the first one
and bold the other two.
Should the Main Keyword appear
once,twice, or not at all:
Have a byline which uses
the Main Keyword to
complete a total of 1.5 percent
of the whole text.
In the byline the first keyword
example should be hyperlinked
and the last two should be
19 pekerja bebas membida secara purata $74 untuk pekerjaan ini
Master in Finance, the last 12 years I've been using Excel (VBA) to automate and make my job easier. Details or sample data will be required, probably short deliver day.
Samples are required to clear the SOW. I have extensive experience in Excel macros. Normally in a couple of hours it should be done but I put 2 days in my bid for testing and delivering a final ergonomic product.