Hi Paul Instead of using a textbox and VBA, maybe you can considered using picture-link instead. See my example attached. Any changes to the cel...
Hi Saliha Give this a try. Please note that the formulas used are array formulas and you need to press CTRL+SHIFT+ENTER instead of ENTER. You ca...
Try this. Hope this helps Sunny
Hi Paul Maybe you can attach a sample file. It will be much clearer on what you are currently doing and how you did it. Sunny
Hi Peter and welcome to the forum. Try right-clicking the scrollbar and choose Format Control. In the Control tab look at the Incremental change...
Give this a try.
Hi Mohamed Try this. It is an array formula. Sunny
Hi Melinda No idea what you wanted. Your current charts already have the symbols. Are you intending to redraw the charts? Maybe you can attac...
Hi Mohamed You can give this a try. You will need to adjust the macro to suit your needs. Hope this helps Sunny
Hi Melinda In cell E5 of the BOARD worksheet you can try =INDEX(Cathy!$E$9:$E$72,MATCH(E$4,Cathy!$D$9:$D$72,0)) Hope this helps. Sunny
Hi Amy Try =SUMIFS('Skidtags Master'!U:U,'Skidtags Master'!F:F,A7,'Skidtags Master'!G:G,B7,'Skidtags Master'!S:S,$I$5,'Skidtags Master'!AL:AL,"&...
Hi Chris See if this helps. Enter a value in the yellow cells and it will multiply with the value from the range named RATE and then it will rou...
Hi Paul If you are unable to change your source data then maybe you can consider using a custom list to sort the Slicer. Sunny
Hi Paul Thanks for your feedback. Glad we were able to help. Sunny
It seems your question had already been answered in Mr Excel. Anyway you can refer to my example. It contains the Conditional Formatting for the co...