Oct 07 2022 08:36 AM
Hi, i need to make sure the wording matches and then reduce the quantity on the left by the quantity on the right. Is there a simple way to do this please? As wording are not always going to be on the same line.
Equipment used: | ||||||
Parts Description | Manufacturer Part Code | Supplier | Quantity | Parts Description | Manufacturer Part Code | Supplier: |
apollo xpp95 addressable smoke detector | 55000-600APO | ADI | 50 | apollo xpp95 addressable smoke detector | 55000-600APO | ADI |
apollo xp95 manual call point | SA5900-908APO | ADI | 100 | apollo xp95 manual call point | SA5900-908APO | ADI |
Oct 07 2022 08:37 AM
Oct 07 2022 09:21 AM
I don't see a quantity on the right...
Oct 07 2022 10:54 AM
@Hans Vogelaar there’s one on the right the one on the left is missing but it’s Column A
Oct 07 2022 11:40 AM
I'd use a separate column so that you can see the original stock. See the attached workbook.