I have a workbook with various worksheets that get saved in different combinations. I have a series of buttons that are clicked to save those different combinations. I need to add a step that prevents the save from happening if certain cells across the worksheets don't match.
Here is one example button:
I need to make sure the following cells match before the save occurs:Please Login or Register to view this content.
Sheet 44 (Canine Wellness) "C3"
Sheet 30 (VitD New) - "D3"
Sheet 39 (Canine B12) "D3"
If they match, save as written above, if not, no save with error message "IDs Don't Match"
Thank you!
Bookmarks