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.
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 ?