how to check value in last 11 row and copy past?

hi
i have following code it copy data but in last row every time since it check the value of column
"A9:A" but i need to check only last 11 entry of that column.what should i do to this code so it check only last 11 entry of the column "A"

Please Login or Register  to view this content.

module code is like this.

Please Login or Register  to view this content.

also here i attached the sample wb so u may have better idea what i need to do
and also it auto fill down the formulas from previous row to new row if row insert for new records inserted at bottom.
any help is appreciated

Not quite sure I follow what you want to do but you might want to check out both Offset & Resize in VBE Help (from last populated cell)

something along the lines of:

Please Login or Register  to view this content.

however you should really be checking that the offset of -10 does not take you off the sheet...