Dear members,
I am have excel contains two sheets
Input sheet where users to be Type or copy paste data
Master sheet is the base sheet
My requirement is the user can enter data only which is available in master data,
1.they cannot enter date after given date of range and given region or given Manager
2. data entered in column "A" should be date format,in column "E" to "G" numbers format only
kindly give vba button for highlight wrongly given data
kindly do the needful
Bookmarks