Hi
I have a column B where some values (probably thousands) that should be in the date format are missing the day and month, hence have just the year as a 4 digit number. (Please see attached Example.xlsx) (it includes expected results)
I'd like to use VBA to copy just the cells that have the year (4 digit number format like ####) as well as their offsets from column A, on columns F and E respectively.
I require VBA for this problem as there are thousands of values that meet this condition, so a for loop would be required.
Thank you very much!
Gordon
Bookmarks