Here is the hyperlink formula used in this video (replace "Index" with your own sheet name): =HYPERLINK("#'"&[@Index]&"'!A1",[@Index])
@truedisciple2897
6 ай бұрын
Thanks. You remind me of Tina Fey.
@jasonmohr6571
7 ай бұрын
Off topic with this comment. I've been watching Sharon's videos for about a week and have learnt so much. Fun fact she has sectoral heterochromia in the left eye just like myself. Such a rare sight to see 😉
@SharonSmith
6 ай бұрын
Hello! I'm so glad you have found my videos helpful and that you noticed my eyes - I rarely meet anyone else who has it. Usually people don't notice that it is actually two colors in one eye. Best of luck to you. Thanks for watching my videos!
@aubiejazz
7 ай бұрын
Thanks Sharon for the Excel tip! I did change my procedure a little. On the last step where you were coping and pasting the TOC link in the other pages, I selected the remaining pages, after I had done the first one, and pasted the link into all of the at once. Again, thanks! This is a neat trick to expedite the building of a database.
@SharonSmith
7 ай бұрын
That is perfect! Thanks for sharing your tip there. That is a great way to copy that automatically. Thanks for watching!
@lindasmith945
7 ай бұрын
Your video’s are always so helpful and informative! Thank you Sharon!
@SharonSmith
7 ай бұрын
Thanks so much for watching, Linda!! Glad you find my videos helpful! 😊
@shameekasimone9202
7 ай бұрын
Great video! Off topic question. Can a billable form be created with quick parts? If so how do you save it? I created a form but when I re-open it, I get an unreadable content message.
@FM_Flop290
7 ай бұрын
I have 1 tab with 23 rows & columns to AQ. Each cell has a number ranging from 1 to 20. What I want to have in tab 2 is the cells change colour based on the number being -1 (dark green), -2 (red), +1 (yellow), +2 (light green) compared to the data in tab 1. I know its conditional formatting but I don't know how to set it up, please can you help? Or link me to a video?
@devdash.-chanel_5855
7 ай бұрын
How to use Insert menu, Text Group, Quick parts ka ,(Insert Field) option. Please make video of this option (Insert Field) and summaries it.
Пікірлер: 12