Hi Alan I would do the following: 1) Concatenate/join the cells together (using TEXTJOIN or CONCATENATE) 2) Substitute the delimiters with bl...
Hi Wade Try =HLOOKUP(C2+6,F1:AJ1,1,TRUE) Hope this helps. Sunny
Hi cgray Is it between 0 and 7 or 1 and 7? =IF(AND([@[Reset Date]]-[@[Date Pulled]]>=1,[@[Reset Date]]-[@[Date Pulled]]<=7),"This Week",0)...
No problem
Hi Marsil You only need to add this line in red to your code. It just swap the position of the Name and Public Words. Sub AddPublicWord() Dim Co...
Hi Marsil My guess is you wanted a dynamic range. Sub AddPublicWord() Dim CoArray() As Variant Dim PWArray() As Variant Dim r As Long Dim s As L...
You can try adding a carriage return like this to the code. "Message at row 1" & vbcr & "Message at row 2" & vbcr & "Message at ro...
You can hyperlink an image. Refer my attachment. You will need to run the attached macro for each image. Just change the image's name and the to...
Is the icon/symbol an image/picture? I was thinking about using hyperlink as it contains captions. The hyperlink for the image could be disabled (with...
Is it just to display a text popup or is it also clickable to run a macro etc?
Hi Stephen Give this a try. Sub SpreadAllocation() Dim r As Long Dim c As Long Dim cell As Range For Each cell In Selection r = cell.Row Rang...
Thanks Velouria and David.
Hi Nicko My formula is a bit long but should be able to get what you wanted. In cell C13 enter : =INDEX(2:2,MATCH(C12,INDIRECT("B"&MATCH(...
No problem. Glad I was able to help. Sunny
Hope this is correct. Sunny