Posts by Robmarnsw

I need to copy data from one worksheet and paste into another worksheet in Column A every nth(5th) cell in that column and loop unit finish.

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.