I learned something new recently watching a recorded webinar by Jon Peltier. That’s not unusual, he is a charting legend.
Talent is cheaper than table salt. What separates the talented individual from the successful one is a lot of hard work.
The SUMPRODUCT function has been my favourite function for about 20 years. It is so flexible. Soon it will be redundant thanks to dynamic arrays.
Douglas Adams (1952-2001)
Linking to a text box in a sheet is straightforward, unless you want to copy that linked text box to another sheet and retain the link. Here is how you do it.
To link to a text box you click the text box and then click in the Formula Bar and press = and then click the cell to link to and press Enter.
This works OK on the sheet but if you copy the text box to another sheet it links to the same cell in the other sheet. If that’s what you want, great. If it isn’t then you need to use this technique.
Text box copy technique
Click the text box click in the Formula Bar and press = then instead of clicking on the current sheet click on another sheet tab and click a cell in another sheet then return to the current sheet and then click the cell you actually want to link to and press Enter.
By doing it this way the sheet name is included in the link and that ensures the link is kept when you copy the text box to another sheet.
You could also manually type the sheet name into the Formula Bar, but using the mouse is much easier.
You don’t have to burn books to destroy a culture . Just get people to stop reading them.
Ray Bradbury (1920 – 2012)
The Art of Possibility (2002)
A great book to help you think about things a little differently and hopefully act a little differently too.
Some great ideas and stories, highly recommend.
Many examples relate to music and musicians, but the practices apply to everyone.
I listened to the audio book version which had the added benefit of music.
It is best practice to use grouping to hide and unhide rows in Excel. I recently saw a technique that also displays a message.
You can easily link a textbox to a cell. If you change the link you may have an issue with the text format used.