put headers and values in array & copy values

[leap out]

hi
I have data in sheet1 . some values should repeat more than one time when copy to sheet2 as DATE and ORDER based on last filled data in COL B (BRAND)
and some values are not existed at all in sheet1 it supposes creating by put the headers and the values in array and repeat the value when copy to sheet2 as ACCOUNT NO(COL D) , REF(COLF), CASE(COL L) finally if there is a macro to create all of data based on sheet1 with the same formatting and borders except the formulas shouldn't copy as formula just show as a value and what I explained .
thanks in advance

[leap out]

any body help?

[tanasedn]

Hi,
maybe this:

[leap out]

thanks for your trying . but as I said the header and value are not existed in sheet1 then should put the headers and the values into array by code and copy as result in sheet2

[tanasedn]

Maybe this:

[leap out]

yes it creates the headers . now it remains the value for the headers (ASD1,11411234,AS.11,UNPAID)

it should copy under header ORDER "ASD1" and copy under header ACCOUNT NO "11411234" and copy under header REF "AS.11" and copy under header CASE "UNPAID"
thanks again

[jindon]

Please Login or Register  to view this content.

[leap out]

@jindon thanks but I think there is not right into the code see the highlighted data as in file.

[jindon]

No idea how you make it like that.

[leap out]

strange ! your file works as what I want .
thanks so much for your assistance

[jindon]

Its not my file, YOURS.