Search results

Hi @Marc L sir, code is working perfect. Thanks a lot. Have a nice day ahead. :)

Hi @Marc L sir, sure, thanks. :)

Down with some health issues, did not get time to check. Will revert ASAP. Have a nice day ahead. :)

Hi @Marc L sir, thanks a lot for the help. Sorry for late reply. Have a nice weekend. Take care. :)

Hi @shrivallabha sir, thanks a lot for the help. I am checking this and will get back to you. Have a nice weekend. Take care. :)

Hi @Marc L sir, thanks a lot for the help. I am checking this and will get back to you. Have a nice day ahead. Take care. :)

Hi @Marc L sir and @Debaser sir, thanks a lot for the help. Have a nice day ahead. :) @shrivallabha sir, it is working perfect, thanks a lot for the help. Have a nice day ahead. :)

Hi @Marc L sir, it is working perfect, thanks a lot. Sorry for delay in reply. Have a nice day ahead. :)

Hi @Marc L sir, thanks a lot for the help. I am checking this. Have a nice day ahead. Take care. :)

Hi @shrivallabha sir, I guess I might get it using FIND option. Will seek help if get stuck. Thanks. Good night. :)

Excellent video @shrivallabha sir. :)

Hi, Please see attached file for reference. Column A is Date records. Column F is the result. Dates in column A might be duplicate too. For example 29-07-2021 can be present 3 times in the data. We need to check last date from the records (usually last row only). In our example, last date from...

Hi @shrivallabha sir, sure, I will do it. Thanks for the help. Have a nice day ahead. :)

Hi @shrivallabha , thanks for the help. Yes, you are correct. Have a nice day ahead. :)

Hi, Please see attached file for your reference. Column A is my input. Column F is my output. Value in cell A2 = 20210728. This is not date, if I apply '=YEAR(A2)' it will give me #NUM! However I need to convert this value in a DATE format, to get this I use nested formula in VBA. Please cell...

Hi, Can anyone please help me in this. Apologies if my post violates Forum rules.

Hi, Code at below URL is working for me, thanks. https://www.puresourcecode.com/tips-tricks/how-to-highlight-specific-text-in-excel/

Hi, Please see attached file for your reference. Column A is the key word to be searched. Column D is the Text to be searched from. I am trying to write a macro for below requirement. Column D will have different text values. Each cell will have different text. This text can be multi line or...

Please see attached file for more examples. In this file I have given direct result for table 2.

Hi, Please see attached file for reference. At row number 2 is how actual data will look. At row number 15 is the result I am trying to get. Please note, I am trying to get the result row number 2 itself. This attached file is just for reference. Original file will be like this. Table one...

Hi, I was able to get result using code at below URL. https://stackoverflow.com/questions/41675792/extract-attachments-from-saved-msg-files-using-vba Thanks. Have a nice day ahead. :)

Hi, I am trying write a macro which will extract CSV files from e-mail attachment. 1) User will save e-mail(s) in a folder 2) User will select this folder using browsing button provided in macro 3) Macro will extract all the attachments from all the e-mails in the same folder I am not able to...

Hi @Chihiro sir, it is working great. Thanks.

Hi @Chihiro sir, thanks a lot for the help. I am checking this and will revert with updates. Sure sir, I will learn this meathod. Have a nice day ahead. :)

Hi, I have a string, this string is partial file name. I am trying to open this file. But macro is giving bug when am trying. Folder is present, file name is correct, I checked it manually, do not know where my mistake is. Can anyone please help me in this. Am getting pop-up as file moved...