I have a VERY basic understanding of Excel. I have tried watching tutorials to figure this out and have just pulled out a lot of hair. Here is what I want to do. I already have a sheet that has these column headings: Song Title / Perfered Key / Alternate Keys / Dates Sung / Song Number / Tempo / Key Words.
I have filled in the data for several hundred songs. What I would like would be the ability to have the tab to the next sheet that would be called "Key" and have all the same data only sorted by the data in the "Perfered Key" column. And then yet another sheet that would show only the songs that have a number in the "Number" column (they don't all have a number).
Also, I would love to be able to make a change or add a song on any of the sheets and have it show up everywhere. For example, if I was on the page that had them sorted by "Key" and I changed a song that was in "G" to "A" then that change would be on all the other places that song showed up. And I added a whole new song and all it's data when I was on the "Song Number" page it would be added everywhere.
So basically I want all of the data for each song to show up on all the different tabs (sheets) only sorted or filtered in various ways. And if I change or add anything, anywhere, it is changed globally.
Also, as a bonus - I would love to be able to have a sheet where I could type in a keyword and any song that has that keyword would show up along with all the data fields that go with it (key, date sung, etc)
If this is too much for a newbie like myself I am also open to suggestions as to where I could pay someone to set the whole thing up and I can just enter data.
Thank you!
Steve
I have filled in the data for several hundred songs. What I would like would be the ability to have the tab to the next sheet that would be called "Key" and have all the same data only sorted by the data in the "Perfered Key" column. And then yet another sheet that would show only the songs that have a number in the "Number" column (they don't all have a number).
Also, I would love to be able to make a change or add a song on any of the sheets and have it show up everywhere. For example, if I was on the page that had them sorted by "Key" and I changed a song that was in "G" to "A" then that change would be on all the other places that song showed up. And I added a whole new song and all it's data when I was on the "Song Number" page it would be added everywhere.
So basically I want all of the data for each song to show up on all the different tabs (sheets) only sorted or filtered in various ways. And if I change or add anything, anywhere, it is changed globally.
Also, as a bonus - I would love to be able to have a sheet where I could type in a keyword and any song that has that keyword would show up along with all the data fields that go with it (key, date sung, etc)
If this is too much for a newbie like myself I am also open to suggestions as to where I could pay someone to set the whole thing up and I can just enter data.
Thank you!
Steve