Try recording a macro to do exactly what you want, then edit the code to your fitting.

So if the macro does something that uses a constant range (i.e. "A2:Z68") then you'll need to change that to the range you want.

It may also help to have an example sheet if you'd rather have us do it.