I want sheet 2 cell b3 to update based on what is elect in sheet 1, this contains list of stores . and sheet2 is a dash board which is already built.
So if i click ona value in sheet 1, sheet 2 should show up with dash board based on selection in sheet1 . can someone suggest a suitable vba code
So if i click ona value in sheet 1, sheet 2 should show up with dash board based on selection in sheet1 . can someone suggest a suitable vba code
