Re: $$Excel-Macros$$ Dynamic calendar quiz : There is a prize for the winner.

Submitted :) On Mon, Nov 26, 2012 at 10:49 PM, Ayush Jain jainayus...@gmail.com wrote: Thanks Vinay Dear Group, only 6 days left for the quiz, give it a try and you will learn something new Looking forward to your active participation Thanks Best regards Ayush Jain Group manager

$$Excel-Macros$$ Join this Group

Dear Experts, One of my friend wanna join this Group but I donna how to add him. Thanks Manjunath PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon's standard conditions associated with this e-mail please visit

Re: $$Excel-Macros$$ Join this Group

Hi Manjunath, http://www.discussexcel.com/ Open this link click join this group. Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless

RE: $$Excel-Macros$$ Join this Group

Dear Kuldeep, Thank you so much Regards Manjunath From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kuldeep Singh Sent: 28 November 2012 12:15 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Join this Group Hi Manjunath,

$$Excel-Macros$$ Insert Multiple mails as icons into excel

Hi All, I need to insert multiple mail objects into excel. I have around hundred of mails in a folder in my outlook. I have tried it to save individually and then insert, but its a time consuming process, If you guys can suggest a better way to get this done will be great. Thanks, Waheed --

Re: $$Excel-Macros$$ Join this Group

Manjunath, At the bottom of each email, there is a line: Visit this group at http://groups.google.com/group/excel-macros?hl=en. This link should take you to the group page and liks at the top allow you to sign up. I'm not sure what www . discussexcel . com is Paul

$$Excel-Macros$$ Need a Macros to Split spreadsheets

Hi Friends, Need your help on the below. Please find atatched sample report. 1) Split the tabs into differnt file. 2) Give file name as Account Reciveable - Tab name and save it in a specific folder (Week 46). Let me lnow if you are unclear on this. Regards, Santhosh -- Join official

Re: $$Excel-Macros$$ Need a Macros to Split spreadsheets

Hi santhosa, Press Alt +11 Use below --code.. Change accordingly.. Sub Macro1() ChDir Your Path Dim wrksht As Worksheet For Each wrksht In ThisWorkbook.Worksheets wrksht.Select wrksht.Copy ActiveWorkbook.SaveAs Filename:= your path wrksht.Name .xlsx ActiveWindow.Close

Re: $$Excel-Macros$$ Need a Macros to Split spreadsheets

Hi Santhos. Place a folder in desktop. change..according to week.. Sub Macro1() ChDir C:\Documents and Settings\user\Desktop\week 46 Dim wrksht As Worksheet For Each wrksht In ThisWorkbook.Worksheets wrksht.Select wrksht.Copy ActiveWorkbook.SaveAs Filename:=Account Reciveable

Re: $$Excel-Macros$$ Join this Group

Hi Paul Thanks for your response. www.discussexcel.com is a website link to access this group. This was created by me so that people don't need to remember the full link of Google groups. Regards Ayush Jain On Wed, Nov 28, 2012 at 6:07 PM, Paul Schreiner schreiner_p...@att.netwrote: c --

$$Excel-Macros$$ Request for :Hide cell formula Protect that cell

Hi all Champs Can anybody tell me how to protect specific cell hide that cell formula only.I know how hide it (Format cell-hidden..).No one see that formula edit that cell only. Regards Amar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM

$$Excel-Macros$$ Re: To automatically display the correct month Min Max Value

Dear experts, Kindly find attached the excel spreadsheet which i need solution for excel to automatically display the correct month for the min and max value (as highlighted in yellow). Your solution/advice on the above is highly appreciated. Thank you Best regards Sanusi -- Join

Re: $$Excel-Macros$$ Request for :Hide cell formula Protect that cell

Hi Protect sheet n keep cell format as locked. Thanks//Vabs Sent on my BlackBerry® from Vodafone -Original Message- From: amar takale amartak...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 28 Nov 2012 12:42:16 To: excel-macros@googlegroups.com Reply-To:

Re: $$Excel-Macros$$ Pasting from Excel to Word - Issue with Column Width(s)

Dear Ashish, The columns are fixed. The number of rows is not. The rows are deleted, depending upon whether or not data is entered in them. E.g. sometimes a table may have 20 rows, sometimes 30 and sometimes only 3. To give an idea behind the whole thing: 1. I have a comprehensive word

Re: $$Excel-Macros$$ Re: To automatically display the correct month Min Max Value

=INDEX($5:$5,MATCH(C9,$6:$6,0)) On Thu, Nov 22, 2012 at 12:34 PM, Mohd Sanusi Mohd Noor sanus...@gmail.comwrote: Dear experts, Kindly find attached the excel spreadsheet which i need solution for excel to automatically display the correct month for the min and max value (as highlighted

Re: $$Excel-Macros$$ Re: To automatically display the correct month Min Max Value

Dear Ashish, Thank you very much for the solutions. Best regards Sanusi On 28 November 2012 23:04, ashish koul koul.ash...@gmail.com wrote: =INDEX($5:$5,MATCH(C9,$6:$6,0)) -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

Re: $$Excel-Macros$$ How to calculate Joining Date from a given job period!!!

Hi,   Pl see the attached sheet.(you can also find the days between two dates)   -R.Karunanithi. From: MRafique Ujjan imrafiqu...@gmail.com To: excel-macros@googlegroups.com Sent: Monday, November 26, 2012 4:48 PM Subject: $$Excel-Macros$$ How to calculate

Re: $$Excel-Macros$$ small query about conditional formating

try these first http://www.youtube.com/watch?v=LOaezdoyJDE http://www.techrepublic.com/blog/10things/10-cool-ways-to-use-excels-conditional-formatting-feature/3166 http://www.homeandlearn.co.uk/excel2007/excel2007s6p2.html On Wed, Nov 28, 2012 at 10:33 PM, Kenil Gala keni...@yahoo.com wrote:

$$Excel-Macros$$ How to determine the volume slabs for different price levels in excel?

I have set of historic data 1. different price levels 2. quantity at that price levels based on the above i need to arrive at the volume slabs like 0-100 units, 100- 300 units etc and also what price needs to be fixed for that slab i would like to know how this can be scientifically done

Re: $$Excel-Macros$$ Modify Code to to send range *

Thanks, Ashish for you time. i however get a debug error with this code Sub send_emails(to1 As String, fld1 As String, body1 As String) Dim olApp As Outlook.Application thanks On Tue, Nov 27, 2012 at 3:24 PM, ashish koul koul.ash...@gmail.com wrote: Sub emailstest() ' run loop here

$$Excel-Macros$$ Code to refresh information from external data source

Hello Expert can i get help with a code to refresh information coming from a data source. i know the short cut ctrl + alt +f5 to refresh such data, but i would be grateful to get a code to do that thanks -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ EMAIL AUTOMATION BY VBA OUTLOOK

*Ashish, you are awesome!* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick

Re: $$Excel-Macros$$ Modify Code to to send range *

Choose In tools ~reference ~ microsoft outlook Sent on my BlackBerry® from Vodafone -Original Message- From: Hilary Lomotey resp...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 28 Nov 2012 20:12:36 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com