Summary Excel sheet

Asus Eee pc 1005ha blue netbook
June 28, 2010 at 23:11:09
Specs: Windows XP Pro, 2096
Hello everyone,

Maybe a simple problem but I'm jus wondering how to create an Excel sheet being the summary for some number (less than 20) of projects we do in our company looking just like a matrix e.g. 4rows x 5columns and having the names of projects in the cells.
But by clicking on particular cell (=clicking on name of project) the display would switch to another page where I would have all the details concerning the project (e.g. sketch of the product, and some other information like tooling cost, start of production date, annual volumes etc....).

In other words the names of projects would be the just the links to pages with more detailed information.

Thank you guys in advance for your ideas!


See More: Summary Excel sheet

Report •

June 29, 2010 at 01:49:09
After you enter the name of a project in a cell, right click the cell.

Choose Hyperlink

Choose "Place in this Document"

Click the Sheet name for that project

Enter a cell reference (or leave A1 as the default)

Click OK

If you have any Defined names in the workbook, the list will appear in that same dialog box and you can choose that instead of a Sheet/Cell reference.

Hope that helps.

Report •

June 29, 2010 at 04:32:43
DerbyDad, I'm really much obliged for your constant help!

Have a nice day.



Report •

Related Solutions

Ask Question