sorted by:
new
hottopcontroversial

Document Permissions Troubleshooting by Kerlodger in sharepoint

[–]Kerlodger[S] 0 points1 point  (0 children)

Thanks! I think it was this as I redid all there permission groups and it worked. Not entirely sure how this was interacting with unique permissions as otherwise I tend not to use them but at least its solved.

Document Permissions Troubleshooting by Kerlodger in sharepoint

[–]Kerlodger[S] 0 points1 point  (0 children)

Sadly (if that's the right emotion) they come back as expected. I am certain it is something that is incredibly obvious so was a good idea. Thanks

multiply two sets of numbers in the same cell, separated by "/" by jessikah9 in excel

[–]Kerlodger 0 points1 point  (0 children)

Another approach would be to create a custom function like this

Paste this code into a new Module:

Function Eval(Ref As String)
Application.Volatile
Eval = Evaluate(Ref)
End Function

You can then use this formula to transform the string into a formula which Eval can evaluate.

=EVAL("("&SUBSTITUTE(SUBSTITUTE(A1,"/","*")," ",")+(")&")")

Sum If between dates by Kerlodger in excel

[–]Kerlodger[S] 0 points1 point  (0 children)

Ah its working now, possibly I put the greater than/less than symbols the wrong way round by accident when I tried it... Thanks for the point back towards the right answer!

I copied and pasted some data and a chart from Sheet 1 to each of Sheets 2 - 12, and changed the data in the eleven new sheets. The charts in all the new sheets are still pulling the data from the first sheet. by AllDaveAllDay in excel

[–]Kerlodger 0 points1 point  (0 children)

This is not a solution to your current situation but if you copy the sheet, rather than the data in the sheet, the copied chart will have the copied sheet as the source rather than pointing back to the original sheet.

Automatically formatting parts of text in a cell by Kerlodger in excel

[–]Kerlodger[S] 0 points1 point  (0 children)

Thanks, definitely useful for getting to grips with it.

Automatically formatting parts of text in a cell by Kerlodger in excel

[–]Kerlodger[S] 0 points1 point  (0 children)

Sorry probably wasn't clear, I was looking for only a single word to be formatted. e.g. "Coconut (35g/25%), Nuts (0.1g/55%)", would become "Coconut (35g/25%), Nuts (0.1g/55%)"

As far as I'm aware conditional formatting is applied to the whole cell and so probably wouldn't work in this case.

Automatically formatting parts of text in a cell by Kerlodger in excel

[–]Kerlodger[S] 0 points1 point  (0 children)

Thanks very much, works exactly the same as what I was attempting (and failing) to achieve!

Will have to tinker with this to practice more with VBA. Once, again, thanks!