Forum Discussion

RavinduEB's avatar
RavinduEB
Copper Contributor
Jan 07, 2025

Need to work macro to filter data in sheet two when click relevant code cell in sheet i

Hi,

i have two worksheets in the attached. I've highlighted the column "review Code" and it's unique for both sheets. 

can anyone help me to create a macro when I double click on the review code in the "Production plan" sheet simultaneously filter relevant data on the "Del Plan" worksheet and shift excel sheet to "Del Plan"

Resources