format columns

[Danny]

Hi,

Given the attached sample report
1. I would like to filter only the needed columns that are highlighted (Columns: A, E, F, H, L, W & X)

2.rearrange and list columns the same as Order Rpt (below)
A = Order Number B = Order Date C= Supplier D= Account Code E= Blanket Order F= Order Type G=Total

I use office 2010 what would be the best method to accomplish this?

TIA,
Regards,

 

[Brianwarnock]

All you need is a simple sub with a series of copy statements.

Sub a()
Worksheets("unimarketreport").Range("A:A").Copy Worksheets("order rpt").Range("A1")
etc
End Sub

BTW it is helpful if you say what columns are going where rather than expect us to work it out from the attachment, so I have left that to you.

Brian

 

[Danny]

Brian,
Thanks for your input.
For my 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

Regards,

 

[Brianwarnock]

Erm, I take it that you know how to write the sub from the info I supplied and have completed it, rather than expect me to code the remaining 5 lines.

Brian

 

[Danny]

Yes, based on your inputs, I was able to complete the rest and hide those unwanted columns.

Thank you for your help.

Regards,