I have a template page that needs to read a line of data from another sheet, plug the data into appropriate cells and print a page and then move on to the next line of data and do the same thing.
In the past, I never had to do this with more than 2 or 3 sheets and I would just copy the template below the first template, and have a multi-page sheet where I would manually plug in the data myself, but now I need a sheet that reads a lot of data and prints a lot of sheets.
Is there a way to do this?
Bookmarks