macro to copy the values in only 2 columns of an excel file based on a condtion to another

[cbk40060]

I want copy the values in only two columns (Prod_code) & (Total)from three tables in an excel file (source file) to another excel file (target file), if the value in a particular column (Prod_code)of the first file, starts with 12345.
The first twelve records of the source file look as under:
source.PNG
Further, I want to inform you that the source file (first file) has the following features:
1. The file contains three similar tables. I mean the structure of the three tables is the same.
2. All the three tables have blank rows here & there in the three tables.
3. There are some text entries above & below the three tables.
Conditions for the target file:
1. Only the Prod_codes starting with 12345 should be listed in the target file.
2. There should not be any blank rows in the target file.
3. The records in the target file should appear in the same order as that of the source file.
The first twelve records of the target file should look as under:
target.PNG
The source_file.xls & target_file.xls are sent attached.
I am just a beginner regarding excel macros.
I tried recording a macro but the recorded macro is not working properly .
Any of you please guide me in this matter.
Regards,
cbk40060

[JBeaucaire]

Give this a try, be sure to edit the SaveAs path to where you want the new file saved.

Please Login or Register  to view this content.

[cbk40060]

Thanks JBeaucaire, the macro works very well.

[JBeaucaire]

Additional questions moved to a new thread.