data without postcode

[mathanraj76]

Hi...

I need help how to cut the entire column data from sheet 1 paste into sheet2 for those data without postcode

the postcode can be in Mailing Address Line 1(column F) Mailing Address Line 2(column G) Mailing Address Line 3(column H) Mailing Address Line 4 (column I)

if data have postcode then remain same at same sheet
if data don't have postcode then put this data into sheet 2

postcode number is 5 digit.

I have attached sample data file..

Thanks
Raj

[OllieB]

Try

Please Login or Register  to view this content.

[jindon]

Try this

Please Login or Register  to view this content.

[mathanraj76]

I have another question based on the data which i have sent..
Now i have the data with the same problem where without postcode move entire column from sheet1 to sheet2 but now it must base on code "4"

in the data i have code "1","2","4" in column E

code "4" is in column E where this code 4 address don't have postcode(from column F,G,H,I) move entire column from sheet1 to sheet2..

I have attached sample file

Thanks
Raj

[jindon]

I don't think what you are asking now is relevant to your original question and much easier.

Use autofilter.

[OllieB]

same code but now only selecting rows with a value 4 in column E

Please Login or Register  to view this content.

[mathanraj76]

Thanks it working ..
but when i check in sheet2 there are some address with zipcode are in but this address with zipcode have "comma"(",")
but address with zipcode but without comma but with space remain same in the sheet1

The rest of program is perfect

Thanks
Raj

[OllieB]

Try this code

Please Login or Register  to view this content.

[mathanraj76]

Thanks..
The problem solved ..
Once again thank to you.. you are really great..

I done this by manually but with your method it make me easy ..

From
Raj

[OllieB]

You are welcome.