Hello,
I have a problem with the filter on merged cells
The idea is that when I choose the status "Test" from the column "A", the display must be such as that of the columns K:L
Do you have any idea?
I attach the sample file.
Regards,
Claudiu
Hello,
I have a problem with the filter on merged cells
The idea is that when I choose the status "Test" from the column "A", the display must be such as that of the columns K:L
Do you have any idea?
I attach the sample file.
Regards,
Claudiu
You cannot do that with merged cells.. You will have to unmerge column A, have Test or Closed in all individual cells, then apply filter.
If you want to see Test or Closed only once for 3 rows, then format it with a white font to make it invisible.
See the file attached.
Cheers!
Deep Dave
Hello,
thanks for the fast answer, but i forgot to mention that the column A has a data validation behind with those two elements (plus others in the original file).
i heard it can be done with some VBA code, but i'm not very familiarized with that
I reattach the correct file.
Thanks,
Claudiu.
Hi,
I am sorry but I don't know of a way that can be done with VBA. Even if I use VBA, I would essentially doing something similar to what I did in the file attached.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks