Thanks for your compliment. Glad to know it is working well for you. Cheers Sunny
Hi David You can refer here for the VBA codes:
Hi Luke I did not encounter any problem with the bar code. Even the file you attached have no problem at all. Sunny
Hi Stefi I don't think what you want is possible even with a macro. Refer to Philip's reply on why it cannot be done. Sunny
Hi Firah It is not so straight forward as both file lookup value must exactly match for the VLOOKUP to work. You will have to first make sure th...
Hi Firah It would help if you could post a few sample in a file for us to see. From your description, it looks like the problem is the Country n...
Hi Denise I suggest you display the Primary Vertical Axis of your overlay chart. It is currently hidden. Change the Axis font size to match the ...
Hi Charlie Basically what you need is the number of months to be added to the DOB to get the FRA date. What I did was to convert your lookup tab...
Hi Aye Mu Thanks for your feedback. Happy to know it is working. Cheers Sunny
Hi Stefi No problem. Glad we are able to help. Sunny
Hi Adrian It doesn't matter how many rows you have. In cell C2 enter ok. In cell C3 enter =IF(C2="different","ok",IF(A3&B3=A2&B2,"ok"...
Can you post the data file for me to take a look? It is difficult to tell from your screenshot. It could be your data, header name etc.
Hi Stefi Since you need to enter the diameter many times, you might as well enter them into different cells. My solution differ from Philip's is th...
Hi You should always show your expected result as it will allow us to understand your needs better. See if this is what you actually wanted. ...
Hi Adrian Maybe you can try a formula. See if this helps. Sunny