I have an excel file which contains two worksheets. The first worksheet has a column called ID and a field called Status. If there is an ID on this worksheet (Sheet1) and the Status = "Done" then I want the ID field on Sheet 2 which for the same ID to be updated to a 1 in order to count the total number done. Sheet 2 contains all of the ID's which could potentially be upwards of 20k but sheet 1 only has the done id's which will be added to on a daily basis.
If I could get this to update automatically that would be great although I don't know the best way to go. Thank you.