Search results

I have a macro which creates a outlook mail from an excel database. What i am thinking is to embed a command button in the mail body with a macro to reply to the mail using specific email ids written in the macro so when ever it sent to a user and if he wants to reply to that mail then he just...

Hi, I am trying to find mails with the relevant Subject from the outlook and then "replytoall" with a given format in the Body. I have used the following code for searching the mails. Sub Test() Dim olApp As Outlook.Application Dim olNs As Namespace Dim Fldr As MAPIFolder...

Hi All, I Hsve created a code with a loop Sub CountPaste() Dim i, cnt As Integer Dim wb As Workbooks On Error GoTo ErrHandler: 'This Code has been created by Dev Sutradhar 'Workbooks.Open ("D:UsersdsutradhDesktopConfidentialNew folderMaster File_23072013.xlsx") 'Workbooks.Open...

Hey Smallman its Done i have done it. Thanks for your help and the concept.

Hi Smallman, It is not working. Could you please help me in creating the complete macro.Please

Hi, I have a Sheets "Template" where i enter id's and then press a Button "Create" which creates a new sheet with the Name from Range("F4") of the Template Sheet. Then it gets copied to Sheet("Index") and is pated in coloum "B" in the next empty cell. I have done this far. Now i need to get...

Hello Smallman, The code is working fine and you gave me exactly what i needed. Thank you so much for your help and time . Cheers :)

Hi Hui, I looked at it and understood it but my problem is i need a to get the data with a Date Range. Suppose i enter FromDate - 15.07.2013 & ToDate - 19.07.2013. I want all the data within that date range to be populated. With a particular "Text" i can also get the data populated using...

Hi Shrivallabha, Sorry i couldnot reply earlier as i was on vacation. Teh code works great. I have modified it bit to suit my needs. Thanks A ton for your Time and Help..Cheers :)

I have a Sheet where the Dates are in Column "C" of sheet "Collated".I am trying to extract a Report on a Different Sheet named "Process View" where if i give in the date Range it will find the date in the "Collated" Sheet and copy the netire row and paste it in Sheet "Process View"for range...

Hi, I have looked and searched for previous posts not getting what i want. I have a Sheet in a Workbook name "Weekly Report". I want a macro which when clicked will export the sheet with name " Weekly Report Week" Sheet("Weekly Report").Range("Q1").Value to my desktop. The path as far as i...

Hi vijay, Thank you so so much. Yes absolutely you have helped me a lot. Cheers :)

Hi Vijay, I have send the File to your given Id. Please check and help me out.

Hi All, I have a File which i had created long back and now i need it's macro part to do a new job.But the problem is that I have locked the VBA Project and now forgot the password. I have checked the previous posts and tried the HEX editor but no result.I have uploaded the file and provided...

Thanks. Today i learnt something new. thanks a lot for explaining the thing. Cheers :)

Hey Narayan, Amazing. It is working exactly i want. But one thing i am trying to make it work for one more cell, its like If data is entered in G31 of DASHBOARD, The macro should check the Whole Column "A" and when it finds the match with M7 of DASHBOARD then the corresponding cell of Column...

Hi Narayan, Forgot to tell you One thing yesterday that is If data is entered in C31 of DASHBOARD, The macro should check the Whole Column "A" and when it finds the match with M7 of DASHBOARD then the corresponding cell of Column W should get updated if not then everything remains unchanged.

Hi, Yes absolutely right. And once the data gets populated in corresponding cell in column W of Ongoing Process with the data from C31 of Dashboard it should stay there when i refresh my user page of "DashBoard".

Hello Marc L, Thanks a Ton.. Wroking absolutely Fine. Cheers :)

Hi Narayan, It is not working. I guess i forgot something. The formulae that i gave was in Column "W"(i.e - IF(A9=Dashboard!M7,Dashboard!C31,"")was in "W9"). Actually "Dashboard" is a user form and when they enter the "DATE" in "C31" of "Dashboard" i want it to go to "W9" of "Ongoing Process"...

Hi Narayan, Thank you for the formaulae. I will try it and will let you know about it. Thanks a ton

Hi, Marc L, I tried the code it is working fine. Thank you very mucg for the code but i just need one clarification on this that is I want is when it is finding the next empty row it should do it on the basis of Column "A" and should find the row without any text.Other wise it is going way...

Hello Sir JB7, I apologize for the Cross Posting i have done.Fro next time onwards i will keep that in mind in post. And thanks for letting me know some facts. And i will keep these things in mind.

IF(A9=Dashboard!M7,Dashboard!C31,"") IF(A10=Dashboard!M7,Dashboard!C31,"") IF(A11=Dashboard!M7,Dashboard!C31,"") .. .. IF(A65536=Dashboard!M7,Dashboard!C31,"") Could anyone please help me in doing this with the help of macro.

Suppose there is a row (A8 - BM8).In the Row a cell D8, there is a Dropdown where if "Rescheduled" is selected then A8,E8,F8,G8,J8,L8 will be copied and pasted on the same sheet in the next empty row. i am using excel 2007. The vale is "Rescheduled" I gave a example for row (Row8).This...