So we have a spreadsheet that reports back each locations activity for the month. This information has been subtotaled, and we can insert page breaks at each group but we need to also include the location number and name (which is the second row's cells (A & B) where the new page would start.
So the first sheet would have the standard header info (obtained by the use of use header blah blah blah) but under that the first page should say "101 Region One"; page 2 would have "104 Region Four" and so on and so forth.
I'm thinking a macro would be the best course of action but I am not that savvy enough yet to work it out on my own.
Bookmarks