• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

want to view the data weekwise

Hi,

I have the data here in the attached file and want to view the data in such a way that if i select the week number i should get the details of all the users, processes. Have tried to pivot table but couldn't succeeded. could you please assist me on the same.
Thanks.
 

Attachments

  • critical users.xlsx
    171.1 KB · Views: 5
Hi Santosh,

I think it will be easily filter if you create a column with values wk 1, wk 2, wk 3...etc

Filter week.PNG

I have done it for 3 weeks only.
See the attached.

Regards,
 

Attachments

  • critical users.xlsx
    189.9 KB · Views: 3
@santoshbhagade
Something like this ...
> as You wrote 'Select week number' within Range("Q1:BP")
> "ReSet" -> 'Select any cell within range("A1:D1")
 

Attachments

  • critical users.xlsb
    63.5 KB · Views: 3
Hi,

I have the data here in the attached file and want to view the data in such a way that if i select the week number i should get the details of all the users, processes. Have tried to pivot table but couldn't succeeded. could you please assist me on the same.
Thanks.
A note of caution ...
Sanitize your worksheet - it contains information that probably should not be in the public domain ...
 
Back
Top