gavinj2006
New Member
- Joined
- Jul 28, 2015
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
I have a sheet of order exports to be reimported to an excommerce system, the new system requires that for both lines of the order (order and despatch) have an email address but the export has some (many) missing.
I need to select the column and have Excel add the missing emails where appropriate.
The example containes an illustration of the sheet, the 2 detail lines are the order and despatch details and the empty rows below are details of the specific products ordered.
In the example, cells B8 and B30 needs to have the email address from cell B7 and B29, the rest are correct.
Any help would be much appreciated, thanks
I need to select the column and have Excel add the missing emails where appropriate.
The example containes an illustration of the sheet, the 2 detail lines are the order and despatch details and the empty rows below are details of the specific products ordered.
In the example, cells B8 and B30 needs to have the email address from cell B7 and B29, the rest are correct.
Any help would be much appreciated, thanks