Closed

Add functionality to Excel Macro

This project received 14 bids from talented freelancers with an average bid price of $341 NZD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
N/A
Total Bids
14
Project Description

Hi,

I have a macro that is used to create a word game and I would like to add some more fuctionality to it.

At the moment I enter the clue words and answers, into the work sheet manually, what I would like to do is automate this by having the macro autofill the question and answers. from Excel's builtin thesaurus. To do this successfully the macro will need to

1).Randomly select a clue word from the thesaurus [url removed, login to view] enter it in the spreadsheet
2) Randomly select an answer from a clue words list of synonyms and enter it in the spreadsheet
3) Limit answers to LESS than thirteen characters
4) Exclude phrases. For example if "Verbose" was the clue word the synonym "Long winded" would be excluded as answer

SHUFFLE ANSWERS CHARACTER ORDER

The other functionality I would like added is the option to shuffle an answer's characters automatically by randomly breaking an answer in two and shuffling the pieces for example.

HEAVENLY

could be shuffled as any of the following

eavenlyh
avenlyhe
venlyhea
enlyheav
nlyheave
lyheaven
yheavenl

I look forward to your bids

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online