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. 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.Įvery week I send every Person their own spreadsheet. Column A is who an account belongs to and Column B is the name of the account. The bottom line is a sum line for the numbers, which also must be repeated.Ĭolumns A and B are mostly static and do not change day to day.
There is some header data in the first 4 rows and spanning about 30 columns, that I want repeated on each newly created spreadsheet. I have a spreadsheet that comes out every day that has new data on it.
0 kommentar(er)
