Looping through ranges in worksheet

[stevow]

Hi guys

One that is scratching my head.

In a nutshell, I need to copy and paste spec values, from Sheet X to Sheet Y. (this bit I can do!!!)

The size of the range in Sheet X is always the same - 5 columns by 20 rows.

My problem is that I need to do this for every range of data that exists in the sheet - can anyone help with programming this?

The data looks similar to the attached...

Thanks!

example.jpg

[arlu1201]

Please attach a sample excel file instead of a jpg.

[stevow]

Example in xlsx format attached.

Sheet X is the original data

Sheet Y is what I need the result to look like.

Thanks for any help

[nilem]

try it

Please Login or Register  to view this content.

[stevow]

This works brilliantly - in fact - too good!

For my actual workbook that it would be used in, I don't need to copy the headers. Which section should I edit for this? I am guessing it is around the offset part - but I don't fully understand the coding just yet.

Thanks again - appreciate it.

[nilem]

this line

Please Login or Register  to view this content.

[stevow]

Brill!! Thank you very much!