I am trying to copy data from sheet 1 (which is manually updated by users) to sheet 2 (which acts as a database).
The data I need to copy consists of processes and users. Processes are listed in one column on sheet 1 (no breaks), users are listed in one row, both the number of users/names and processes will change. The loop needs to stop copying when there is a blank cell after the last user. Sheet 1 looks like this:
User1 User2 User3 etc blank
Process a
Process b
Process c
etc
I need to write a loop code, which would copy complete list of processes, and then add user name next to it (ie if there are 4 users, list of processes would be copied 4 times below each other, a set per user). E.g.
The data I need to copy consists of processes and users. Processes are listed in one column on sheet 1 (no breaks), users are listed in one row, both the number of users/names and processes will change. The loop needs to stop copying when there is a blank cell after the last user. Sheet 1 looks like this:
User1 User2 User3 etc blank
Process a
Process b
Process c
etc
I need to write a loop code, which would copy complete list of processes, and then add user name next to it (ie if there are 4 users, list of processes would be copied 4 times below each other, a set per user). E.g.
- Column 1 Column 2
- Process a User 1
- Process b User 1
- Process a User 2
- Process b User 2
- Process a User 3
- Process b User 3
