Is there any way to solve this problem ?

Hi all!

I got a problem with my macro... this is basically macro for sorting
questions and answers from 2 sheets into a new one. The result looks like
this :

----------------------------------------------------------
| A | B | C |
----------------------------------------------------------
| 1 | Who was the first... | |
----------------------------------------------------------
| | Lincoln | |
----------------------------------------------------------
| | Washington | + |
----------------------------------------------------------
| | Clinton | | ----------------------------------------------------------
| 2 | The only animal... | | ----------------------------------------------------------
| | leopard | |
----------------------------------------------------------
.....


My question : is there any way to insert :
1) a), b), c), d)... before the answers
2) blank row indent between 2 questions

to make one more sheet with the correct answers, ex. :

1 C, 2 B, 3 D and so on..


Here's my code :

Please Login or Register  to view this content.

Ty in advance !

Please wrap your code, read the forum rules...

Welcome to the Forum, you must take the time to read the Forum Rules. You have used a Thread Title that does not conform with the requirements & not used Code Tags. Click the link below to read them now, thanks.