macro to create an output file "worksheet"

[dexterP]

hi guys,


i need your expertise if this is possible using in vba.

i have an excel file that contains thousands of rows see attached excel file. i need to copy the "input" file put it in the "output" file. then insert an empty rows on below each rows based on the valueS ON "PEANUT" column see "output" file. then it will fill up the color based on the "reference" sheet.

hope you could help me.

thanks in advance.
P.S. i could not reply immediately since i dont have internet in my workplace..

[jaslake]

Hi dexterP

Welcome to the Forum!!!

This Code in the attached doesn't have your fancy formatting but it may get you started. CTRL + x will fire the Code.

Please Login or Register  to view this content.

[dexterP]

hi john,

thank you very much for this code. however, as try to run it. an error will appear "object variable or with block variable not set". i use debug, it will highlight this area [ c = Sheets("REFERENCE").Rows(2).Find(Cel.Offset(0, 3).Value, , xlValues, xlPart, xlByRows, xlNext, False).Column + 1 ]. my understanding is that c is not declared but in your code its already declared.

[dexterP]

by the way thanks for the warm welcome

[jaslake]

Hi dexterP

For want of a . (dot)..

Please Login or Register  to view this content.

[dexterP]

hi john,

it now works. thank you very much...
this will make it quick i could finished my job on time...

but i'll try to manipulate this one to format the borderlines...

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.