Hi, i have little bit harder case and do not know how to solve this...
I have some references number in column AE..not every row has references, there are also blank rows between them...and I need for each references, to check column AD, where are company names as CHANG HWA,CONCORD SECURITIES CORP. etc and for one references there can be more rows with same company name...and I need to copy from column N -ordernumber to column AG for each company...meaning to search all rows and copy all references for one company to one row...For example company CHANG HWA - references are in format 00007654353 00009837308 and i dont need zeros, just follows after them and paste it as 7654353 9837308 for example for company CHANG HWA to one row next to the reference from column AE
I hope its little bit clear what i need to...for every input i will be glad..
Bookmarks