Forum

Notifications
Clear all

cell click filter data another sheet

2 Posts
2 Users
0 Reactions
55 Views
(@roya23)
Posts: 1
New Member
Topic starter
 

hello,

how are you

i have a two sheet , and data similar (see the attach file)

when click cell data(for example click apple) -> filter sheet two all date value apple

please see the attached file and help me to resolve problem

thanks

 
Posted : 01/02/2019 3:08 am
(@mynda)
Posts: 4761
Member Admin
 

Hi David,

There's no built in way to do exactly what you want. Your options are to use Slicers with an Excel Table, or write some VBA that executes on selection of a cell.

Mynda

 
Posted : 02/02/2019 3:09 am
Share: