Thanks, Nick for your thorough answer. It all makes sense now.
Thanks but I am hopeless in coding. How can I do that?
Thanks i found it. your comment was very helpful.
Thanks Tom for your explanation. Now I know how to use loop and Merge but still does not do the job I want. as I mentioned I have an excel file with 1000 rows and each row has several columns (e.g. Row 1 - Column A, Column B, Column C, ...Row 2 - Column A, Column B, Column C, ......When I randomly select for example the data in cell 1A for the first question, in the second question i want to call the data in cell 1B. i don't know how to link them!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.