How Can I Have Excel Insert 20 Rows After Every 6th Row?

Morning all.

I want to insert 20 blank rows after every 6th row of data I have.

This is in order to copy and paste my data into a separate pre-formatted sheet (I have read that there is no way of pasting into visible cells only).

I have little VBA experience, but I'm sure this must be possible. I have found various codes for doing this, but I am unsure which parts of the codes to edit to achive the number of rows I'm after. Any help would be most appriciated.

Thanks ,

Sean

"I have read that there is no way of pasting into visible cells only"
With a macro you could certainly do it.
What a bout a short sample to illustrate you need

Hi PCI,

I've attached as brief an example as I can.
I need to copy the data from sheet1 and paste it into sheet2. So, sheet1 cells A1:D6 would go into sheet2 A4:D9, and sheet1 cells A7:D12 would go into sheet2 A17:D22 etc...

My first step was to temporarily hide the rows I wanted to skip whilst pasting the data across, but it treats the hidden cells just as it would visible ones.

My original data set contains about 2000 rows.

Thank you Holger, that worked perfectly.
I really must sit down and get the hang of scripting these one day!

Another variation to copy directly from sheet1 to sheet2

Please Login or Register  to view this content.

Excellent, thanks PCI.
This will really save me some time.