Thread: IF adjacent cell empty Copy from Other Column
View Single Post
 
Old 02-20-2018, 01:22 PM
ChrisOK ChrisOK is offline Windows 7 64bit Office 2016
Advanced Beginner
  
Join Date: Sep 2016
Posts: 54
ChrisOK is on a distinguished road
Question IF adjacent cell empty Copy from Other Column
Looking for vba sub solution that will do the following:
On "Active.Sheet", IF Col I cell is empty, then COPY/PASTE adjacent cell content from Col E into Col I.

*Start on row 2 (since header is on row 1)
*Date formats of Col I when complete should be: mm/dd/yyyy


Saw some ideas regarding copying from wkbk to wkbk and sheet to sheet but I simply need it from the adjacent column..
Thanks greatly!
Reply With Quote