Having problem with autofilter vba

[SHEIKH TALIB]

Hi everyone,
I have a little knowledge about vba.I have made a workbook for my work,everything is working correctly except the two macros I entered at the end they autofilter data & copy & paste specific rows to sheets.I don't know what I have done wrong ,when I ran macro it disturbed my data sheet.
Can someone help me please,is there any other easy way to solve my problem,if someone make it decent looking I will be grateful to him because stock sheets,sell sheets & customers sheets should be differentiate easily.

[mancubus]

cross-posted here:

http://www.vbaexpress.com/forum/show...autofilter-vba

[jaslake]

Hi SHEIKH TALIB

Please reference your Cross Post in accordance with Forum Rule #8.

Forum Members, please don't respond to this Thread until the OP has done so.