Macro to combine data sets with a ratio

[martinblake02]

Hello,

I am looking to create a macro where i can combine two sets of data based on a ratio.
I am pretty good with macro's but i cant seem to work this one out.

I want to start with an easy ratio of 1:1, so i have two data sets 'MLA' and 'PLA' and i want to combime them on a 3rd tab in the following order:
PLA #1
MLA #1
PLA #2
MLA #2
etc...

Unfortunately i don't use this forum too much and i can't see an option to upload my data sample.
Any help would be much appreciated.

Thanks,
Martin

 

[martinblake02]

I have added the file to DropBox = this link should work:

Dropbox

www.dropbox.com