Hi
i not got a clue how to do this,,,totally lost
Need a macro that will tell the user if they try and enter the same demand customer name that already exits in any worksheet that is visible in the workbook.......
i.e. a message box. "Demand Customer is already included in the selected worksheet cannot add again" - warning message box.......
if it is a new demand customer then proceed as normal...
please find attached the workbook.....