format columns (1 Viewer)

Danny · Apr 19, 2014

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 · Apr 19, 2014

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

Code:

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 · Apr 19, 2014

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 · Apr 19, 2014

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 · Apr 21, 2014

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

Thank you for your help.

Regards,

format columns (1 Viewer)

Danny

Registered User.

Attachments

Brianwarnock

Retired

Danny

Registered User.

Brianwarnock

Retired

Danny

Registered User.

Similar threads

Users who are viewing this thread