vijay.vizzu
Member
Dear All,
Recently i got a problem that, i have an workbook with around 14 sheets, now i want to make a rule like in any one of the sheet (assume sheet5 current) if i putting a number in a cell, it should check the entire workbook, that entered number exist or not. If exist, then it should display error message like "Number already exists in sheetname", if not it should accept that number. I can do this through data validation but it can only that current sheet only not on all worksheets. So please help me to resolve this problem
I hope you all understand my problem
Thanks & regards
Vijay
Recently i got a problem that, i have an workbook with around 14 sheets, now i want to make a rule like in any one of the sheet (assume sheet5 current) if i putting a number in a cell, it should check the entire workbook, that entered number exist or not. If exist, then it should display error message like "Number already exists in sheetname", if not it should accept that number. I can do this through data validation but it can only that current sheet only not on all worksheets. So please help me to resolve this problem
I hope you all understand my problem
Thanks & regards
Vijay