I have a spreadsheet that comes out every day that has new data on it.
There is some header data in the first 4 rows and spanning about 30 columns, that I want repeated on each newly created spreadsheet. The bottom line is a sum line for the numbers, which also must be repeated.
Columns A and B are mostly static and do not change day to day. Column A is who an account belongs to and Column B is the name of the account. Columns C and following report unique data for that account (how many tests yesterday, how many this month, how many this quarter, etc) One person can have several accounts, but one account is only tied to one person.
Every week I send every Person their own spreadsheet. Which means I have to break out the data with a whole bunch of copying and pasting into new spreadsheets, naming each spreadsheet by a set date and then their name. Example: "2013-11-18 - Person [url removed, login to view]”
I would like a vba program to generate each person’s excel spreadsheet (with proper heading rows and columns) and place it into the same folder the existing folder currently resides in.
I'd also like it to format the each spreadsheet to print similar to the attached file. (one or 2 printed pages per person)
Each week I create a new folder based on the date: So the attached spreadsheet would go in the “2013-11-12” Folder.
I then email out each of the spreadsheets using Apple Mail.
Included is a sample file.
I'm using Excel for Mac 2011 version 14.2.5