I am sure i have seen it somewhere. I have a list of address details in a table. Each row is a different address: Name in Col A, st numbers and name in Col B, State in Col c, and ZIP/Post Code Col D. I have set up tiles for each address across the next page (to begin with). I will have to reformat this next page to get the grids onto a page efficiently for printing. Baby steps. How do i get each row of data (each address), into a label? The list of addresses is loooong so i want to be able to drag the labels across.
Say address table is on Sheet 1. and labels are on Sheet 2.
Labels
Say address table is on Sheet 1. and labels are on Sheet 2.
Name | Address1 | Suburb | State | Post Code |
Bill Johnson | 51 Blue St | Niceville | Victoria | 3133 |
Mary Mary | 17 Garden Grove | Nursery | New South Wales | 2000 |
Quite Contrary | 14 Streety Street | Horrorland | Queensland | 4364 |
Labels
Bill Johnson | Mary Mary | Quite Contrary | |||||
Address | 51 Blue St | Address | 17 Garden Grove | Address | 14 Streety Street | ||
Suburb | Niceville | Suburb | Nursery | Suburb | Horrorland | ||
State | Victoria | State | New South Wales | State | Queensland | ||
Post Code | 3133 | Post Code | 2000 | Post Code | 4364 | ||