Go through each sheet and check a certain Cell value before running code...

Hi,

I'm trying to change the code below (Thanks to NeedforExcel).

This code goes through all rows of each sheet (Except "Master" sheet), matching the numbers (column "B") of each sheet to the numbers (Column "B") of the "Master" sheet. When a number has a "X" mark in Column "D" in a sheet, the code will place a "X" mark behind the corresponding number in the corresponding column in the "master" sheet.

Please Login or Register  to view this content.

What I would like to do now is, once a person has updated the list by clicking the button, cell "E1" of each existing sheet will get the value "UPDATED" (except Master sheet..Sheet1)
After, when new sheets with data are added, the code will go through all sheets (including existing sheets) and check if cell "E1" contains empty or UPDATED. When it's UPDATED, the code can go straight to the next sheet and doesn't have to retrieve any data from that sheet anymore. If cell "E1" is empty the code should Match the numbers and retrieve the "X" marks.

Hope I made myself clear enough
Any suggestions?

Thank you so much John for the speedy reply.

The code works great...even on Mac
P.S. I looked it up..Atwood lake looks like a great place to live.