Hi Mohamed You don't have to understand the VBA code to use it. Just download the example file and use the UDF just like a normal function. I am...
Try looking at this article and see if it helps
Hi Amy Thanks for your sample. We now have a better picture of your request. Please refer attachment. Refer the columns in yellow. Hope this ...
Hi Matthew I concur with Frans about using a PivotTable to accomplish your task. You can refer here on how to do that: Sunny
Hi Maurizio I am unable to read your file. However base on your description, you can give the attachment a try. It contains a macro that will fi...
Hi Andy Give this a try. I have use some helper columns to get the data and then referred to them from the Quarterly sheets. Hope this helps. ...
@anders - offering solutions without seeing the data is like shooting in the dark. Lots of misses and some rare lucky hits. Been there, done it. @am...
Hi Paul Thanks for your feedback. Glad we are able to help. Cheers Sunny
Hi Amy I don't think you can add a TRIM like that to remove excess spaces from your data range. To handle cases where there could be leading and/or...
Hi Paul You can give this a try. If the 1st lookup (value) is an error, then use the 2nd lookup (text). Sunny
No reason why your formula is giving an error. What error is being displayed? What is your expected result? If you are only interested in ave...
Depending on your data, you could consider converting it into a Table and add a Total Row below it.
Hi David I wrote a new macro instead of modifying yours. Hope you don't mind See if this helps. Sunny
Why do you need codes when you can change the setting in Outlook itself? (Outlook 2010) File - Options - Mail - Stationery and Fonts...
Hi Tim You can give this a try. 1) The button did not disappear but it somehow moved to another part of the worksheet. To prevent it from "di...