Hey all,
I'm relatively new to VBA and generally just tweak code I find, however I'm struggling with this one.
I have a table with 3 different date columns (Date1, Date2, Date3), and a 4th (DateDiff) which calculates the difference in months between Date1 and Date3. I'm trying to get a code to search the DateDiff column for the value being 6, when found I'm then wanting it copy date2 to date1, date 3 to date2, and clear date3 of the relevant row. Then loop through the rest of the table.
In my head I'm thinking table to an array, and then some sort of find.replace, however I just can't get my head round it.
Thanks in advance for your help!
I'm relatively new to VBA and generally just tweak code I find, however I'm struggling with this one.
I have a table with 3 different date columns (Date1, Date2, Date3), and a 4th (DateDiff) which calculates the difference in months between Date1 and Date3. I'm trying to get a code to search the DateDiff column for the value being 6, when found I'm then wanting it copy date2 to date1, date 3 to date2, and clear date3 of the relevant row. Then loop through the rest of the table.
In my head I'm thinking table to an array, and then some sort of find.replace, however I just can't get my head round it.
Thanks in advance for your help!