kevinchurchill
New Member
- Joined
- Jul 20, 2015
- Messages
- 26
Hello,
I have an inventory XL spread sheet, what I would like to do is search for a specific refference N°(code article SAP) that will be in column B sheet 1 and then copying only the data for that refference that is in rows, N,O,P,R. and then pasting that data to another sheet, i want this as the end user does not need to see the full data relevent to the refference N°.
So the first example below is what I want to end up with on another sheet after searching the first sheet using only the Code article SAP N°.
I hope this is clear.
Many thanks for your help
<colgroup><col width="80" style="width: 60pt;" span="5">
<tbody>
</tbody>
<colgroup><col width="111" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4059;">
<col width="116" style="width: 87pt; mso-width-source: userset; mso-width-alt: 4242;">
<col width="127" style="width: 95pt; mso-width-source: userset; mso-width-alt: 4644;">
<col width="136" style="width: 102pt; mso-width-source: userset; mso-width-alt: 4973;">
<col width="145" style="width: 109pt; mso-width-source: userset; mso-width-alt: 5302;" span="5">
<tbody>
</tbody>
I have an inventory XL spread sheet, what I would like to do is search for a specific refference N°(code article SAP) that will be in column B sheet 1 and then copying only the data for that refference that is in rows, N,O,P,R. and then pasting that data to another sheet, i want this as the end user does not need to see the full data relevent to the refference N°.
So the first example below is what I want to end up with on another sheet after searching the first sheet using only the Code article SAP N°.
I hope this is clear.
Many thanks for your help
N N | O | P | R | |
Code article SAP | Numéro de commande | Date d'envoi de la commande | Délais de livraison prévu | |
700013205 | 4500456266 | 12/01/2018 | 18/01/2018 |
Date de la DDM | date de demande chiffrage | Retour chiffrage | Date d'envoi de la commande | Numéro de commande | Code article SAP | Montant | Délais de livraison prévu | Date Reception |
01/01/2018 | 11/01/2018 | 11/01/2018 | 17/01/2018 | 9500303528 | 540,00 | 24/01/2018 | 24/01/2018 | |
01/01/2018 | 01/01/2018 | 01/01/2018 | 16/01/2018 | 9500303432 | 224,00 | 23/01/2018 | 24/01/2018 | |
01/01/2018 | 01/01/2018 | 01/01/2018 | 04/01/2018 | 9500303079 | 74,00 | 10/01/2018 | 12/01/2018 | |
01/01/2018 | 01/01/2018 | 01/01/2018 | 24/01/2018 | 4500457298 | 6 729,17 | 06/02/2018 | 13/02/2018 | |
01/01/2018 | 08/01/2018 | 08/01/2018 | 12/01/2018 | 4500456266 | 700013205 | 95,00 | 18/01/2018 | 16/01/2018 |
01/01/2018 | 01/01/2018 | 05/01/2018 | 05/01/2018 | 4500455815 | 700013746 | 761,52 | 18/01/2018 | 22/01/2018 |
03/01/2018 | 03/01/2018 | 12/01/2018 | 17/01/2018 | 9500303528 | 253,96 | 24/01/2018 | 24/01/2018 | |
03/01/2018 | 03/01/2018 | 03/01/2018 | 04/01/2018 | 9500303079 | 1 065,44 | 25/01/2018 | 12/01/2018 | |
03/01/2018 | 03/01/2018 | 03/01/2018 | 03/01/2018 | 9500303052 | 365,35 | 03/01/2018 | 03/01/2018 |