Macro with fuction RIGHT in blanks cells

Hello guys,

I have a PDF report which a company send me everyday and I have to export it to excel, but with the exporting, some pages have errors like this:

Excel.jpg

As you can see in the previous image, in the Action column (G) sometimes the "Action" and the "Resp. Co" are exported in one cell. (The word RIG in the cell that are marked in red should be in the "Resp. Co" column (H))

What I need to do is a macro that finds first of all the word "Resp. Co" (Sometimes is in different columns, but always is next to the cell who contain "Action") and if the cells down that one are in BLANK the macro should write the last 3 digits of the left cell (RIGHT(A1,3)). If it doesnt contain anything then do nothing. It could be from the cell ActiveCell.Offset(1,0) until the cell 100 from the same Column.

I need the macro to hasa loop through the pages to do the same job.

Is this possible? Im attaching an example of the file here: MorningReport1.xls You will find the exporting errors the last 3 pages, and they are marked in red.

thanks!!

anyone?

Untested try on a copy first. Hope I understood.

Please Login or Register  to view this content.