Show and hide rows on command

**NMarien** · 02-07-2011, 08:24 AM

Dear all,

For a task-list I made in excel I use a dropdown where users can choose their name, and see their personal tasks verry easy. (As it sometimes happend that on one job Member 1 is a junior, and on the other job Member 1 is a senior, I didn't want to work with the filter-system)

I manage this true following code:

Please Login or Register  to view this content.

As I use my name 'Member 1', it displays exactly what I want; it hides all other lines.
But if I want to go back, and choose for another member's name, the script doesn't work.

Also when I want to show everyone's workload, I can't go back to this view...

The fault is probably in the 'Cells(RowCnt, 1)' code, but I don't know how I can solve this.
I managed to do this when I change at the beginning "EndRow = Range("B65536").End(xlUp).Row" into "EndRow = 1000", but I don't want that Excel is going to hide rows where there are no tasks in it (no content in column B).

Can anyone please help me?

Thank you all in advance.

Edit: Is there perhaps a more simple method as my code above? And this because I have about 30 - 40 members... Thanks!

**DonkeyOte** · 02-07-2011, 09:11 AM

To simplify - you should create a further column of data that concatenates Col F with Columns AM:AO

With this column you can then just apply a standard Auto Filter technique (via VBA) based on the concatenation - and trigger it when the DV selection is altered.

Obviously you can adapt the Select Case as necessary.

**NMarien** · 02-07-2011, 09:35 AM

Thanks!

How exactly does it works when I want to use names instead of numbers?
Let's say:

Siebert Marien
Piet Melis
Senne Pieters?

Thank you verry much in advance.

**DonkeyOte** · 02-07-2011, 12:08 PM

Perhaps you could post some examples that relate to the above ?

**NMarien** · 02-11-2011, 06:33 AM

Dear

please find attached of what I exactly mean...

This is just a simple overview, but the purpose is still the same. I've I would select my name (N Marien) I'll only see the rows for which I'm responsible.
All others rows should be hided than (untill the last row where there's data).

If I would select 'All members', all rows should be visible again.

I hope this is clear, and that you will learn me something. (it has been too long since I have studied some VBA, and I'm starting to need it more and more in my day-time job).

Thanks in advance,

Niels