How to Copy Paste Formula in Excel But Skip 1 Cell

Question

I am working on my report using WPS Office Excel (it is almost same like Microsoft Excel), I have 2 sheet For example, My report sheet is called "Report" and my data sheet is called "Data".

In my "Report" sheet I need to copy paste formula like this

from Cell AP12

=((+Data!BK12*$P$11)+(Data!BL12*$Q$11))/$R$11

To Cell AQ12, I need the Cell AQ12 to become like this

=((+Data!BM12*$P$11)+(Data!BN12*$Q$11))/$R$11

But when I copy paste here's what happen in cell AQ12

=((+Data!BL12*$P$11)+(Data!BM12*$Q$11))/$R$11

Can

Answer 1

=(offset(+Data!BK12;;-2+ROWS(A$1:A1)*2;;)*$P$11)+(offset(+Data!BL12;;-2+ROWS(A$1:A1)*2;;)*$Q$11))/$R$11