User:Caileigholdroyd/Sandbox/Creating Pages in Excel

1. Find out what you want the pages to look like. Make a mock up in a sandbox or copy a version of a page you already like. 2. Find out the areas that you will need to be auto-filled (Page Titles, Town/County/Country/Jurisdictional Levels, Histories, etc) 3. Create a Google Form asking the areas you want in Step 2.
 * Here is an example of some you areas you might gather. 

4. Click "View in Sheets" on the Google Form under "Responses" to create or view where the gathered information will go. 5. Create some extra columns to concatenate and create references, page names, and the page code. 6. Begin concatenating the gathered data. To learn a little about concatenate, watch this video.

Whole Page Code
Here is an example of how it might look in one cell:

=CONCATENATE("

Guía para la investigación genealógica del Muncipio de ",F37,": registros de nacimiento, matrimonios, defunciones, censos, registros parroquiales y registros militares.

Historia
",G37,AQ37,"

Cementerios
",H37,"

Citas
",F37,", ",E37,", ",D37,", ",C37,", ",B37,", Spain Genealogy ")

As you can see, the letter number combinations are the cells that you gathered the information from.

Reference Code
=CONCATENATE(" ")

Page Name
=CONCATENATE(F37,", ",E37,", ",D37,", ",C37,", ",B37," - Genealogía")