Check entry in Excel column if data is in the same row of a different column with VBA

Code would be one way to do this, but if you are pasting a block of data why not use conditional formatting (CF)? You could set up a CF to highlight cells in B and I a particular colour (RED?) if I has data and B does not.

Code wise, an entry by entry code would look something like this;

Please Login or Register  to view this content.

This could not be used after pasting however as it would generate an error - it only looks at a single row.

A code to run after pasting would have to be manually run an look like;

Please Login or Register  to view this content.

Hello stanlelma,

Copy and paste this macro into the worksheet where your data is/

Right Click the Tab
Select View Code...
Paste the macro with CTRL+V

Please Login or Register  to view this content.

Thanks again,
The code worked perfectly.

However I have a new problem. I now have the two Sub Worksheet Change sets of code on the same worksheet.
How do I combine these so that both work?

Please Login or Register  to view this content.

It would probably be easiest to put them both in a module with unique names and under change your Worksheet_Change event to:

Please Login or Register  to view this content.

Please don't forget to use code tags around your code in posts.

In the Visual Basic Editor (VBE) right click VBAProject in the project window and select add module. Double click the new module and paste this in the new module:

Please Login or Register  to view this content.

Then double click sheet one and your worksheet_change event will be:

Please Login or Register  to view this content.

Are you sure you need/want to run two separate loops every time you change your workbook?

Can you attach your workbook?

stanlelma,

My mistake. You need to remove Private from:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Book1.xlsm


Please refer to the code for sheet1 and module 1 in this example.

Where did you get this:

Please Login or Register  to view this content.