filter only certain columns

[OCM]

Greetings,
I’m using Excel 2010 and what is the best method
1. to filter only the needed columns that are in (Columns: A, E, F, H, L, W & X)
2. to rearrange and list columns in the following order
A=Order Number B=Order Date C=Supplier D=Account Code E=Blanket F=Order G=Order Type H=Total

TIA,
Regards,

OCM

 

[SkipVought]

Hi,

So do you mean that unnamed columns are not to be filtered?

As far as sorting horizontally you need to number the columns either a row above or below your table and sort HORIZONTALLY.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[OCM]

Thanks Skip,
Correct, I just wanted to filter out the following columns and rearrange them as follows.
My report is titled "vendor rpt". following are only columns that I’d like to filter out and what columns are going where:

Column A (Order number) no change
Column E (Order date) goes in column B
Column L (Supplier) goes in column C
Column X (Account code) goes in column D
Column H (Blanket Order) goes in column E
Column F (Order type) no change

Is it possible to attach sample excel file to make it a bit clear?

Regards,


OCM

 

[SkipVought]

Do you understand how column filters work? The ENTIRE ROW is hidden!

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[OCM]

Skip, thank you for inputs.

I was able to create a 'Custom View' and manually hide my columns:

View tab|Custom Views|Add
This seems to work for now.

Regards,


OCM

 

[Gavona]

Just in case it helps you could also use advanced filter to filter the original data to a new sheet including just the columns you want in thwe order you want in the results.

Gavin

 

[OCM]

Gavin,
Thanks for your post. Advanced filter works as well. I was able to filter out just the columns I wanted.

Regards,

OCM