Autopopulating data from master excel sheet [Closed]

Posts
2
Registration date
Sunday April 15, 2018
Last seen
April 15, 2018
-
Hi,

I have a master sheet where column A, B, C etc. resides username, password, application etc. information.

Now I have created a report which has questions in 1st column of new excel sheet where row 1 will have question 1 - what is username ?, row 2 - question 2- What is the password ?. Row 3 - question 3 - What is the application etc.

My task is to populate answers from master sheet to each individual questions.

Example:
COLUMN 1. COLUMN 2
ROW 1 What is the username - Roy
ROW 2 what is the password - Password
ROW 3 what is the application - SAP

This information is populated from master sheet. I have 300 usernames passwords and applications in master sheet and I need to create 300 individual reports with VBA so it automatically does for me. How can I do it ?
See more