How to ignore multiple cells from drag and fill or enter any formula

[Unexpc]

Hi guys

when i drag and fill, i want skip 2 rows and force not filling 2 rows (2 rows are in every page and i can't insert any formula beacuse in my workbook, all cells filling with a formula) anyway ignore this 2 rows in every page when i drag and fill? (for example i drag and fill 34 cell in 1 column and cells formula refers to a sheet cells. When i copy and paste that sheet, this 2 rows give formula that disrupting order of link cells for my page, beacuse i want this 2 specific rows 40:40,41:41 and next 34 rows ... in each page, this 2 rows should ignore from drag and fill) how solve this automate drag and fill and ignore this 2 rows?

 

[Unexpc]

thats fixed with before formula (in new formula, not skip correctly 2 specific row) but another in before formula, this start at Cell B6 not Cell B3!

 

[maabadi]

Please say which numbers of formula that start from row 8 in print sheet and link data from row 3 at main sheet

You should convert all of ROW()-8 to ROW()-5 (input this formula to Row 8 and drag it down)

=IF(MOD(ROW()-6,34)=0,SUM($C$7:C7),IF(MOD(ROW()-7,34)=0,"Your Text",IF(IFERROR(INDIRECT(LOOKUP(2,1/(("Sheet1!B"&ROW()-5-INT((ROW()-6)/34)-INT((ROW()-7)/34))<>""),("Sheet1!B"&ROW()-5-INT((ROW()-6)/34)-INT((ROW()-7)/34)))),"")=0,"",IFERROR(INDIRECT(LOOKUP(2,1/(("Sheet1!B"&ROW()-6-INT((ROW()-6)/34)-INT((ROW()-7)/34))<>""),("Sheet1!B"&ROW()-5-INT((ROW()-6)/34)-INT((ROW()-7)/34)))),""))))

 

[Unexpc]

You should convert all of ROW()-8 to ROW()-5 (input this formula to Row 8 and drag it down)

=IF(MOD(ROW()-6,34)=0,SUM($C$7:C7),IF(MOD(ROW()-7,34)=0,"Your Text",IF(IFERROR(INDIRECT(LOOKUP(2,1/(("Sheet1!B"&ROW()-5-INT((ROW()-6)/34)-INT((ROW()-7)/34))<>""),("Sheet1!B"&ROW()-5-INT((ROW()-6)/34)-INT((ROW()-7)/34)))),"")=0,"",IFERROR(INDIRECT(LOOKUP(2,1/(("Sheet1!B"&ROW()-6-INT((ROW()-6)/34)-INT((ROW()-7)/34))<>""),("Sheet1!B"&ROW()-5-INT((ROW()-6)/34)-INT((ROW()-7)/34)))),""))))

Again, you solved my problems, Thank You...