Gabriela has attended:
Excel Intermediate course
Excel Advanced course
Excel for Finance Professionals course
PowerPoint Intermediate Advanced course
Index sheet linked to Input or Calculation or Output sheet
I want to create an index in the first sheet of my worksheet to take me directly to different sheets in my worksheet . How do I link the cell/text from the index sheet to the same text=title of a sheet . Thank you
RE: Index sheet linked to Input or Calculation or Output sheet
Hi Gabriela,
Thank you for the forum question.
You can do it by creating hyperlinks.
Right click on the cell with the text on your index sheet. Click Hyperlink the last option on the list. Select the option "Place in this document" and select the sheet name to the right.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Index sheet linked to Input or Calculation or Output sheet
Thank you Jena .
I have another question if possible . I m trying to copy and paste the values and formulas from one sheet into another so if I update the input sheet transfer automically onto the output sheet , but transposed from vertical to horizontal .
The normal copy and special paste do not seem to work .
Any ideas into what I m doing wrong ?
Thank you in advance
Gabi
RE: Index sheet linked to Input or Calculation or Output sheet
Hi Gabriela,
If you have a new question in the future please raise it as a new question thanks. Otherwise the other trainers will not see it and you may need to wait a while for an answer.
Unfortunately you cannot transpose and paste link. You can paste the data as link (then the data will update) or you can paste transpose, but then the data will not update.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
