|re: "If there's any way to set it up to do the macro automatically, and update the records on the other sheets, that would be fantastic."|
I think it could be done automatically, but I still need to know more about your process. Keep in mind that VBA (a macro) can't think on its own, it can only follow a step-by-step set of instructions.
For example, a simple, brute force process could be to wipe all of the individual sheets clean and recreate them all each time a change (any change) is made to the Master. That works, but it is inefficient.
A more elegant solution is to search for the Master record that was changed and only update that record on the separate sheet, perhaps by copying the entire row for the record that was changed. The question then becomes "When is that update made?" After any change to that record? Only after a specific cell in that row is changed? When a button is clicked after all changes are made? Your process and requirements are the answer to the "When is that update made?" question.
What about adding new records? Can that happen? If so, the code would need to know if the record was new (therefore add a row to the correct sheet) or existing (therefore find the existing record and update it). It’s obviously easier if there are never any new records since the code only has to deal with finding existing records, not adding any new ones.
All of this can (probably) be dealt with, but since the code needs to be told what to do, we need to be told the detail behind the process. Don’t be surprised if I keep asking for more details as I try to come with a solution. At some point, it might even be helpful if a copy of the workbook is uploaded to a site such as zippyshare.com so that we are not guessing as to the exact layout of your workbook.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.