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.
|