Re: $$Excel-Macros$$ New Rupee Symbol

2010-12-17 Thread Yogesh
select ` (a key above "tab" key) and select font type rupee foradian. Otherwise use insert symbol option. On Sat, Dec 18, 2010 at 10:38 AM, C.G.Kumar wrote: > Dear All, > > > I want to use New Rupee symbol and did the following; > > 1. Downloaded the font Rupee.ttf or the new version Rupee_Foradi

Re: $$Excel-Macros$$ New Rupee Symbol

2010-12-17 Thread C.G.Kumar
THANKS. . BUT IT PREVENTS THE ARITHMETIC CALCULATION .. On Sat, Dec 18, 2010 at 11:03 AM, manhar prajapati < prajapati.man...@gmail.com> wrote: > 1 select font of Ruppee furdine in Excel > > 2 Use ` symbol for Ruppee symbol > > manhar > > On Sat, Dec 18, 2010 at 10:38 AM, C.G.Kumar wrote: > >> De

Re: $$Excel-Macros$$ Fwd: Specialized Data Analyst position with a Global MNC (no night shifts) ( if anyone interested )

2010-12-17 Thread lucky singh
Hi Ashish, Jay here working as a Sr. MIS Analyst... Do u have any thing for mumbai... Regards, Jay S On Sat, Dec 18, 2010 at 11:51 AM, ashish koul wrote: > > > > Hi, > > We have an urgent opportunity with one of our clients for the position of > Reporting Data Analyst, > > Position: Specializ

$$Excel-Macros$$ Fwd: Specialized Data Analyst position with a Global MNC (no night shifts) ( if anyone interested )

2010-12-17 Thread ashish koul
Hi, We have an urgent opportunity with one of our clients for the position of Reporting Data Analyst, Position: Specialized Data Analyst Location: Gurgaon Reporting to : Manager Must have experience in: VBA programming Automation of reports SQL writing queries in SQL/ MS Access using VBA Advanced

$$Excel-Macros$$ Fwd: VBA/MSAccess Developers Required. Job Location: Gurgaon ( if anyone interested )

2010-12-17 Thread ashish koul
HI, This is Samatha here from Samcomm Technologies. This is WRT Job opening with my Client: CMMiL5, US Based MNC. PFB The job description, kindly forward your updated profile with the below details: Details Required: Full name: Current CTC: Expected CTC: Notice Period: Available to join in 15 days

$$Excel-Macros$$ URgent Opening_VBA Developer ( if anyone interested )

2010-12-17 Thread ashish koul
Hi, There is an urgent opening with EXL/Inductis - www.*exl*service.com based out of Gurgaon. Please find the details below : Profile : VBA Developer Someone who is excellent in VBA and have managed the dashboard also Location : Noida If you are interested in this profile, please send your CV

$$Excel-Macros$$ Fwd: VBA Macros_Bangalore ( if anyone interested )

2010-12-17 Thread ashish koul
Hi ,We are recruiting for the following requirements : VBA Macros,4-7Yrs Location: Bangalore If you are intrested pls forward your Resume Contact: Narmada (080 2365 4065) *Disclaimer:* The sender of this email is registered with naukri.com as *Abner Consultancy Services* (supr...@abner.in, 2B, N

$$Excel-Macros$$ Fwd: Urgent Requirement of VBA Programmer ( if anyone interested )

2010-12-17 Thread ashish koul
Hi, We have got yours reference from Naukri/Monster/Timesjobs.com and have following urgent positions for one of Our Valued client, based at Gurgaon. Urgent Requirement of VBA Programmer Notice Period should be 15 Days Position:VBA Programmer Location:Gurgaon Experience:2+ YRS Required Qualifi

$$Excel-Macros$$ Fwd: Hiring Reporting- Data Analyst for GLobal Leader ( if anyone interested )

2010-12-17 Thread ashish koul
Hiring for Analyst – Financial Reporting & Accounting for Insurance / Reinsurance Company based in Gurgaon. Greetings! www.spectral.in is hiring for best IT/ ITES/ B.P.O's/ K.P.O's/ Call Centers offering BEST SALARY PACKAGES. Spectral Consultants Pvt. Ltd. (www.spectral.in) is one of the profes

$$Excel-Macros$$ Fwd: VBA/MSAccess Developers Required. Job Location: Gurgaon( see if anyone interested)

2010-12-17 Thread ashish koul
HI, This is Samatha here from Samcomm Technologies. This is WRT Job opening with my Client: CMMiL5, US Based MNC. PFB The job description, kindly forward your updated profile with the below details: Details Required: Full name: Current CTC: Expected CTC: Notice Period: Available to join in 15 days

Re: $$Excel-Macros$$ Need ans for 3 que

2010-12-17 Thread ashish koul
unzip using vba check out this link http://www.rondebruin.nl/windowsxpunzip.htm On Sat, Dec 18, 2010 at 2:00 AM, Deepak Rai wrote: > Hi Rohan, > > This is really nice. > > Regards, > Deepak Rai > > On Fri, Dec 17, 2010 at 9:49 AM, Rohan Young wrote: > >> Hi Hanumant, >> >> Just hit Ctrl+F go t

Re: $$Excel-Macros$$ New Rupee Symbol

2010-12-17 Thread manhar prajapati
1 select font of Ruppee furdine in Excel 2 Use ` symbol for Ruppee symbol manhar On Sat, Dec 18, 2010 at 10:38 AM, C.G.Kumar wrote: > Dear All, > > > I want to use New Rupee symbol and did the following; > > 1. Downloaded the font Rupee.ttf or the new version Rupee_Foradian.ttf > 2. Installed t

Re: $$Excel-Macros$$ Require specific entry in a cell or nothing

2010-12-17 Thread vidyut more
On 12/18/10, Richard wrote: > Is is possible to require a specific entry in a cell, or nothing? > > If someone makes an entry in a cell, I want it to be ABC (all upper > case) and nothing else. It's OK for the cell to be blank. > How can I do it? > > Thanks in advance. > > Rich > > -- > -

$$Excel-Macros$$ New Rupee Symbol

2010-12-17 Thread C.G.Kumar
Dear All, I want to use New Rupee symbol and did the following; 1. Downloaded the font Rupee.ttf or the new version Rupee_Foradian.ttf 2. Installed the font. (Copy and paste in "Fonts" folder in control panel). But , i am not able to use the symbol in excel. Could any one tell me the fallacy.

$$Excel-Macros$$ Downloading problem on Wifi

2010-12-17 Thread Vishvesh Chauhan
Hello EE (Excel Experts), I have one VBA subroutine which download CSV file from website. This works fine on any normal connection internet. But the moment I connect my laptop through Wifi, it flags an error Run time error '2146697208' "The download of the Specified resource has failed" Thi

$$Excel-Macros$$ Require specific entry in a cell or nothing

2010-12-17 Thread Richard
Is is possible to require a specific entry in a cell, or nothing? If someone makes an entry in a cell, I want it to be ABC (all upper case) and nothing else. It's OK for the cell to be blank. How can I do it? Thanks in advance. Rich -- -

Re: $$Excel-Macros$$ problem in sumif

2010-12-17 Thread Ms-Exl-Learner .
Copy and paste the below formula:- =SUMIF($R$8:$R$96,$A12,($X$8:$X$96)) Drag the formula cell below to the remaining cells and the criteria cell will be getting changed and the Range and Sum Range will remains same. But past the above formula other than R8:R96, X8:X96 range and A12 cell. Otherwi

Re: $$Excel-Macros$$ Problem regarding sum

2010-12-17 Thread Deepak Rai
Hi Santanu, Please find the solved file. Hope this is what you are looking for. :) Regards, Deepak Rai On Fri, Dec 17, 2010 at 1:42 AM, Rahul Kamal Gandhi wrote: > Sir, > > As per my interpretation your output is in Attached file. > > > Regards, Rahul Gandhi > +91-9711772297 > > > > On Thu, De

Re: $$Excel-Macros$$ Need ans for 3 que

2010-12-17 Thread Deepak Rai
Hi Rohan, This is really nice. Regards, Deepak Rai On Fri, Dec 17, 2010 at 9:49 AM, Rohan Young wrote: > Hi Hanumant, > > Just hit Ctrl+F go to option and in look in set the criteria on Values u > will get that > > bye for now > > Deepak (ROHAN) > 9818247278 > > > On Thu, Dec 16, 2010 at 3:45

Re: $$Excel-Macros$$ Need to separate/parse directory path and filename using Excel 2007 ...

2010-12-17 Thread Greg
Hi Paul, YES, this revised code is exactly what I needed! Thanks, I appreciate your help. Happy Holidays! :-) -Greg On Fri, Dec 17, 2010 at 2:40 PM, Paul Schreiner wrote: Sub GetFile() Dim fso, File, fName, fPath, fDate Dim msg Dim MyFileName Set fso = CreateObject("Scripti

Re: $$Excel-Macros$$ Rectify this Error

2010-12-17 Thread Deepak Rai
Hi, You can also use name range for "*Source Data*" Parameter. I usually prefer to use this in my reporting if all my input and output data are in same workbook. Regards, Deepak Rai On Sat, Dec 18, 2010 at 1:35 AM, Daniel wrote: > Hi, > > Change the pivottable name eg. PivotTable2. > > Regard

Re: $$Excel-Macros$$ Is it a Challenge!!!!!

2010-12-17 Thread Suryaprasad
As you are aware that lots of emails cannot be tracked and replied soon it doesnot mean that is a challenge..! On Fri, Dec 17, 2010 at 10:27 AM, Deepak Rawat wrote: > Hi i have posted this problem two times but got no reply > Is it a challenge!!! > > Dear All > > I am designing a user form but n

Re: $$Excel-Macros$$ Filter Issue

2010-12-17 Thread Chandra Shekar
Hi, Is this code for my problem. Please let me know. Thanks Chandra Shekar On Fri, Dec 17, 2010 at 7:49 AM, ashish koul wrote: > try this code > > Sub filterdata() > Application.DisplayAlerts = False > Dim i, j As Long > For i = 2 To 6 > Sheets(Sheets(1).Cells(i, 1).Text).Select > Range("a6535

$$Excel-Macros$$ Re: Conditional copy and row insert based on criteria

2010-12-17 Thread awesome.akash
Send the file. Rgds, Akash On Dec 12, 10:22 pm, WeitWinkel wrote: > Hi Everybody, I was hoping that anybody in this forum could help me > solve my particular vba problem in Excel. I need to add information > from one sheet to the other based on certain criterias. This is how my > information loo

$$Excel-Macros$$ Conversion of figures into words for currency

2010-12-17 Thread Ram swarup Vij
I want to have a formula so that in one cell if i type 1,00,00.00 i.e. one lac it can be converted in words in other cell.pls advice. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

RE: $$Excel-Macros$$ Rectify this Error

2010-12-17 Thread Daniel
Hi, Change the pivottable name eg. PivotTable2. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de vebhav jain Envoyé : mardi 14 décembre 2010 13:34 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Rectify this Error Hi All,

RE: $$Excel-Macros$$ Is it a Challenge!!!!!

2010-12-17 Thread Daniel
You may also use a table to put your data, so, when you have to change items, you don’t have to change the code (see attached file). Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Deepak Rawat Envoyé : vendredi 17 décembre 2010 05:58 À

RE: $$Excel-Macros$$ Is it a Challenge!!!!!

2010-12-17 Thread Daniel
Hi, Give a look at the attached file (note that items were entered only for « milk » and « vegetable » Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Deepak Rawat Envoyé : vendredi 17 décembre 2010 05:58 À : excel-macros@googlegroups.c

$$Excel-Macros$$ Is it a Challenge!!!!!

2010-12-17 Thread Deepak Rawat
Hi i have posted this problem two times but got no reply Is it a challenge!!! Dear All I am designing a user form but new to this, so i need help on prgramming. The logic i am mentioning here as under: Threre are 2 comboBoxes, one calender, and amount file. What i want 1. Which date i would sel

Re: $$Excel-Macros$$ Need ans for 3 que

2010-12-17 Thread Rohan Young
Hi Hanumant, Just hit Ctrl+F go to option and in look in set the criteria on Values u will get that bye for now Deepak (ROHAN) 9818247278 On Thu, Dec 16, 2010 at 3:45 PM, hanumant shinde wrote: > hey guys, > > need some help here. > > 1. how can i get to know if a specific cell has formula or