OK, but without atached sample nobody can helps me?
I try it explain one more time.

I have table with e.g. 1000 rows and 30 columns.
After e.g. each 100 rows is header. This header devide data of table - it is devide year to months.
1 row - header january (contain, ID, product, name...30 other values)
...
100 row header febr (contain, ID, product, name...30 other values)
...
200 row header march (contain, ID, product, name...30 other values)
...

and monthly i update data with vlookup, but i want to copy this formula to row 1 and copy to row 1000 without changing headers (jan, feb, mar...)

i dont want to overwrite my headers

how can i do this? I tried lock, but then it return error.
any other suggestions?