Display current week's data only on multiple worksheets

[Mista_sav]

I have about 13 sheets and would love to have a VBA that will only show the current weeks worth of data on each sheet

On a side note, can i still access the previous weeks data by manual filtering? Date is in column A BTW

Thanks in Advance gurus!

[6StringJazzer]

I would suggest that you use VBA to use Autofilter, which can also be used manually. If you attach your actual file we can provide the code that will work with your file. See yellow banner at the top of the page.

[Mista_sav]

I think its uploaded now. So essentially it would only apply to all the sheets except branch results and branch network results

[6StringJazzer]

How do you define a week? Mon-Sun or Sun-Sat?

[6StringJazzer]

Here is a version that treats Monday as the first day of the week. To change to a different date change the following line of code to any other day of the week:

Please Login or Register  to view this content.

I did not put any controls on a worksheet to run the macro. You can run it from the macros list by calling FilterAllSheetsForThisWeek.

[Mista_sav]

Thank you so much, who do i add the macro button?

[Mista_sav]

Here is a version that treats Monday as the first day of the week. To change to a different date change the following line of code to any other day of the week:

Please Login or Register  to view this content.

I did not put any controls on a worksheet to run the macro. You can run it from the macros list by calling FilterAllSheetsForThisWeek.

Sorry i did get the button to work

The only thing though is it filters out the current week as well.

For example if i put in todays date, and hit the button it will clear the current weeks data. Can i have it so it will keep the current weeks worth on screen?

Say for example as soon as i put in something next monday, and hit clear, all of this weeks data will filter out.

[6StringJazzer]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

[Mista_sav]

Apologies - active thread here mrexcel.com/board/threads/is-it-possible-for-worksheet-to-display-current-weeks-data-only.1199694/#post-5855252[/url]

but i cant get this to work. I also did one on redit but i forgot my log in so cant get in to get the link.

The sheet attached when i went in and added data and hit filter it took away the current week and grouped all the rows up to row 20

[Mista_sav]

Was this sufficient enough to continue?

[6StringJazzer]

Yes. I built a solution that should work, and if you find it's not working then I would request that you provide a file with more complete data for testing.