copy the order number to corresponding cells
A B
C A1-5002998 H10065002998 H0610SSI3052 A2-5002998 32 1 A3-5002998 64 1 A4-5002998 32 1 A5-5002999 H100650029989 H0610SSI3053 A6-5002999 64 1 A7-5002999 32 1 I need a help to copy order numbers from B1 to B2,B3,B4 etc and customer numbersC1 to C2,C3,C4 etc corresponding ordersequence number which is (A). I do have 200 orders like this and all of them needs to be sorted by order number instead of squence number in order for me to create a Purchase Order. Thank for the help. |
All times are GMT +1. The time now is 10:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com