ziad alsayed
Well-known Member
- Joined
- Jul 17, 2010
- Messages
- 665
dear all
with the below data, how can i copy the Word highlightted in yellow and copy it to the cells highlighted in red.
of course number of Rows varies.
Appreciate any help
Excel 2010
with the below data, how can i copy the Word highlightted in yellow and copy it to the cells highlighted in red.
of course number of Rows varies.
Appreciate any help
| Excel Workbook | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | Code | Description | |||
| 2 | Port Harcourt | ||||
| 3 | 4111100024 | 4111100024 1 FELPET NIG LTD | |||
| 4 | 4191109329 | 4191109329 1 SARATU SHEKARI | |||
| 5 | 4191109334 | 4191109334 1 STERLING BANK GRA P60 | |||
| 6 | 4191109335 | 4191109335 1 STERLING BANK FEGGE ONISHA | |||
| 7 | 4191110823 | 4191110823 1 FCMB PHC - P100KVA | |||
| 8 | 4191110824 | 4191110824 1 MINTEL FARMS LTD - P60 | |||
| 9 | 4191110825 | 4191110825 1 SONGHAI RIVERS - P250 | |||
| 10 | TOTAL OF Port Harcourt | ||||
| 11 | APAPA Branch | ||||
| 12 | 4111201129 | 4111201129 1 JMG LTD | |||
| 13 | 4111201217 | 4111201217 1 AMARACHUKWU OKOGBUE | |||
| 14 | 4191702205 | 4191702205 1 BEST BUY | |||
| 15 | 4191702233 | 4191702233 1 ASSENE NIG LTD | |||
| 16 | 4191702235 | 4191702235 1 KNEIPE NIG LTD -250KVA | |||
| 17 | 4191702259 | 4191702259 1 REAR ADMIRAL AGBEJE | |||
| 18 | 4191702266 | 4191702266 1 HASSAN FAWAZ | |||
| 19 | 4191702456 | 4191702456 1 FLUID MANAGEMENT-P22KVA | |||
| 20 | 4191702472 | 4191702472 1 SIFAX GROUP LTD-P40KVA GEN 2 | |||
| 21 | 4191702474 | 4191702474 1 NIYI OPEODU | |||
| 22 | 4191702477 | 4191702477 1 FOUANI NIG. LTD - P500KVA | |||
| 23 | 4191702481 | 4191702481 1 MR. SMART EGBEOBAWAYE | |||
| 24 | 4191702485 | 4191702485 1 YOMI SHO - SIL | |||
| 25 | 4191702814 | 4191702814 1 STERLING BANK PLC - TINCAN PORT (P40K | |||
| 26 | 4191702816 | 4191702816 1 MR. ADEYEMI ADENIYI | |||
| 27 | 4191702817 | 4191702817 1 HAYTHAM GHORAYEB | |||
| 28 | TOTAL OF APAPA Branch | ||||
Sheet1 (14) | |||||
