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...

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...

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 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...

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.

I have a Sheet where i have column from (A - BM). I have a Dropdown in Colomn "F". When i will select "Reschedule" It will Copy certain Cells of the Row which are (A,E,f,g,j,l) And paste in in the next empty row. I know how to copy paste it but i am unable to understand how to when i need on...

Hi All, I am using a Formulae" =$AB$8=FALSE" Then AA8 is Red.It is Happening But the problem is i want the same for the next 100 Cells. Let Me explain. It is Like =$AB$8=FALSE" Then AA8 is Red =$AB$9=FALSE" Then AA9 is Red =$AB$10=FALSE" Then AA10 is Red =$AB$11=FALSE" Then AA11 is...

Hi All, I was looking for a macro which will identify a certain cell suppose "A:A", If the Valeu is "Reschedule" then it will Copy & Paste the entire row in the next empty row of the same sheet with the value in Column "A" as "Reschedule New" and then the Initial row which was copied should...

hi all i want an excel formulae which will automatically change the date and time to next day and time should be 11.30am if the time exceeds 08.30pm..format dd.mm.yyyy hh.mm am/pm could any one help me.

I have a Sheet Named "Sheet1" where in column G i have a dropdown where if i select "Completed" then the entire row should be copied to the next sheet"Sheet2". Then after that if again a task is completed it should get copied to the next sheet in the next empty row and son on. I have tried an...

Hi, I want a macro which will record time for completing a particular task in Excel 2007. The Concept is :- Suppose Column A has a DropDown with 3 options(In Progress, Hold, Completed) and time will be calculated and shown in Column B Conditions: 1. If In Progress TIME Starts 2. If Hold...

Hi, I want a macro which will record time for completing a particular task in Excel 2007. The Concept is :- Suppose Column A has a DropDown with 3 options(In Progress, Hold, Completed) and time will be calculated and shown in Column B Conditions: 1. If In Progress TIME Starts 2. If Hold...