$$Excel-Macros$$ help plz

2009-09-22 Thread ashish koul
inserting a blank row with matching value in a cell like when my cell vale in colm b is "parent co" i want to insert a blank row and shifting my data down Thanks Ashish --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Consuming SOAP and REST APIs in Excel with live data

2009-09-22 Thread silverbullet
I'm going to give a 30 minute demo/Webinar on consuming SOAP/REST APIs in Excel on Thursday if you'd like to see it. https://www2.gotomeeting.com/register/926618738 I'll discuss why Excel is a great platform for building mashups and other applications using live data rather than going out and le

$$Excel-Macros$$ Fwd: Name Matching In Excel

2009-09-22 Thread Sonal Gadgil
Hi All. Please help me in this Thanks & Regards Sonal Gadgil -- Forwarded message -- From: Sonal Gadgil Date: Mon, Sep 21, 2009 at 9:46 PM Subject: Name Matching In Excel To: excel-macros@googlegroups.com Hi... I am new in this group. I am facing one proble while workin

$$Excel-Macros$$ Re: Opening Specific Worksheet By Selecting its Name from Dropdown List

2009-09-22 Thread Hemant
Use this code Mohit '1) Create a ComboBox in "Sheet1" '2) Insert a new module and paste the following code Sub Auto_Open() For i = 1 to thisworkbook.sheets.count Combobox1.Additem sheets(i) Next i End Sub '-- '3) Paste the foll

$$Excel-Macros$$ Opening Specific Worksheet By Selecting its Name from Dropdown List

2009-09-22 Thread Mohit Agarwal
Hi, Is it possible to go to create a drop down list of names of all the worksheets in a workbook without writing the names on a different sheet and then using data validation. I mean if I am not sure about the names of worksheets or if some more worksheets are added later then is it possible to get

$$Excel-Macros$$ Need urgent help on finding formula

2009-09-22 Thread vinod rao
HI Team, need a foumula to find the latest Date and in next column the Status Plz find attached.file. Thanks in advance. VR --~--~-~--~~~---~--~~ -- Some important links for excel users

$$Excel-Macros$$ run a macro when workbook close

2009-09-22 Thread TAlgo
All, I have multiple workbooks with unique names in one of my folder. Each workbook has similar sheets and it contains pivot values. I recorded the program from one of the workbook which selects the fields i need. Is there a way I can do this for all the workbooks in the folder without opening

$$Excel-Macros$$ Amazing news : This forum is available on website too >>> www.discussexcel.com

2009-09-22 Thread Ayush
Dear excel enthusiasts, We are delighted to announce that the group is now available on website and you need not remember the full(typical) address to access the group. The new address of group is www.discussexcel.com We have purchased this domain for easy access and to increase the reach of the

$$Excel-Macros$$ Re: Help Required in Master file to PPT

2009-09-22 Thread minimaster
How can I attach an excel workbook to this reply? I added some macro code to your workbook. But for some reason I can't find a way to attach it here. --~--~-~--~~~---~--~~ -- Some impor

$$Excel-Macros$$ Re: Lookup Query

2009-09-22 Thread Deepak Rawat
Hi Gyanesh PFA the solution u want!! Regsrds, Deepak Rawat On Mon, Sep 7, 2009 at 11:46 PM, gyanesh jain wrote: > > Hi friends, > I have some Query related with Lookup. its in attachment. > > can any provide the solution? > > -- > Thanks, > Gyanesh Jain, BE, MBA (Finance) > +91 98868 68488 >

$$Excel-Macros$$ Help Needed for Debit Credit entries (Re: Thanks !!!)

2009-09-22 Thread Dilip Pandey
Dear Pradeep, Thanks for the encouraging words. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Sep 22, 2009 at 11:15 AM, Pradeep Agarwal < pradeep.agra...@licindia.com> wrote: > Dear Sir, >