Re: $$Excel-Macros$$ Getting External Data using "From Microsoft Query"

Dear Sumesh, Please see below link.. http://excelusergroup.org/blogs/nickhodge/archive/2008/11/04/excel-2007-getting-external-data.aspx -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

Awesome... Thanks Noorian Best Regards! Sent on my BlackBerryŽ from Vodafone -Original Message- From: NOORAIN ANSARI Sender: excel-macros@googlegroups.com Date: Mon, 21 Nov 2011 12:35:25 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup for a cell betwee

$$Excel-Macros$$ Getting External Data using "From Microsoft Query"

Hi, I'm trying to get data from Oracle database using the option "From Microsoft Query". This however retrieves data based on the query which remains static, unless it is modified. I want the query to be dynamic. I would like to know how this can be done. For e.g. an input to my query is custom

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

Dear Krishnan, I hope your query will be solve by =LOOKUP(G3,B3:D11) On Mon, Nov 21, 2011 at 12:22 PM, NOORAIN ANSARI wrote: > Dear Krishnan, > > Don & SAM's solutions are excellent. > apart of this you can also use > =LOOKUP(2,(1/($B$3:$B$11=G3)),$D$3:$D$11) > =INDEX($D$3:$D$11,MATCH(G3,$B$3:$

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

Dear Krishnan, Don & SAM's solutions are excellent. apart of this you can also use =LOOKUP(2,(1/($B$3:$B$11=G3)),$D$3:$D$11) =INDEX($D$3:$D$11,MATCH(G3,$B$3:$B$11,0)) =OFFSET(D2,MATCH(G3,$B$3:$B$11,0),0) -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ help needs to connect form controls to the table

thank you so much sir, if possible pls clarify my remaining doubts. On Sun, Nov 20, 2011 at 1:06 AM, Sam Mathai Chacko wrote: > You have to create a recordset by using the OpenRecordSet command in the > CurrentDB > > Use > > Private Sub cmdsave_Click() > > Dim rst As Recordset > > Set rst

Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday

Sure Maulik... I just want to know those email ids (which you want to add in CC & BCC) are common or they'll be changed with every channel name...?? Regards Deepak On Sun, Nov 20, 2011 at 2:43 PM, maulik desai wrote: > Thanks you so much deepak for your effort & sorry for late reply becasue i >

Re: $$Excel-Macros$$ Paste Special VS Paste Special

Hi, Thank you all. in this case if i want to copy paste only format from 1 workbook to another then how can i achieve that. > > From: Venkat CV >To: excel-macros@googlegroups.com >Sent: Monday, 21 November 2011 7:56 AM >Subject: Re: $$Excel-Macros$$ Paste Spe

Re: $$Excel-Macros$$ Kindly Help

Hi Vijay, See attached if helps... *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Thu, Nov 17, 2011 at 2:24 PM, vijayKumar wrote: > Dear Friends, > > Request you to help me on a Query of Open Office Excel. > > The Query is

Re: $$Excel-Macros$$ Paste Special VS Paste Special

Hi Hanumant, First one you have copied data from Some other Application(New Window workbook,World..Etc) window and 2nd one Copied from Same window same sheet's That's what it's Showing different Options... *Best Regards,* *Venkat * *Chennai* *My Linked in profile

Re: $$Excel-Macros$$ Indirect formula

Hi Sumitha, Please See below links for Indirect Function More Clarification... http://www.contextures.com/xlFunctions05.html http://www.cpearson.com/excel/indirect.htm *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Tue, Nov

Re: $$Excel-Macros$$ Deleting modules

Hi Chandra Sekar, Right Click on Module and Remove module and Click option No,, *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Fri, Nov 18, 2011 at 4:23 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello, > > Cou

Re: $$Excel-Macros$$ converting excel file into xml file

Hi Vijay, Try File Save as a .XML *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Fri, Nov 18, 2011 at 9:53 PM, P.VIJAYKUMAR wrote: > Dear Gurus, > > Is there any method to convert Excel file into XML format.In some specific >

Re: $$Excel-Macros$$ Sales Data entry form

Did you eever get an answer to this. Don Guillett SalesAid Software dguille...@gmail.com From: Manhar Kisan Sent: Thursday, November 17, 2011 3:10 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Sales Data entry form Dear All Hi I have to create a sales database for my compa

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

Works for me tooo... Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Sunday, November 20, 2011 12:43 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup for a cell between a range of values Here the attachment with the formula Don was men

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

Sam and Don... Thanks so much!! I never knew that this could be solved using a simple vlookup :) I thought that some nested formula should be written to solve this...Thanks once again.. Warm Regards ! On Mon, Nov 21, 2011 at 12:13 AM, Sam Mathai Chacko wrote: > Here the attachment with the f

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

Here the attachment with the formula Don was mentioning. Working fine as far as I can see! Sam On Mon, Nov 21, 2011 at 12:10 AM, Krishnan Moorthy wrote: > Don, thanks for your response.. > > I have tried Vlookup.. if I enter 99 in G3 it shows NA.. > > Let me rephrase my question once again...If

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

Don, thanks for your response.. I have tried Vlookup.. if I enter 99 in G3 it shows NA.. Let me rephrase my question once again...If I enter any number between 1-900 it should pick the corresponding Value .. for example. if I enter 650 it should lookup for this value in my range (B3:D11) and it s

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

Have you tried? =VLOOKUP(G3,$B$3D$11,3) Don Guillett SalesAid Software dguille...@gmail.com From: Krishnan Moorthy Sent: Sunday, November 20, 2011 11:43 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Lookup for a cell between a range of values Dear Excel Gurus, Need your help

Re: $$Excel-Macros$$ ***VBA Code to Create New Sheet with summary***

I would highly recommend that you keep all data one ONE sheet and use data>filter>autotfilter on vendor, etc. Your summary can use vlookup for c2 TSNB =VLOOKUP(B2,Data!$C$2:$Z$1000,2,0) and SUMPRODUCT formulas based on your other criteria Don Guillett SalesAid Software dguille...@gmail.c

Re: $$Excel-Macros$$ ***VBA Code to Create New Sheet with summary***

OOPs sent as response to ANOTHER POST. Ignore Don Guillett SalesAid Software dguille...@gmail.com From: dguillett1 Sent: Sunday, November 20, 2011 12:00 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ ***VBA Code to Create New Sheet with summary*** How many times do I need t

$$Excel-Macros$$ Lookup for a cell between a range of values

Dear Excel Gurus, Need your help with a lookup formula. I have some min and max numbers and next to it i have some values (see attached).. Now in column G3 if I enter any number for eg: 650 it should lookup for this value in my range (B3:D11) and it should populate "*G" *in cell *H3*because 650 c

$$Excel-Macros$$ ***VBA Code to Create New Sheet with summary***

Hi Friends, I have attached a workbook which contains Sheets “Data, Summary, etc.,” Data sheet is the base data from there we need to create new sheet using VBA based on Vendor (Column “C”). Each and every vendor’s data needs to have separate sheet (sheet name also reflect the vendor name) and fi

Re: $$Excel-Macros$$ ***VBA Code to Create New Sheet with summary***

Dear Prabhu, Attachment is missing.. Please send your workbook -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Sun, Nov 20, 2011 at 10

Fwd: $$Excel-Macros$$ Fwd: How can I repeat top most data of a column on each page

Dear All, I am thankful to all of friends who responded me well, but it is my fault that i could not mention my problem clearly. Therefore I once again try to mention please help me in this regard as earlier. Problem: Suppose I have one two columns A1 & B1.  In column A1  I entered Different Coun

Re: $$Excel-Macros$$ How can I repeat top most data of a column on each page

Dear All. I haveattached here a sample worksheet for you, in which all queries are mentioned. Your help in this regard will be highly appreciated. Thanking you in anticipation. M. Rafique Ujjan -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles.

Re: $$Excel-Macros$$ Macro Chart Problem For Stack Exchange Program

I looked at this again and I think?? I understand what you want. I also notice that your web fetch is very slow and inefficient. What you need will require a lot of programming so I suggest you contact me privately. Don Guillett SalesAid Software dguille...@gmail.com -Original Message-

Re: $$Excel-Macros$$ Making Chart more useful to readers

Thank you Sam and Don for sharing your knowledge. You guys are GREAT! Steve On 11/19/2011 1:13 PM, Sam Mathai Chacko wrote: For some reason, the named range with an INDIRECT formula isn't getting accepted within the chart. Had to change the formula to =OFFSET($A$7,1,0,13,1), assuming row 7

Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng....

Hi Ranjan, Thanks for your reply but can u plese how to use this.. On Tue, Nov 15, 2011 at 2:18 PM, rajan verma wrote: > You can use UserForm.SHow 0 .. > > On Mon, Nov 14, 2011 at 6:47 PM, dguillett1 wrote: > >> Attach your file with a reply to this msg. >> >> Don Guillett >> SalesAid Softwar

Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday

On Sun, Nov 20, 2011 at 2:43 PM, maulik desai wrote: > Thanks you so much deepak for your effort & sorry for late reply becasue i > can not able to use Gmail from my office pc & i check your file it is > working very well just one thing i want to ask u that i want to add > some email id on CC & BC

Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday

Thanks you so much deepak for your effort & sorry for late reply becasue i can not able to use Gmail from my office pc & i check your file it is working very well just one thing i want to ask u that i want to add some email id on CC & BCC can u please help in this that how can i do that.& while dat