python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - excel-r1c1-notation

Double click a cell in a table and filter another table based on R1C2

I'm trying to create a small table that you can double click on any cell and filter a second table based on the values in row 1 (AYEAR) and column B (AMONTH) to return the breakdown of the total value...
test-img

Frinkenstein

excel

vba

double-click

excel-r1c1-notation

Votes: 0

Answers: 1

Latest Answer

It needs to always look at row 1 for AYEAR and column B for AMONTH no matter which cell I'm double clicking in... EG: If I double click in J9 it needs to look at J1 for AYEAR and B9 for AMONTH Simpl...
test-img

BigBen

Posts

Questions

Blogs

Jobs