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

2009-04-09 Thread Harmeet Singh
Try attached file On Wed, Apr 8, 2009 at 9:06 PM, anish@gmail.com anish@gmail.comwrote: Hello Experts, I have been a silent member of this group and learnt so many things...But now I am facing a new problemI hope anyone of you can help me out..Problem is as below... I have 2

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

2009-04-09 Thread Prashanth Banneni
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

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

2009-04-09 Thread Prashanth Banneni
Hi All, Any help on this please. guess you understand the urgency. Thanks, Prashanth -- Forwarded message -- From: Prashanth Banneni praba...@gmail.com 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

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

2009-04-09 Thread Marcin
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 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

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

2009-04-09 Thread Mahreen Ellahi
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

2009-04-09 Thread Ganesh Babu
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 harmeet.hew...@gmail.comwrote: Try attached file On Wed, Apr 8, 2009 at 9:06 PM, anish@gmail.com anish@gmail.comwrote: Hello Experts, I have been a

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

2009-04-09 Thread Alokeshwar Tiwary
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

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

2009-04-09 Thread Bakul Patel
Hi Prashant,   Go to FORMAT CELLCustom _($#,k   this will solve your problem...   Cheers, Bakul   --- On Thu, 4/9/09, Prashanth Banneni praba...@gmail.com wrote: From: Prashanth Banneni praba...@gmail.com Subject: $$Excel-Macros$$ Fwd: Convert $900,000 to $900k in graph To:

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

2009-04-09 Thread AngeloUCF
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$$ Help Required

2009-04-09 Thread Abdul Hakim Khan
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

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

2009-04-09 Thread Kuldeep Vashishtha
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

2009-04-09 Thread Dave
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

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

2009-04-09 Thread Gohar Shahab
Dear The following codehttp://www.ozgrid.com/forum/autolink.php?id=1script=showthreadforumid=8will put a Left headerhttp://www.ozgrid.com/forum/autolink.php?id=37script=showthreadforumid=8in each worksheethttp://www.ozgrid.com/forum/autolink.php?id=18script=showthreadforumid=8in the workbook

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

2009-04-09 Thread jayendra gaurav
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 the container

$$Excel-Macros$$ Increment Column

2009-04-09 Thread ~slacker~
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

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

2009-04-09 Thread shashank bhosle
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

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

2009-04-09 Thread freshforlife
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:

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

2009-04-09 Thread RickB
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

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

2009-04-09 Thread Dave Bonallack
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