Search results

I have an excel file which I want to get the amount in the master sheet from the datasheet, I have tried the formula with vlookup and match it works only in 1st row. could you please help me with the excel formula 1. in the datasheet this month we have data little however in next month the data...

Hi , Could anyone please help me in i want a macro file which will copy one cell above in Column "M" 1. the data will be Column "M" always. 2 the data may be in any cell in column "M" 3. where ever the data is it should copy one cell above in same column "M". example : the if the data is in...

Hi Chihiro, I could not understand ,can you please let me know where to add this line.

Hi Chihiro, Many Thanks for your Help!! After adding the line now the macro is working fine, however the macro is not stopping and after 30 minutes the macro will stop and return me the below error . I have question can we add "received date " and "to date " like 6/8/2017 to 6/8/2017...

Hi Chihiro, I tired running the macro I am now getting this error

Hi Chihiro, Sorry there are other folders in my mail box this is one of the folder which I want to track the mails received on daily basis folder name is "SBS BLR JOURNAL LATAM CHCG" in that Inbox. regards Giriraj

Hi Chihiro, yes it is default inbox. Regards Giriraj

Hi Chihiro, Thanks for reply . yes that is the folder in my inbox "SBS BLR JOURNAL LATAM CHCG" and the mails in the inbox.

still getting error

Hi , Need your help I have macro to extract mail subject ,received time ,sender which is attached macro is not working could you please help me and also I want one more help in the macro can we line like in the subject line it will mentioned with some company code name like A010 in...

Again Thank you very much for your valuable help.

Hi, Sorry one favour can we add at the end of the mail Signature . something like this Thanks and regards. XXXXXXXX.

Hi Costa, Thank you very much you made my day. Regards Giriraj

Hi team, Can you please help me ,I have macro to send out look mails from excel which is working however it is taking only for the 1st line and one more I have problem in the body I want as it is which I have attached in the mail like this I have many e mails id 's to send the mail...

Hi p45cal, Many thanks this worked out for me .

Many thanks Bosco... However I have another criteria in that, I have list and there are many company codes in that and the approval matrix will be the same , is it possible that formula will look also the column B ,I have attached the new file .

Hi Narayana, The below formula is working =IF(G5<100,"A",IF(G5<500,"B",IF(G5<1000,"C",IF(G5>1000,"D")))) even this too is working =LOOKUP(G5,100*{0,1,5,10},{"A","B","C","D"}) Many thanks to all who has given the formula however will brief you more this is to find out the approver...

Hi, Can you please help to get the formula where I have more than 1000 lines and it needs to be check on daily basis. I have attached the file for you reference. Many thanks for your help in advance. Regards Giriraj

Hi Deepak and Chihiro , I have tried putting sheets("BFC")and in project properties all the sheets are with (), but no luck ,could you please help me ,I am attaching the file . Thanks and regards Giriraj

Hi Chihiro, i have tried your code by little bit modifying ,I am getting the run time error 424 . 1. Sheet name changed from Sheet 1 to BFC 2. I have given the range in the same sheet BFC AD1;AD6. 3. I have pasted your code in the new module as before this there is another set of...

Many thanks Chihiro, you made my day .

Hi Team, Need your help in the below query ,I was trying to create a Macro for the below Criteria in the filter I want to only the account ID to remain in the column like the account ID starts with "A","L","MP12","UM" and "P". could you please help . Thanks and Regards Giriraj

Hi, I have formula for =today() on sheet 1 , the same sheet is copied on next day how to keep unchange the date on sheet 1 without removing formula and the sheet 2 should display the next day date. Many thanks for your help in advance. Regards Giriraj

Hi Narayan, yes this is a confidential data ,I am mailing to your E mail ID -thanks.