Compare two sheets based on master sheet in VBA

R

rajraj987654

New Member
Joined
May 28, 2019
Messages
1
Hello All

I have an issue, where in I have a master-sheet say sheet 2, in sheet 1 if I enter any data not available in sheet 2, sheet 1 data cell change color to red. Basically we want to restrict Sheet 1 based on the values of sheet 2, only sheet 2 values should come in sheet 1. Currently I have created a dropdown list which is not effective

Many thanks
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
You must log in or register to reply here.

Similar threads

A
  • Question
Macro to move certain columns to new sheet based on status (ie; "done")
Replies
4
Views
88
GK039
G
Kaz09
  • Question
Copy rows from multiple sheets based on data
Replies
1
Views
220
Fluff
Fluff
H
  • Question
Multiple Reports Master Sheet Question
Replies
7
Views
79
awoohaw
awoohaw
H
  • Question
Update master sheet automatically when changes are made to split sheet VBA
Replies
0
Views
356
helplessnoobatexcel
H
J
  • Question
Moving Data to Another Sheet Based on Dropdown Selection
2 3
Replies
27
Views
1K
t0ny84
T

Forum statistics

Threads
1,216,095
Messages
6,128,795
Members
449,468
Latest member
AGreen17

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top