Hi all, I have taken over a members list that goes back to 2007. I added a new sheet for 2022 but when I try to fillter the sheet I can only filter up to 2021, how do I add the year 2022 to the filter?????
Regards
Dave
Hi all, I have taken over a members list that goes back to 2007. I added a new sheet for 2022 but when I try to fillter the sheet I can only filter up to 2021, how do I add the year 2022 to the filter?????
Regards
Dave
Last edited by davepyrah; 02-08-2022 at 10:49 PM.
I'm just guessing because your question is somewhat vague and you haven't uploaded a sample workbook, so I'm guessing that you added the year somewhere in a column that you have applied a filter to? If that is true and you have a gap between the last row with 2021, then a space, then 2022 begins, filters look down until the end of the column to the last row so if there is a gap of a row or more it will not show 2022. If that is your issue, remove the gap. If not a better explanation AND a sample workbook would go a long way to removing any confusion.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however the thread title "year not added" does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
Hi Sam, Not sure I can upload a sample workbook as I down load the current mem list from sharepoint. I have to copy and paste into my own worksheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks