VBA code to copy columns to Excel based on Multiple Criteria

[xdetective]

Hi

I am new to the Forum, I want to copy whole column to another worksheet in the same work book if the criteria in a certain row matches a certain criteria for example copy the whole column if the cell in the row has P,N,A but not blank.

[patel45]

attach please a sample of your file withs comments

[xdetective]

attach please a sample of your file withs comments

Many thanks for your response much appreciatted.Please find attached an sample with comments hope this makes it clearer.

[xdetective]

Help anyone thanks