Macro or VBA code to update non primary sheets based on checkbox

I want to run a macro or VBA to update seven different work sheets based on the seven different checkbox. I have the macro to transfer the data. The problem come in with the checkbox. The code updates no matter what. It updates on true and on false. I only want it to update on true. Each check box goes with its own subsheet. I attached the file. Final placement of things are not in place and things are visible that will be hidden.
Thanks JB

Hello

Welcome to the Forum!

The macro below should work after you have set sheet protection and locked cells etc. If not let me know if you have any problems. I have added the macro to your workbook and attached it to your button. The macro is in Module2.

I am guessing these logs are for gas chromatographs based on the GC prefix, column, and manufacturers.

Please Login or Register  to view this content.