ilyaskazi
05-20-2005, 07:44 PM
Workbook contain sheets as...
FARES1, FARES2, RULES1, CONDITIONS1, RULES2, CONDITIONS2, SHEET_X, ROUTING1, ROUTING1 (2)
FARES1 matches FARES2, RULES1 matches RULES2, CONDITIONS1 matches CONDITIONS2. Rest other sheets are non-matching sheets, which need to be deleted without prompt.
note: sheet may contain any names and in any nos.
msgbox=deleted sheet names and numbers of deleted sheet.
FARES1, FARES2, RULES1, CONDITIONS1, RULES2, CONDITIONS2, SHEET_X, ROUTING1, ROUTING1 (2)
FARES1 matches FARES2, RULES1 matches RULES2, CONDITIONS1 matches CONDITIONS2. Rest other sheets are non-matching sheets, which need to be deleted without prompt.
note: sheet may contain any names and in any nos.
msgbox=deleted sheet names and numbers of deleted sheet.