copying entire rows from one worksheet to another

[silverh]

I have a work in progress and I do need the help of the people here.

In the image link, say I need to copy the row of "C_C_FOB_AEL" and "C_C_FOB_LAM" consecutively to another workbook.

\1

I initially did a code such that it will copy all ranges in use but since the other rows are not needed, might as well drop the trash (not to mention that the data is so huge now).

My current code located in the workbook where it will be pasted is something like this:

Please Login or Register  to view this content.

As you can see, I am having troubles in the following areas:

• properly telling what strings to find (in this case only, C_C_FOB_AEL is searched)
• identifying the correct row (currently, it just returns the $A$3, I have to hardcode the $A$3:$M$3 part)
• once the correct row is chosen, it will be pasted to that same row. What if i want it to be pasted to say A1:M1 instead?

Thank you very much for your response.

I am also attaching the workbook where this code maybe found.

The workbook is a little messy now so please be gentle.