Too many sheets is there a way to index them?

  • Thread starter Thread starter Karl_S
  • Start date Start date
K

Karl_S

I have a layout at the moment thats works well for up to
about 30-50 graphs but now have to do 200, in the same
spread sheet. currently the raw data is sorted
alphabeticaly over abiut 4 sheets and then colated in
another the data form the colated one is then graphed.
There are 200 graphs to be done, what i want to do is
create a sheet that is like an index and will allow me to
click look up a company and then click to go to its data
or graph. I think this would require a macro.

Any help would be much appreciated.(am using office 2000)
 
Depending on your version of Excel and your operating system
I think you may have a problem with 200 graphs and hyperlinks.
Be prepared to separate them into different workbooks.
If you have sheets that are related i.e. graph on one, and data
on another you would want to group them with the ctrl key
and then move them to another workbook with Edit,
move or copy. Specifically if you have Win 98, I think you
may have a problem, with Win 2000 or Win 2002 probably not.
 
Hard to say, but it sounds like you need one pivottable and pivotTable
graph. Then when the company is selected, the graph will show that company.

Regards,
Tom Ogilvy
 
Back
Top