sparky3883

Hey there

I have recently created a spreadsheet which contains 3 sheets.

Sheet 1 holds most of my information, and by using the Data|Filter|Advancefilter option, i am selecting one entire column of information and copying it onto sheet 2.

The problem is, although i am transferring the entire coulmn of information onto Sheet 2, i need to leave 5 rows blank, therfore, i am needing to separate the transferred information.
I am using the formula $A$1:$A$20 to copy the information into Cells A1 to A20.
However, i need to leave cells A8 - A12 blank, so is there any way that i can copy the selected info over, but leaving these cells blank.

Would something like $A$1:$A$7:$A$13:$A$26 work?

Thanks for the help

Kluz

You can add the line:after the copy process.

sparky3883

Thanks for your help, but if i used that command, would it clear the contents completly, or will it clear the specified cells and move the contents down??

Thanks again

Jamirez

ClearContent will completly erase all data in range.