hi werafa,

hanks for your reply. i understand what you are saying clearly. i hope i can do the first part with some research, try and errors. but the second step is a way confusing to me. not just save as csv but dealing with the dynamic range that i need to copy.

for eg according to the source table i need to have 3 separate csv files. where i need to find the first cell of the sequence column as well as the last cell of the sum of try column related to that one particular kit no. and do the same for next data set here the copy range is always moving and

i hope which is need to done by looping or similar function. and i couldn't think in method to do it programmatically.

will you be able to give me an code examples to this part ?

i know this is not a "give me the code" site but your help can save my day and i will be so great full..

thanks in advance.