Copy value and associated offset into 2 other columns

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.

Please Login or Register  to view this content.

Thank you very much!
Gordon

Hi Gordon,

Try the below code based on your sample file

Please Login or Register  to view this content.

Glad to help & thanks for the reps ... Without a macro, you can just filter column B with <3000 copy data paste on E1 un-filter