Automaticly Moving Data Between Sheets

[sczerniak]

Hey everyone, I am working on a macro which transfers data from one sheet to another. The code starts by taking cells M1:P1 from sheet SL_Background and moving them to B9:E9 on sheet CreateSL. It then moves to the next set of four cells on SL_Background (Q1:T1) onto the next line down on sheet CreateSL (B10:E10). I am repeating this process about 180 times right now and it is all coded like this:

Please Login or Register  to view this content.

So what I would like to do is to make something that automates this process and will eliminate more than 1000 lines of code. I'm pretty sure I need some kind of loop but I'm not sure exactly how to set it up properly. Any help would be greatly appreciated, thanks.

[tigeravatar]

sczerniak,

Assuming you are doing this for 180 sets of four cells, and only using row 1 of sheet 'SL_Background', this should work for you:

Please Login or Register  to view this content.

[sczerniak]

Awesome, that was exactly what I needed. My code also runs more than 20% faster now too!

[tigeravatar]

You're very welcome