Hi,
pls. is it possible to do this action?
I have huge table. This table contain data about clients for 12 month. Month are devided with headers. So januar is in row 4:500, feb 503:1000, march 1003:1503 and so....
Each month has header (3 line), which i dont want to change. For filling new data to this table (to whole table for all month) i use vlookup and it always overwrite my headers for each month because i copy it in row 4:5000. I tried to lock cells but if i select this locked cells with copying my formula it return error (of course).
Is it possible to copy over the locked cells, withou it return error and without overwriting my headers? And it will fill formula only to unlocked cells, and doesnt change any format in my headers?
I dont know if i am clear because my bad englis, but i hope, that you will understand.
thx for all help