When I copy tables from PDF to Excel, I would like for Excel to:
1. delete all columns except C, F, I
2. highlight (Fill Color or something similar) the row that contains a cell with a content 'ABBA' or 'GED' (as in words ABBA or GED)
3. highlight (Fill Color or something similar) the column that contains a cell with a content 'PINK' or 'RED' (as in words PINK or RED)
3. highlight the cell juncture of the above mentioned row and column cells (ABBA/GED an PINK/RED) and copy the cell value into a new cell (let's say A29)
Can it be done? Macro or perhaps just with Excel functions?
Additional info:
The software that contains the PDF doesn't support export, I can only copy
I can only select the whole PDF page (with all columns and rows, not just a selected few).
Thank you for your help.
1. delete all columns except C, F, I
2. highlight (Fill Color or something similar) the row that contains a cell with a content 'ABBA' or 'GED' (as in words ABBA or GED)
3. highlight (Fill Color or something similar) the column that contains a cell with a content 'PINK' or 'RED' (as in words PINK or RED)
3. highlight the cell juncture of the above mentioned row and column cells (ABBA/GED an PINK/RED) and copy the cell value into a new cell (let's say A29)
Can it be done? Macro or perhaps just with Excel functions?
Additional info:
The software that contains the PDF doesn't support export, I can only copy
I can only select the whole PDF page (with all columns and rows, not just a selected few).
Thank you for your help.