$$Excel-Macros$$ Re: how to change decimal coordinates into DDMMSS format

Hi Mahesh, Here's How to do Logic: 1.The whole units of degrees will remain the same (i.e. in 9.73877° Decimal, start with 9°). 2.Multiply the decimal by 60 (i.e. .73877 * 60 = 44.3262). 3.The whole number becomes the minutes (44'). 4.Take the remaining decimal and multiply by 60.

$$Excel-Macros$$ Re: how to change decimal ccoordinates into DDMMSS fromat

*See attached file* Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Fri, Sep 25, 2009 at 4:32 PM, Mahesh wrote: > Dear friends, > > Need your help. > > i want to convert decimal coordinates into DDMMSS. > > 9.73877= 09 44 20 > > -- > With Love, > Mahesh Bisht >

$$Excel-Macros$$ Overriding excel Default charts

Once you click on the excel & add a Bar chart from the standard, it inserts the chart with a excel formatting like color, background, border etc. The formatting is a excel standard chart, how can I override this to have formatting specific to my organization. Where are these templates saved in the

$$Excel-Macros$$ Re: How to save a DBF file in Excel 2007

Unfortunately Excel 2007 cannot save dbf files. You can open them but cannot save them after edit. Check out the add-in at http://thexlwiz.blogspot.com or you can also re-install Excel 2003 (the new 2007 and old versions can co-exist) and use it for dbf editing. Hope this helps. Gyula On Sep 24,

$$Excel-Macros$$ Loop to lookup variables and copy row to new sheet

Hi, I’ve seen a few queries that are similar to mine, but I can’t get any of them to work for me. I am very grateful for any assistance that you able to give. I have a spreadsheet like this: (Sheet name: Input) Col A: Sales person name Col B: Unit Col C to Z other data Col A Clo b Col C J

$$Excel-Macros$$ Re: Splitting a text file

Hi Dilip, Can I have the password for that macro because I am not able to view the code. Thanks & Regards, Ramkrishna T. Padhi On Fri, Sep 25, 2009 at 11:06 PM, Dilip Pandey wrote: > Hi Saurabh, > > One catch could be to check the file for spaces in the file name e.g.:- > Reservation data.txt

$$Excel-Macros$$ Re: Forgotten Password

Hi, I have downloaded the software but its asking me serial number. Please confirm what do I need to use Thanks & Regards, Ramkrishna T. Padhi On Fri, Sep 25, 2009 at 10:44 AM, N.Shivkumar wrote: > Thanx it now working fine > > Bye > > N.SHIVKUMAR > Mobile : +919866533180 > Office : +91402

$$Excel-Macros$$ Re: 2 FILTER IN SINGLE SHEET

Respected members of group, I want the 2 filter option in Raws & not in Columns. Is it possible. Thanks On Thu, Sep 24, 2009 at 10:21 AM, big smile wrote: > Hellow group members, > > Have a nice time with excel master. > > I have query that can it possible to have 2 filer optio

$$Excel-Macros$$ Re: 2 FILTER IN SINGLE SHEET

HI Dear, its very simple, just silect the where u want filter then insert filter .you can put more ..to more ,as you like Regard Alok On 9/24/09, big smile wrote: > > Hellow group members, > > Have a nice time with excel master. > > I have query that can it possible to have 2 filer option

$$Excel-Macros$$ Re: Extracting a range from multiple files from a folder - Help!

Hi Abhishek I wonder why you need a macro or any software for this at all! I have not tested but try this 1) Have two columns for "Address" and "Data" (say col A and B) 2) Write down the path, filename and addresses in column A (anyway you have to do this normally even while using macros). 3)

$$Excel-Macros$$ Computation of Tax payment Tax Code Wise.

Dear Member, Monthly i take report of Sales for the previous months with respect to which Sales Tax is payable from our database. It gives in the format attached.Since, for filling of return, i require the sales tax payable tax rate wise, i have to mannualy insert a column and sort it first by CST

$$Excel-Macros$$ vba password

hello excel experts i want a software to break excel vba password breaker urgent help required regards Shefali Singh --~--~-~--~~~---~--~~ -- Some important links for excel users: 1.

$$Excel-Macros$$ parsing multi line data

I have data entries that take up three lines here is an example: LIC # BUSINESS NAME ISSUED TYPE CLASSIFICATION BUSINESS ADDRESSOWNER NAME & ADDRESSBUS PHONE #

$$Excel-Macros$$ Please Help...

We are maintaing stock on excel manually for the time being. We have been trying to use VLOOKUP unable to get the solution. Could you please help me auto allocation of locations as the stock reduced from the previous locations. http://groups.google.com/group/excel-macros/web/Book1.xls?hl=en plea

$$Excel-Macros$$ Re: Extracting a range from multiple files from a folder - Help!

Hi Kris, First of all let me thank you for this excellent piece of work - the macro worked great [?]like a lightening bolt :). It definitely solved my requirement (except the name of file in the first row), yet to bother you a little more which I hope you would not mind, just want to ask you: a)

$$Excel-Macros$$ how to change decimal ccoordinates into DDMMSS fromat

Dear friends, Need your help. i want to convert decimal coordinates into DDMMSS. 9.73877= 09 44 20 -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ -- Some important l