I have 3 worksheets (sht1, 2, 3) with rows of data, all 3 following the same headers.
I want to take 2nd row from sht 1, 2nd row of sht2, and 2nd row of sht3 and paste them to a new worksheet and for this to repeat in a loop to the 3rd, 4th..nth row of all 3 sheets.
Here is a visual to help
Sheet 1
Header
1a
2a
3a
na
Sheet2
Header
1b
2b
3b
nb
sheet3
Header
1c
2c
3c
nc
Desired end result of Summary Sheet
1a
1b
1c
2a
2b
2c
3a
3b
3c
na
nb
nc
I assume this can be done using VBA, but I am not well enough versed to do it
Please help!
Thanks!
Solved by G. Q. in 18 mins