Hi all,
Attached a sample file of the table.
when the user selects a certain cell within the table (table name: "Table1") then I want to have the values of the cells in column D and E (of the selected row) shown in D1 and E1.
So the value of D1 and E1 constantly changes depending on the row that is selected. It should not matter which cell is selected. E.g. when A10 is selected, then D10 and E10 should be used.
I am thinking of using something like the "intersect" function. However, I do not really know how this works in vba and IF it will work.
Next step is that I use that value to run a Filter macro from the Ribbon. But first I need to get the correct values ;-)
This should run on Excel 2010, 2013 and 2016.
Thanks,
Daniel
Bookmarks