I need a program, preferably something I can password protect, that will automatically take everything in an Excel column, and then turn it into a table in Word that randomizes the entries in the Excel column.
For the Word table, variables for the table would have to include font size, number of columns in the Word table, etc. This way I could tell it, "Randomize the entries in column A in Excel file X, and send them into a full sized, landscape Word sheet with X number (10, or 5, or 3, etc.) columns using Y font at size Z."
Then I would like to include variables about which columns it randomizes. So if I have an Excel sheet with columns A, B, C, D, and E full of different numbers of entries, I can tell it to do the above with only A, with A and D, with B and C, with A, B, and E, etc. It would be great if I could enter a ratio (For each 3 in column A, throw in one from C and two from E.
There are more dimentions to this, but this is the first step I need. I am developing this for a research project for school, so I don't have a lot of money, but I would like to be able to protect it from having others just steal it.