<div>
<div class="content wysiwyg-content">
I want to have my master sheet open<br />
If I click on a cell it needs to open another sheet for that cell so I can enter details there.<br />
<br />
So every row on the master sheet is a product<br />
When I click on the product or particular cell<br />
it will open the details sheet for that product.<br />
<br />
I can have 50 products so that means 50 detail sheets.<br />
<br />
Unlees there is another way.<br />
<br />
Thanks
</div>
</div>


I want to have my master sheet open
If I click on a cell it needs to open another sheet for that cell so I can enter details there.

So every row on the master sheet is a product
When I click on the product or particular cell
it will open the details sheet for that product.

I can have 50 products so that means 50 detail sheets.

Unlees there is another way.

Thanks

Click on a cell and it opens on a sheet

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.