Hi All,
Can anyone help. Need a macro/vba to copy and paste from one worksheet to another in a specific cell and in sequence and loop to the end. Worksheet1, there is only one column but format is the same and in sequence and is in LDIF format.
Example:
Worksheet1: user: Joe Blogs
Title: Administration
user: Mary Smith
Title: Cleaner
etc.....
In worksheet2: username: jbogs
username: msmith
etc.....
Data in WRKSHEET2 in column needs to be copied and pasted to worksheet2. in the blank cell in sequence. The output will be;
Worksheet1: user: Joe Blogs
Title: Administration
username: jbogs
user: Mary Smith
Title: Cleaner
username: msmith
Cheers.