Re: action based on cell selection

Subodh_Tiwari_sktneer 

Hi Subodh,

A question on related. For each Stock, date range is fixed by Cells Z2 and Z3 (see screenshot).
What if I want to have the range set per Stock, as indicated by Buy and Sell column.

So,
if i navigate to APPLE, date range shows Closing price from 1/9/2021 (Cell G3) to 6/7/2023 (Cell H3)
Subsequently,
if i navigate to TESLA, date range shows Closing price from 6/5/2022 (Cell G5) to 8/8/2023 (Cell H5)

How would Sheet Module Code need to look (if at all possible 😲)
Thank you!