jaymz69
asked on
Click on a cell and it opens on a sheet
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
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
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SiddharthRout
xover
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
