Check the Data

[kannan1847]

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