Check Column Data with Master and Show message

**kannan1847** · 11-27-2018, 10:14 AM

Dear members,

I have two sheets in a work book

sheet 1 A column -Master which contain

Country Name
America
Japan
Russia

in Sheet 2 A column details to be entered by data entry (More than 30000 Rows)

country name
Russia
Korea
Japan

while entering data in sheet 2 -country name apart from sheet 1 A column master (Example korea ) or Left blank

VBA required warning message -your entering wrong country name-

note:data validation not working because user may paste data.

**Bernie Deitrick** · 11-27-2018, 12:07 PM

1) Copy this code.
2) Right-Click the sheet tab of interest (your Sheet 2).
3) Select "View Code"
4) Paste the code into the window that appears.
5) Save the file as a macro-enabled .xlsm file.
6) Make changes as needed

Please Login or Register  to view this content.

Check Column Data with Master and Show message

LinkBack

Thread Tools

Rate This Thread

Display

Check Column Data with Master and Show message

Re: Check Column Data with Master and Show message

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA to master check in two column if criteria met give remarks in F

[SOLVED] VBA code to show Warning Message Box popup if certain text is found in column

Macro required for Check Data with Master

Check Data with master

Data Entry check by Master sheet

Copy data from multiple workbooks and check for dupes before pasting to master?

check column for value and show message box

Bookmarks

Bookmarks

Posting Permissions