Pete
06-24-2008, 02:50 AM
Hi Experts
Need to add macro to the grey macro button in the main worksheet "sheet 1 row 4 column B.
If the user click this macro button it alows the user to enter a new customer name which then is populated and entered into column B worksheet "Deal Selection" all new entries are add to the bottom i.e. row 13 onwards
I want to the new macro to look in column b worksheet "Sheet 1" and if the user try to enter the same name that alreay exist in column b worksheet "Sheet 1" then >
msg "This Client Name is already exists in the current list - cannot add duplicate name" and exit the step..
Need to add macro to the grey macro button in the main worksheet "sheet 1 row 4 column B.
If the user click this macro button it alows the user to enter a new customer name which then is populated and entered into column B worksheet "Deal Selection" all new entries are add to the bottom i.e. row 13 onwards
I want to the new macro to look in column b worksheet "Sheet 1" and if the user try to enter the same name that alreay exist in column b worksheet "Sheet 1" then >
msg "This Client Name is already exists in the current list - cannot add duplicate name" and exit the step..