Hi all
I have a s/sheet which gives me the product structure (Bill of Material) for numerous parent codes.
Column A shows Parent Code, B shows part code, C shows part description, D - part cost, E - Qty, F - Extended Cost.
Now having downloaded and FTP'd from the MRP system I then used Data>Subtotals to split all parents and give me a total underneath ext'd cost.
Great, but a few part codes have zero costs, so having sorted by ext'd cost the zeros sit at the bottom end of the structure.
Now all I need to do is flag them somehow so it is apparent that the cost is incomplete.
Is it possible to run a code or do anything else that will highlight the complete Row if the figure in column D is zero?
Sorry if that was a little longwinded!!
I have a s/sheet which gives me the product structure (Bill of Material) for numerous parent codes.
Column A shows Parent Code, B shows part code, C shows part description, D - part cost, E - Qty, F - Extended Cost.
Now having downloaded and FTP'd from the MRP system I then used Data>Subtotals to split all parents and give me a total underneath ext'd cost.
Great, but a few part codes have zero costs, so having sorted by ext'd cost the zeros sit at the bottom end of the structure.
Now all I need to do is flag them somehow so it is apparent that the cost is incomplete.
Is it possible to run a code or do anything else that will highlight the complete Row if the figure in column D is zero?
Sorry if that was a little longwinded!!