Code for skipping cells

[samdaman91]

Hello forum,
I am not quite sure if this is a vba related issure but i was wondering if theres anyway to have a spreadsheet that skips a fixed number of cells. For example I wanted my spreadsheet to look something like this


='sheet1'!b1
cell with content
cell with content
cell with content
='sheet1'!b2
cell with content
cell with content
cell with content
='sheet1'!b3

etc...

I want to able to drag this equation down an entire column.

Please Help

[Richard Buttrey]

Hi,

One way assuming you want to copy A1 to A5, A9, A13..etc is in A1 on Sheet2

Please Login or Register  to view this content.

and copied as appropriate.