Dear friends,many thanks for help.
1-Mr.Don : with my appreciation to your solution ,there is only one
note about the ( total ) column which doesnot appear in( main )sheet and
all( months sheets) transferred invoices.
-My e.mail is ( ).
2-Mr.Joel : with my admiration in your solution ,i think there is a
problem in A- ( sheet 12 ) after transferring data B- the months
sheets after 5 sheet , if you can check the result of transferring the
data .
Hopping to recieve any amendments for the codes which help me to reach
the target.
My regards.


--
tofimoon4
------------------------------------------------------------------------
tofimoon4's Profile: http://www.thecodecage.com/forumz/member.php?userid=138
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=100128