Updating List from multiple worksheets with a button

**Eamster** · 04-30-2009, 01:14 PM

I have a question you guys may be able to solve. I am trying to make an easy way to access sheet music using excel. What I want excel to do is to ,with a push of a button, update the song list according to Artist and Song Name. Right now I have an excel spreadsheet that can, with a push of a button, make a list of the Sheet Names. Ideally what I would like to have is the spreadsheet update a list according to the Artist (say in cell A4 of all the sheets) and the Song Name (say in cell B4 of all the sheets). I have very little experience with VB and using Macros. So anything will help. The spreadsheet is attached.

Here is the code that is being used right now.

HTML Code:

**royUK** · 04-30-2009, 01:17 PM

What's the point of ll the empty sheets?

**Eamster** · 04-30-2009, 01:19 PM

They will eventually be filled with Lyrics, Chords, Tablature, etc.

**Eamster** · 04-30-2009, 06:38 PM

I would like the button to do essentially what the code I have posted is doing. Except I want it to list what is in cell C4 and D4 for each sheet and list it beside what the sheet number is. Hope that clears it up some.