Dear Pyrite Thank you so much for the code. My problem is I have exciting file with multiple sheet. I just want to add numbers within templet without hurting other sheet. ods excel will removed all sheet and rewrite but i don't want to touch other sheet. I just want to just populate output in templet. Templet has some heading and text which should be as it is. On above example: I want populate 4x4 matrix number in C6 to F9 without touching any other text. I have heading and some definition in row 1 to row4, B5 has column heading and i want fix (un-touch) row 5 and column B5. Again i don't want overwrite, just want to populate C6 to C9 by numbers without touching other sheets and text within sheet. I have 100 sheets in the file. Hope you understand. Once again thank you so much for your help.
... View more