fill data under headers based on another range in the same sheet

[abdo M]

hi
I want filling data under range A:F based on matching headers with K:P . I put resut in second sheet how should be in first sheet
thanks

[jindon]

Please Login or Register  to view this content.

[HansDouwe]

Or with a formula: Please try in B2 and copy to right

Please Login or Register  to view this content.

[superjoejoe2000]

is this what you need?

[abdo M]

Hi jindon
thanks for your code.
I have question I don't see any topic of header in your code . when you have filter based on column 2 , does it mean column ITEM ?
if it's so I have to explain more . I'm fraid face problem with this solution .

[abdo M]

@HansDouwe & superjoejoe2000 thanks for fromuals , but I want vba , sorry!

[beyond Excel]

Hello. Basically you need to reorder the columns so that the Index function can help you:

Sub Macro2()
Columns(5).NumberFormat = Range("L2").NumberFormat
With Range("K1").CurrentRegion
  Range("A1").Resize(.Rows.Count, .Columns.Count) = _
    Application.Index(.Cells, Evaluate("Row(a1:a" & .Rows.Count & ")"), _
    Array(3, 1, 6, 5, 2, 4))
End With
End Sub 

[jindon]

You have before and after sheet, so you must have prepared header for result.

Otherwise, simply

Please Login or Register  to view this content.

[abdo M]

@beyond Excel excellent !
great idea to arranging columns again

[abdo M]

You have before and after sheet, so you must have prepared header for result.

yes I don't expect from you use specific column to filter data . I thought you will create code search for headers and brings data .sorry about this confusion ! after tested both codes I will take the first becuase is really fast more than looping .
thanks very much for two codes .

[jindon]

If you use my first code, headers MUST be identical, no miss spelled.

AdvancedFilter should be the fastest and no need to adjust the formattings.

[abdo M]

If you use my first code, headers MUST be identical, no miss spelled.

AdvancedFilter should be the fastest and no need to adjust the formattings.

thanks for this clarification .