thanks so much for your quick replying the code works perfectly but i have final point can i work this code automatically without press command button or macro just when i fill data in sheet1,2 it's automatically changes in sheet3
alhagag
You should know those 'final points' before open a new thread.
Each modification could mean to write the whole code again!
I took that button away ... is it better now?