For example, if the names and addresses are on one sheet in calc. How do I iterate the list to add them to a blank form made with calc, with one cell for name and address, generating a form for each of the people?
Or is it possible?
For example, if the names and addresses are on one sheet in calc. How do I iterate the list to add them to a blank form made with calc, with one cell for name and address, generating a form for each of the people?
Or is it possible?
If names and addresses in same row in sheet named Address then enter something like the following and drag down =$Address.A2&" "&$Address.B2&" "&$Address.C2&" "&$Address.D2&" "&$Address.E2&" "&$Address.F2
. Help will have info on concatenate functions