removing a section of a song

Hi,
I am working on a song that started as a MIDI file. I am using the following:
Sonar Producer X2, Focusrite Scarlet 2i2 sound interface, Midisport 4x4, Intel i5 650 @ 3.2 gHz, 6.0GB RAM, 64 Bit OS. Yamaha 24 ch mixer; various synths
 I had downloaded a midi file and was playing many of the parts myself into separate audio tracks. I now realize that the middle percussion track of this song (Soul Sacrifice, by Santana) is too long for my purposes. I am of course aware of first splitting the clips at the point I want to erase and then  splitting again at the end of the part I want to split--and then cut it and delete the hole. However, this doesn't seem to work with my audio clips. For instance, I might have 1 audio guitar "clip" (if that's what it's called) before the drum solo, and then a few more after the solo. So, if I first get rid of 8 measure of my drum solo track, and, of course, delete the hole, I then need to move over to the left those clips that come after the drum solo. When I try to split the audio track, it doesn't work. I see now that it must be because there IS no audio guitar track during the drum solo, since I didn't record any there. So, there is nothing to split.
I realize that I can simply move over each audio track, but that is proving difficult to move just the right amount.
SO.....my question, finally: is there any way to just ask Sonar to delete multiple measures of a song, either at once, or for each track at at time, and then have everything that comes after that move over to the left to take its place?
Hope that's clear.
LNovik

If you do not wish to upgrade to Cakewalk by Bandlab and use Ripple edit, you can still easily accomplish this in X2.

Use Control A to select all tracks. Enable Snap to grid set to Measure. Select the bars for deletion in the timeline (eg bars 17 through 33). Go to Edit, Click delete, Click to select All of the boxes ( events in track, track/bus automation, tempo changes, meter key, markers , *Delete hole, shift by whole measures). Click Ok. Everything should delete and the stuff after should skooch over. You may need to make adjustments to the edges of clips to smoth the transistions depending on what is there.

+1 Ripple Edit
i've saved more hours of time rearranging projects with it than i can count, at this point

Since Cakewalk became free it's weird and rare to see a post with someone using an older version.
There's nothing in your list of what you are using that would prevent you from using CbB.
Download it and give it a try. You can keep X2 so nothing is at risk at all.

"Delete Hole" only works if the area being deleted has data in it. If there is no data in the selected measures "Delete Hole" does nothing.

LENovik
Any ideas if BandLab does this particular function better?

Yes - See Scook's reply re: Ripple Editing

I didn't read the OP well enough. Thought you were using CbB.
Its much easier with CbB than with sonar but can still be accomplished as long as there is something in the hole.
To avoid further confusion, I cant add anything that's already been explained here.