Search results

Thanks

No it's an Add-in which is an advance version of auditing tools

Hi, I am using office 2010 and Explode add-in works fine. But when i use office 2013 it only works in the file which you currently work on and does not go the other linked files. Is there any solution. Thanks in advance.

Really grateful for your valuable guidance

Hi I have a problem in an excel file. It shows a link from other file but i can't find it. I have tried to break link but failed. Moreover, i also tried to find it in Name series but there is nothing . Can any body help me. Thanks in advance

Dear NARAYANK991 It worked. Really grateful :)

Dear NARAYANK991 Thanks for your time and effort. But the problem is that all the data has not the same lenght, otherwise i would have used "left, right or mid" formula. Neither i could use Convert Text to Columns facility due to the issue mention above. Thanks

Hi I have huge data extracted from ERP. There are spaces at the start of the data and even at the end. I tried to use "Trim" & "Clean" function but failed. Can some body help me. Here is one example of data "         310101:Share capital " Thanks in advance

Thanks Hui

Dear Hui How can we get sum of figures horizontally by using sum offset formula. e.g. i have this kind of data Months Jan Feb Mar Apr May 100 200 120 50 340 I know the use of this formula if the data is Verticle. Thanks in advance.

Hui Your are great. Thanks

Hi I have an excel file which contains some links wich do not exist. I tried to break these links but fail. Can any one help in fixing the problem. Thanks in advance.

Thanks Luke, Vijay & Hui I really appreciate your efforts. I think i should use Hui's earlier guidance i.e. =if(D10>100, "Validity period Expires","")as it is simple and moreover i dont' know anything about VB. Thanks Pal

Thanks Vijay Pl guide me if data validation (which you mentioned above) can work on any resultant figure. Thanks

Thanks Hui But i need popup. I tried data validation option but it does not work :) Thanks

Hi.. Can any one help me in raising automatic pop up in excel without using VBA. e.g. when any value exceeds certain limit there should be a message "Validity period Expires". Thanks

Any update

Dear Chandoo Will it be online?? As i am not based in India

Many thanks

Hi Vijay Can you guide me how did you do that. Is it in VBA or something else. Thanks

Vijay i am really grateful to you. It works. Many thanks

Dear Luke I am posting the code from a excel tutorial (in youtube). Please advise me what should be the right code to be added in excel to add the youtube clip. <iframe title="YouTube video player" class="youtube-player" type="text/html" width="480" height="390"...

Dear Hui I have tried but when i enter the path of any youtube clip along with additional string which is mentioned in the tutorial it does not work.

2010

Hi Can someone help me in embedding any youtube video in excel. I tried but failed. Regards