Hi!
Im quite new into programming so i need some help with Building a macro.
What i need it to do is:
- Find the highest date in a row, lets say in row 3, column c-g (if all the cells are not empty)
- Then return the date in row 3, column j
- Then go the Next row (row 4) and the same columns as before and do the same.
- And so on.
- It is important that if the cells with the dates are empty, the macro should do nothing, cause there might already be a date in the cell where the macro should return the highest date.
- The macro should continue for all rows in the sheet.
Hope you can help me!
Let me know if you want to se the macro i already have made, but i dont think it will do anything good for you.
Thanks!
Bookmarks