Sharid
Well-known Member
- Joined
- Apr 22, 2007
- Messages
- 1,064
- Office Version
- 2016
- Platform
- Windows
Hi
I need a code that will copy and paste data from column D to column B if column B is empty, the code will ignore any empty cells in column D and move to the next cell with data to copy over.
From this
<tbody>
</tbody>
To This
<tbody>
</tbody>
Hope this makes sense
I need a code that will copy and paste data from column D to column B if column B is empty, the code will ignore any empty cells in column D and move to the next cell with data to copy over.
From this
A | B | C | D |
JANE | JANE | DOE | |
JOHN | DOE | JOHN | DOE |
JANE | JANE | SMITH | |
JOHN | SMITH | JOHN | SMITH |
JAMES | |||
JILL | |||
JACK | JACK | JONES |
<tbody>
</tbody>
To This
A | B | C | D |
JANE | DOE | JANE | DOE |
JOHN | DOE | JOHN | DOE |
JANE | SMITH | JANE | SMITH |
JOHN | SMITH | JOHN | SMITH |
JAMES | |||
JILL | |||
JACK | JONES | JACK | JONES |
<tbody>
</tbody>
Hope this makes sense