bbbuffalo
Board Regular
- Joined
- Apr 14, 2006
- Messages
- 53
I have a workbook for keeping track of songs in my CD collection.
The columns are Song Title, Artist, Category 1, Category 2.
So 4 main columns.
I also have another category (lets just call it Grouping) that has about 36 different "groupings" which would be similar to genre (Top Songs of the 80's, Top Country, Dance Songs, etc)
I have a separate sheet for each of those groupings.
I want to have 1-click hyperlinks at the top of each page that will take me to each sheet.
So here's my problem:
Across the top I need 3 rows of 12 columns. Each cell will link to a page in the sheet. I know how to do that.
But below I want to only have 4 columns.
I can do this using merge and center but I've been told this isn't the best way to do it. Do you have any other suggestions?
It will end up looking something like this
Link1 Link2 Link3 Link4 Link5 Link6 Link7 Link8 Link9 Link10 Link11 Link12
*****Song***** *****Artist***** ****Category1**** *****Category 2*****
The columns are Song Title, Artist, Category 1, Category 2.
So 4 main columns.
I also have another category (lets just call it Grouping) that has about 36 different "groupings" which would be similar to genre (Top Songs of the 80's, Top Country, Dance Songs, etc)
I have a separate sheet for each of those groupings.
I want to have 1-click hyperlinks at the top of each page that will take me to each sheet.
So here's my problem:
Across the top I need 3 rows of 12 columns. Each cell will link to a page in the sheet. I know how to do that.
But below I want to only have 4 columns.
I can do this using merge and center but I've been told this isn't the best way to do it. Do you have any other suggestions?
It will end up looking something like this
Link1 Link2 Link3 Link4 Link5 Link6 Link7 Link8 Link9 Link10 Link11 Link12
*****Song***** *****Artist***** ****Category1**** *****Category 2*****