$$Excel-Macros$$ Autofilter and split the data

2018-08-28 Thread Bv Dileep
Hello All, I have created Macro as per my requirement, but its not that effective though it is generating the results. I have attached the sheet. Can some one review and help me to make it effective. Requirement is available in another sheet. Thanks in Advance -- Are you =EXP(E:RT) or

$$Excel-Macros$$ Getting Outlook Email details using Excel VBA macro

2015-07-13 Thread Bv Dileep
Hello Every one, I am trying to export the email received date and respective folder name from outlook pst's (All), Attached is the Macro currently using, but with this I am getting only Main PST Inbox Folder details. Request you to modify the code and help me. PS: I have folders and

Re: $$Excel-Macros$$ Out Of Office

2014-04-21 Thread Bv Dileep
Hi Ashish, It's not working. On Friday, 18 April 2014 15:04:40 UTC-5, ashish wrote: try this http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/A_3487-Automating-Out-of-Office-in-Outlook.html On Fri, Apr 18, 2014 at 10:52 PM, Bv Dileep bvdi

$$Excel-Macros$$ Out Of Office

2014-04-18 Thread Bv Dileep
In current situation, OOO has to be manually edited and activated. At times, we miss on updating as well as activatin OOO leading to miss on important communications. Macro which performs the following: - Everytime when user exits Outlook, it should give choice to user to activate

$$Excel-Macros$$ Data Entry Form/Database

2013-10-02 Thread Bv Dileep
Hi Experts, We have 10 associates, they are updating the data in different excel workbooks. at the end of the day i have to collate all those workbooks into one. is there any way if we provide them one workbook with share mode. If they update the data in the sheet. Only i have to get the

$$Excel-Macros$$ Pivot Table

2013-09-21 Thread Bv Dileep
Hello All, Can any one provide the macro code to make a pivot table -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate

$$Excel-Macros$$ Re: Pivot Table - Cumlative Totals

2013-09-19 Thread Bv Dileep
Hi Brett, Hope this link will solve your problem. http://www.contextures.com/xlPivot14.html#percent On Thursday, 19 September 2013 15:04:58 UTC-5, Brett Manning wrote: Hello, Hope everyone is well. I think I have a really simple question but I am struggling! I am looking for a

$$Excel-Macros$$ Re: Auto Filter

2013-08-06 Thread Bv Dileep
On Thursday, 25 July 2013 04:48:54 UTC-5, Bv Dileep wrote: Hello All, Attached is the Autofilter Macro, Basis on the criteria it filtering the data now i need to update as Yes in Colum H and rest all should be updated as No. Request you to update the Macro code accordingly

$$Excel-Macros$$ Re: Macro Help

2013-06-02 Thread Bv Dileep
On Sunday, May 26, 2013 8:50:22 PM UTC-5, Bv Dileep wrote: Hello, ** ** Please find attached the sheet. ** ** Macro Requirement : I will receive the data for 20 associates in my team in a separate sheets (20 Sheets) in the attached format. Now I want a macro which should

Re: $$Excel-Macros$$ Macro Help

2013-06-01 Thread Bv Dileep
On Mon, May 27, 2013 at 7:20 AM, Bv Dileep bvdi...@gmail.comjavascript: wrote: Hello, ** ** Please find attached the sheet. ** ** Macro Requirement : I will receive the data for 20 associates in my team in a separate sheets (20 Sheets) in the attached format. Now I want a macro

Re: $$Excel-Macros$$ Macro Help

2013-06-01 Thread Bv Dileep
: Bulloo Shire Council in Thargomindah Queensland Australia. Regards David Grugeon On 27 May 2013 16:13, VBA VABZ v...@vabs.in javascript: wrote: hey for which co you work. thx On Mon, May 27, 2013 at 7:20 AM, Bv Dileep bvdi...@gmail.comjavascript: wrote: Hello

$$Excel-Macros$$ Re: Macro Help

2013-06-01 Thread Bv Dileep
Thank you one and all for your help; Really awesome On Sunday, May 26, 2013 8:50:22 PM UTC-5, Bv Dileep wrote: Hello, ** ** Please find attached the sheet. ** ** Macro Requirement : I will receive the data for 20 associates in my team in a separate sheets (20 Sheets

$$Excel-Macros$$ Macro Help

2013-05-26 Thread Bv Dileep
Hello, ** ** Please find attached the sheet. ** ** Macro Requirement : I will receive the data for 20 associates in my team in a separate sheets (20 Sheets) in the attached format. Now I want a macro which should consolidate the data in the shown format (Format Tab). ** **