Copy multiple columns in a loop

[rhudgins]

On "Sheet 2" there are 24 names in row 45 (more will be added later). Below each name are a maximum of 30 stock symbols. For the first name, I need to copy the symbols and paste them into A6:A35. Data will then populate in S36:AI36. Copy S36:AI36 to "Sheet 1" B3:R3.

Next go back to "Sheet 2" clear the range A6:A35 and repeat the same process for the 2nd, 3rd, 4th name ect.

[rylo]

Hi

see how this goes.

Please Login or Register  to view this content.

rylo

[rhudgins]

Thanks this is exactly what I needed!! Thanks for your help