Hi all, I need to convert multiple choice questions into a rows in an excel file in a fixed format. .
The file currently looks like this: Column A 1. Question1 goes here a. Answer 1 b. Answer 2 *c. Answer 3 - the * indicates this is the correct answer d. Answer 4 2. Question2 goes here *a. Answer 1 b. Answer 2 c. Answer 3 d. Answer 4 I would like to use a macro to somehow convert these items (there are 50-70 on each worksheet and i have 14 worksheets) into this: A B C D E F G H I J MC Question1 Answer 1 Incorrect Answer 2 Incorrect Answer 3 Correct Answer 4 Incorrect MC Question2 Answer 1 Correct Answer 2 Incorrect Answer 3 Incorrect Answer 4 Incorrect Note the format adds "MC" to column A. other changes: - the questions are no longer numbered - the answers are not longer labeled with letter choices - the the column after each answer indicates if the answer is "Correct" or "Incorrect" - the * is removed from the correct choice. I can record a macro for one sheet that would work for the others, but that would take a long time and I am certain that you folks can find a far more efficient and elegant macro for a problem like this. Thanks In Advance! Noam -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.