Hi All,
I need to be able to get 2 pieces of data from 1 cell and filter it by speific criteria (example workbook attached)
I need to be able to extract an Entity reference and a cost centre. I have manulally completed a few in the workbook to show what the end data should look like.
The issue is that the data in the cell I am extracting from (highlighted yellow in workbook) does not always have the data in the same order.
Example 1:
Cost Centre cell (in yellow in workbook) contains: ZH626 UK-CORP LEGAL DEPARTMENT(908000510)
In this instance I need to extract the cost centre (which is ZH626) and identify the entity (which 908000) - I have listed the entities on a worksheet in the workbook
Example 2:
Cost Centre cell (in yellow in workbook) contains: 908140146-M2292
In this instance the cost centre is (M2292) and the entity is 908140
Please let me know if this is not very clear, see attached workbook.
All help gratefully received.
Thanks,
Marshybis