Hi Mike
I want to copy formulae in one sheet, this formulae is referring to
other sheet, in sheet1 the formulae repeat every 4 rows, ex. A11, A15,
etc..
In the sheet2 this formulae refering to sheet1 is repeating every 3
rows, ex. A10, A13, etc.., so the increament is minus 1, when I drag
or copy and paste, it gives the result of one row higher, and I have
to adjust the cell number every time.
Sheet1
A11 formulae
A15 formulae
in sheet2
A10 should be as A11 in sheet1
A13 shoulkd be as A15 in sheet1
Hope I am clear
Thanks in advance
Jam

Mike H wrote:
Can we see an example of what you expect to see when the formula is copied
down?

" wrote:

Hi
How can I use Offset function to copy formulae, in one column and 4
rows, or every 4 rowas
Thnaks in Advance
Jam