Hi All,
I have a first sheet which is having component list. and in other related sheets for that components different data is present. (Also note that the component in the component list is may be repeated in others sheets.) I want to select components from first sheets and delete the data from other sheets which componetns are not selected from the first sheet.
For reference please find attached excels sheet
Bookmarks