My quick and easy solution for that is to clear the cells by typing a space in the first (A2) cell of "List", then fill that cell down to the bottom of the list. OFFSET will return a zero for an empty cell, so the 'extra cells in "List" cannot be left empty without wasting a label on each of them. No check is made to see if the last name on the list has been printed. IF it is not, the third part ( "" ) inserts a null string into the space for which there is no label. IF it is, then the second part (OFFSET…) inserts the name for the label at that position. The first part of the IF statement checks that the current cell is beyond the already used count in Skip::A2. The 4 column by 20 row table's style is "Plain," containing 0 header rows and 0 header columns. As can be seen in the example, the first name on the list is in the last cell (on the fourth row) of the page. Sheet 2 contains the table used to print the labels. Because I need to print a few of these labels at a time, I added a second table, "Skip," to record how many labels had already been used on the current label sheet. The list of names is pasted into "List," the single column table on the left. It consists of two sheets containing three tables.
I use a Numbers '09 document I created to print names on an 80 label/page Avery sheet.
0 kommentar(er)
