Quote Originally Posted by Palmetto View Post
You could use:

2. Advanced filter with criteria, using the option to copy to another location ***
Thanks! I did a bit of research on Advance Filters and was able to figure this out. I now have a new tool to use in the future!

Now for a follow up question. Is there anyway to make this filter auto update? What I mean is as a user of the spreadsheet, when I update my time spent on projects, or on new projects, do I have to run the filter to see the data updated? Or is there anyway to automate this?

Thanks again,
Ryan