sequence content from multiple sheets into one master

[dalerdd]

I am trying to build out a schedule system where I sort by duration :30 1:00 2:00 etc... then insert content cells from 3 different sheets into the slots, insert msg 1 from sheet one then msg 1 from sheet 2 then msg 1 from sheet 3 then going back to sheet 1 to get msg 2 etc until there is no more content then repeating.
Attached is a sheet with a macro I have which sorts and creates a number system, and inserts content but I could only get the one piece of content inserted and not the variety from the different sheets. There is a a sheet with the final resuts. I do have a loop going on which I have this code inserted , not sure if I need to do the second part outside of the loop or not.
Thanks
Dale

Please Login or Register  to view this content.