That works fine! Thanks.

but when i save file it ask me to save with micro enable.

i save it with both file type micro enabled(xlsm) and micro free(xlsx) in both case automatically copy paste does not work when we open file after saving it.

also when i clear the content of main sheet it does not cleared from customers sheet(i want this to be done too)



i hope i am not making you angry by asking too much.
Thanks again for your kind effort.