I have an Excel Document (attached) where I have 2 tabs (Names and Songs)
I want to pull the data from Excel when I open Word with VBA.
I have a sample Word Document attached of how I want it to look, can someone please give me an example?
This will be a lot more complex after said and done, though I need a kick start and think I can handle it form there.
Note the names are on 3 separate pages and the songs are all on 1.