I created a template spreadsheet for capturing exported data from a CMM. The template the tab named Summary. Every time my inspectors export the data from CMM the data is populated on the spreadsheet and automatically creates another tab named Summary (1), then Summary (2), Summary (3) and so on every time the data is exported. I want the active spreadsheet/tab (e.g., Summary (3)) to print automatically when Cell B5 contains the word "FA" (First Article). What macro code can you recommend?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Macro to print a sheet based on cell value
- Thread starter jacs_b1
- Start date
