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)
