Hello there,

I am not super computer savvy, but I know that excel can do what I need it to do. I have to create a list of events on a calendar. Each venue has a different number of events. For example, Bob's Crab Shack will have 3 shows. One on May 1, May 2nd and May 3rd. Angie's Pizza Bar will have 2 shows. One on May 15th, and one on June 1st.

So, my table would look like:

Venue Date of Events Artists
Bob's Crab Shack May 1 Billy and the Kids
Bob's Crab Shack May 2 QALOUS
Bob's Crab Shack May 3 Orion's Belt
Angie's Pizza Bar May 15 Phyllis's Philharmonic
Angie's Pizza Bar June 1 Tiny Dance Brigade


My Word document would look like this:

Fun events are always happening at <<Venue>>
Take a look at the next show dates
<<Artists>> <<Date_of_Events>>
<<Artists>> <<Date_of_Events>>
<<Artists>> <<Date_of_Events>>

What I want Word to do is understand, as long as the Venue name doesn't change is should populate the "artists" and "date of events." However, when the Venue name changes it should use the data associated with the next record of Venue name.

I know that there is a next record command, but it doesn't seem specific enough. I have also read a little about "key" insert fields, but my eyes glaze over when coding is involved.

Thank you in advance for taking the time to read this. I really appreciate it.