Hello everyone
I have a macro which combines different projects into 1 workbook with each sheet representing a different project. The project name is in cell A1 , the project total expenses is in cell V19. Sometimes it happens that I download the same project twice at two different dates but I want to keep only the most recent update, hence the one with the most expenses.
I need a macro which goes through all the sheets in the workbook and when it finds 2 or more sheets with the same project name in cell A1, it compares the values in cell V19 and keeps the sheet with the highest value. Is it even possible to have a Macro which does this, I don't know where to start.
Thank you in advance
Bookmarks