ertan
07-20-2005, 02:49 AM
Need help for daily rutin task
On my workbook Sheet2 contains variable number of rows and columns of data.
Data titles on column A and data itself expands to other columns.
What I would like to achive is:
Create a index page for those titles (first occurance) with hyperlinks which will take me to beginning of the related data.
(Or Perhaps List those Titles at the top of the shhet starting from a2 - b2 -c2 etc.. And hyperlink them to proper locations)
Problems:
Title's and data constanly changes.
There are duplicate repeating titles ..(which they are should be there) because they are continuation of data
There are blank rows between titles.
Most of the titles are not suitable name creation.(have space , underscore etc)
Any help will save a lot of time doing those rutines
Regards
PS Attached sample data .
On my workbook Sheet2 contains variable number of rows and columns of data.
Data titles on column A and data itself expands to other columns.
What I would like to achive is:
Create a index page for those titles (first occurance) with hyperlinks which will take me to beginning of the related data.
(Or Perhaps List those Titles at the top of the shhet starting from a2 - b2 -c2 etc.. And hyperlink them to proper locations)
Problems:
Title's and data constanly changes.
There are duplicate repeating titles ..(which they are should be there) because they are continuation of data
There are blank rows between titles.
Most of the titles are not suitable name creation.(have space , underscore etc)
Any help will save a lot of time doing those rutines
Regards
PS Attached sample data .