Macro to unhide & hide rows based on column value

Hello.

I would like a buttonclick macro that hides & unhides rows based on cellvalue A2 and col B values.
This is to use for a sheet I update on a weekly basis, which is supposed to show the last 9 weeks and the current week.

So when I click the button I need it to hide the last week and unhide the current week, keeping my span of 9 weeks.

Picture:

Hi and welcome to the forum

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome (manually entered is ok) and how you arrived at that. (Exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you. Also, not all members can upload picture files (Company firewalls, etc.)

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Originally Posted by alansidman

Picture:

Hi and welcome to the forum

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome (manually entered is ok) and how you arrived at that. (Exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you. Also, not all members can upload picture files (Company firewalls, etc.)

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Sorry 'bout that, edited and attached my data.

Need a little bit more information. In the current set up, which rows should be hidden and which ones visible. I don't understand which nine weeks should be visible but last weeks should be hidden. Confused.

Originally Posted by alansidman

Need a little bit more information. In the current set up, which rows should be hidden and which ones visible. I don't understand which nine weeks should be visible but last weeks should be hidden. Confused.

The value in A2 represents week 5 2014, hence 405, this value is updated manually each week.
I want the macro to hide everything (from row 7 and down) >405 in column B and anything more then 9 weeks back from todays week in column B... if that makes any sense..

With current setup, rows 1 to 6 and rows 54 to 63 would be visible.
Next week I want rows 1 to 6 and rows 55 to 64 to be visible.
The week after that rows 1 to 6 and rows 56 to 65..
etc..

I got it partially completed. Need to figure out how to get the current 9 weeks visible. Because you change your week numbering at the start of the year, it gets a little more difficult. If you kept the weeks continuous and not change at the end of the year, the current macro would work.

Please Login or Register  to view this content.

Am going to seek some additional help on this. Watch for an update.

Yeah, Strange.

Any way, I gave you another macro to unhide all cells.

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Originally Posted by Saradindu

Uploading the file for necessary correction to the code.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread