Data extract by state

Hi ..
I need help ..

I have a data where I need to extract the complete data based on state in column"K" into new sheet by category state
If the data which don't have state or empty cells in column "k" or else if postcode is invalid in column "J"
for an example the postcode can be "00000" or "000000" or "00" or it can be empty then need to extract into new sheet..

I have attached sample data in ms excel


Thanks
MathanRaj

I have try you code but the data all empty except the header of rows is there..
pls help me ..
Thanks

Yes..thanks It work fine for me..
you r really good..
I have another question
How if i want extract the data from sheet1 to sheet2, sheet3 and so on..based on state on column"k"
Thanks..

But..i can't get which i want from the thread which ask me refer..
Can u give me so attached files with it ..
I'm still new in vba excel..

Thanks

yes..
for an example
if data in sheet1 in column "K" state is "Kangar" then copy the entire data for "kangar" and paste into sheet2
if data in sheet1 in column "K" state is "Kuala lumpur" then copy the entire data for "Kuala lumpur" and paste into sheet3 and so on..

Thanks
MathanRaj

Actually

what i want the data from sheet in column "k" if state is "KANGSAR" THEN COPY THE ENTIRE ROW FOR KANGSAR AND PUT INTO SHEET 2
IF the data from sheet in column "k" if state is "KUALA LUMPUR" THEN COPY THE ENTIRE ROW FOR "KUALA LUMPUR" AND PUT INTO SHEET 3

I have Attached sample data
tHANKS

Sixthsense has provided you a code which copies the name in column "K" to each individual sheet. Why do you need now to copy them in to sheet1, sheet2? what is the reason?