I have a project that has a super tight deadline... must be completed by October 30th at 9am Eastern Standard Time.
Here's what we need:
We have an excel spreadsheet that has information currently in rows... data entry only, no formulas. I think we need two VBA scripts or excel marcros for Office for Mac 2011
Macro 1:
This macro needs to create a new sheet for each row. Each of those sheets need to contain referenced cells that update as the original sheet is modified. The new sheets will be formatted to print on two 8.5x11 pieces of paper. I've created a template for the new sheet, and also of course have the original sheet with data.
This macro should have an error check to see if a row has a sheet created for it already, and if it does, move to the next... if it doesn't, then create new sheet.
Macro 2:
From there, we need a second marco that turns all of the sheets created into a large, single PDF.
Thats it.
Thx.