Hi,
I'm really hoping for some help. Usually I don't have to use excel but at the moment I'm being given a lot of databases and spreadsheets to set up, which I have always managed to figure out. This problem seems to be way too complicated for my minimum knowledge.
I have a workbook with various different sheets, which all have the same basic set up. Column E in every sheet is a drop down box with the options Outstanding, In Progress and Completed. What I need is for any row that has Outstanding or In Progress selected to be automatically copied onto my Summary sheet (preferably with an extra column to say which sheet the row is from. Though if this can't be done it's fine.)
Also I would like for when an action is 'Completed' it is removed from the summary sheet.
Am I asking for too much? Can this be done? Thank you in advance for any help or advise you give.
Bookmarks