|
|
#1
02-20-2018, 01:22 PM
|
|||
|
|||
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! 
|
| Tags |
| if empty copy adjacent |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Increase number in cell, based on value in adjacent cell | scottyb | Excel | 3 | 02-02-2017 03:51 AM |
| If column B cell is a certain value then copy and paste the value to column A | Snaybot | Excel Programming | 1 | 12-01-2015 07:10 PM |
| Data validation,force cell to be filed with number if respective cell is not empty | nicholes | Excel Programming | 0 | 08-01-2015 09:08 AM |
 How to conditionally format cells in Col. A if it matches adjacent cell in Col. B?
|
alshcover | Excel | 2 | 06-03-2014 12:50 PM |
| Conditional Formatting Expiration Dates Based on Text in Adjacent Cell | Frogggg | Excel | 1 | 10-25-2011 08:44 PM |
Windows 7 64bit 
Office 2016
Threaded Mode