$$Excel-Macros$$ Re: Default Excel template at startup

*Note:* Excel searches the following directories to open all files in it when it is started - '*User **Excel Startup Folder*' - c:\winnt\Profiles\\Application Data\Microsoft\excel\xlstart - c:\Documents and Settings\\Application Data\Microsoft\excel\xlstart - '*Syste

$$Excel-Macros$$ Re: Default Excel template at startup

Hi A quick question.. did you save yuour template as book.xlt before placing it in XLSTART. If not please try that Regards, Andy On Fri, Apr 10, 2009 at 3:09 AM, freshforlife wrote: > > Hi All, > > I created a customized template file (.xlt) to reflect a customized > color palette. Now I would

$$Excel-Macros$$ Re: Macros in Outlook

Hi Roopesh, Thanks a lot. Regards - Dave. From: roopesh.ka...@gmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Macros in Outlook Date: Thu, 9 Apr 2009 08:00:32 +0530 Dave, Below is the code of the macro in the file that Mudassar. I am attaching an

$$Excel-Macros$$ Writing cell contents to seperate files

Once, long ago I used to write stuff like this but it's been too many years and I don't remember where to start. I'm using Excel to generate test data. The sheet has all the data I need calculated. Now I need a macro to loop thru a named range of cells and write the value of each cell to a new f

$$Excel-Macros$$ Default Excel template at startup

Hi All, I created a customized template file (.xlt) to reflect a customized color palette. Now I would like this template to be the default template so that when I start excel, all the colors are in the same format as the customized palette. I did some google search to do this: http://www.vleri

$$Excel-Macros$$ Re: Macros in Outlook With Example..help me please

HI Thanks you very much for the help but to clear it attaching an example This is the format below where i need to send this type of mail everyday to staff.Everytime i have to copy it and paste in new mail, i want a macro in such a way that when i open then mail and run the macros it should auto

$$Excel-Macros$$ Increment Column

This seems like it should be fairly straight forward but i can't seem to find an easy solution. Can any one help? I want to create a macro or hot key that will take the formula in the currently selected cell, copy it to the cell below and adjust the formula 3 columns to the right. ex. if the sel

$$Excel-Macros$$ Re: Fwd: mACRO HELP

Dear Ashis , U helps to all member ,pls help me also.Mateer is most urgent > > > >> Dear All, >> >> Can you please help me write a macro to simplify finding the packing list. >> The required files are attached for your reference. The tedious job that we >> do is as under: >> >> >>- Fin`ding

$$Excel-Macros$$ Re: Help Required

*Hi,* Select the cells J10: J2500, type 5% and press CTRL + ENTER. Note: To select the cells at once, put the curson on J10 and press CTRL + Down ARROW or if you have the data seperated, then press CTRL + * Thanks & Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744

$$Excel-Macros$$ Re: Urgent Help needed : Excel Headers

Dear The following codewill put a Left headerin each worksheetin the w

$$Excel-Macros$$ Re: Fwd: Convert $900,000 to $900k in graph

Change the units displayed on the value axis If your chart values consist of large numbers, you can make the axis text shorter and more readable by changing the display unit of the axis. For example, if the chart values range from 1,000,000 to 50,000,000, you can display the numbers as 1 to 50 on

$$Excel-Macros$$ Re: Urgent Help needed : Excel Headers

Hi Mahreen, Follow the below mentioned procedure for the same. 1. go to the file menu 2. select page setup 3. click on sheet tab 4. there is option "Rows to repeat at top" click on that and give the range of required field 5. than come back by click on ok and print it. *Unfeigned Regards Manoj

$$Excel-Macros$$ Help Required

Dear All, Could u plz help me regarding solving this problm. I have entered manual data in cell j10:j2500.so on. I want to change the value of j10:j2500 to 5 %. I dont want to enter again the value - 5 %. Can we solve it through macro or vba code or function. Your kind cooperation in this reg

$$Excel-Macros$$ Re: Fwd: Convert $900,000 to $900k in graph

Use formula as =Cell no / 1000 _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Prashanth Banneni Sent: Thursday, April 09, 2009 12:54 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fwd: Convert $900,000 to $900k in graph

$$Excel-Macros$$ Re: Fwd: Convert $900,000 to $900k in graph

Right click the axis > format axis Then select the Number tab and select the Custom category. In the format code, type in "$###K" Then select the axis options tab and select the display units as "Thousands" This should be what you are looking for. Angelo --~--~-~--~~~--

$$Excel-Macros$$ Re: Fwd: Convert $900,000 to $900k in graph...done

Hi Prashant,   Go to FORMAT CELL>Custom> _($#,k   this will solve your problem...   Cheers, Bakul   --- On Thu, 4/9/09, Prashanth Banneni wrote: From: Prashanth Banneni Subject: $$Excel-Macros$$ Fwd: Convert $900,000 to $900k in graph To: excel-macros@googlegroups.com Date: Thursday, April

$$Excel-Macros$$ Re: Fwd: Convert $900,000 to $900k in graph

Hi Lavprasad, You are awesome. Thanks a million. Prashanth On Thu, Apr 9, 2009 at 4:38 PM, Lavprasad Kori wrote: > > Hi Dear, > > Attached herewith the file of soluiton. > > Regards, > > Lavprasad > > > > On Thu, Apr 9, 2009 at 12:54 PM, Prashanth Banneni wrote: > >> Hi All, >> >> Any help on

$$Excel-Macros$$ How to pull the charts from the excel file to the PPT?

Hi All, Please find the attachment. My requirements is – Can anyone tell me how to pull the charts from the excel file to the PPT? I want two charts to be placed in ONE PPT. For example – Chart 1 & Chart 2 should go to PPT Slide 1 and Chart 3 & Chart 4 should go PPT Slide 2 and likewise. I want

$$Excel-Macros$$ Re: Macros in Outlook

See below. this freeware clicks yes automatically:http://www.snapfiles.com/get/clickyes.html _ "There are known knowns. These are things we know that we know. There are known unknowns. That is to say

$$Excel-Macros$$ How to consolidate week to week figures in several e-mails to one single sheet

Hello, At work I have to do the following: 1. From approx. 35 countries mails are sent with a figure (one number) of the revenues on a weekly basis 2. The mails are manually put in a Excel worksheet 3. The mails are logged for tracking I would like to know how I can use Visual Basic to (partial

$$Excel-Macros$$ Fwd: Convert $900,000 to $900k in graph

Hi All, Any help on this please. guess you understand the urgency. Thanks, Prashanth -- Forwarded message -- From: Prashanth Banneni Date: Thu, Apr 9, 2009 at 11:09 AM Subject: Convert $900,000 to $900k in graph To: excel-macros@googlegroups.com Hi Team, I have an urgent req

$$Excel-Macros$$ Convert $900,000 to $900k in graph

Hi Team, I have an urgent requirement. i have a graph whose y axis has revenue from $0 to $900,000, now i want to remove the last 000 and show as $100K, $200K, $300K, $400K..$900K. Can any one let me know how to change it in the custom tab under Format Axis. Need this help for a presentatio

$$Excel-Macros$$ Re: Fwd: Can you break password of attached sheet also let me solution.

You can open it via OpenOffice Calc and then no password is needed. Regards, Marcin On Apr 7, 11:39 am, "prabhat.shrivasta...@gmail.com" wrote: > how u unprotected this file??? > > Wot is the mathod to unprotect a file > On Apr 6, 6:35 pm, "Mudassar Ramzan" wrote: > > > Please find unprotected

$$Excel-Macros$$ Urgent Help needed : Excel Headers

I have few cells in excel worksheet that I want to show as header in print copy. Can any one tell me how to select those cells to show as print header. Regards Mahreen --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Re: Data Validation Help

Please find attachd as required by you, I have used "IF", let m know if it was useful On Thu, Apr 9, 2009 at 11:51 AM, Harmeet Singh wrote: > Try attached file > > On Wed, Apr 8, 2009 at 9:06 PM, anish@gmail.com > wrote: > >> >> Hello Experts, >> >> I have been a silent member of this group