Hello,
I work in a QA office for a large bakery and am looking for help in how to save some time. We have all our formulas stored in Excel which is handy but we are not using it to its full effectiveness. For each batch of product we make we need to print out a formula and manually write in who printed it and what number this is out of how many batches. So if we were running 4 batches of formula 00001 then we would write batch 1 of 4, batch 2 of 4, etc. We tried using sheet protection and changing each sheet before it was printed but it was quicker to just print out the papers and write them down by hand than it was to change the number then print the formula sheet.
So what I want to do is have a separate workbook that I can open with 2 fields to fill out. One field for name and the other for how many formula sheets we need. For instance if we are running formula 00001 for 12 batches I want to type in QA Lead for name and 12 then press a button and have it print out 12 sheets. Each sheet will have Printed by QA Lead and number 1 of 12 all the way to number 12 of 12. The way our formulas are stored is in one big Excel workbook and then each formula is its own tab. With each tab named after that formula.
Attached for reference is a book called Example.xlsx that has 3 formulas 0001, 0002, 0003 with each having a spot for printed by and number x of y.
The help I need is is there any place to get started in how to do this? I want this to be as simple as possible for just a one button push since most of my employees are not that computer literate.
Thank you,
Bookmarks