$$Excel-Macros$$ Lookup Query

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 Please Save a tree...please don't print this e-mail unless you really need to --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: harmeet thanks for the solution

Dear Ashish There will be no problem with this.It will clear all emails. On Mon, Sep 7, 2009 at 4:20 PM, ashish koul koul.ash...@gmail.com wrote: sorry i forget to ask u this that email can end with.net or .org. or.in etc. Thanks ashish

$$Excel-Macros$$ matching and finding data

hi, how do i match columnA in spreadsheetA with columnB in spreadsheetB to find the value in columnD of spreadsheetB ? --~--~-~--~~~---~--~~ -- Some important links for excel users:

$$Excel-Macros$$ Re: Filter problem

Hi Prashanth This could be the problem because on Worksheet Book Master (2) you are using a custom filter which is equals 3264. Try is greater than OR is greater than or equal to This should resolve the issue. :) Ewan --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: matching and finding data

Hi Lynn You have the answer in your question. You could use the function INDEX(array,row_number,[Column_num]), to get the row_number and column number you could use the function Match (lookup_value,lookup_array,match_type) where for match_type 0 = Exact Match, 1 = Less than, -1 = Greater than.

$$Excel-Macros$$ Re: Puzzle #1 - Generate the Sample Pattern (VBA)

Hi Ashish, Check the result. Regards Sandeep - Original Message - From: Ashish Jain To: excel-macros@googlegroups.com Sent: Sunday, September 06, 2009 10:06 AM Subject: $$Excel-Macros$$ Puzzle #1 - Generate the Sample Pattern (VBA) Hi All, This is challenge for all

$$Excel-Macros$$ Webservice on (Excel 2003 n vista)

hi friends, when i m trying to access my webservice from excel using soap toolkit by providing it the WSDL it is not able to locate the webservice. Any idea why ? I am getting this issue. thanks for the help in advance. Note : I have a license Vista OS and a license Student license MSexcel 2003

$$Excel-Macros$$ Re: Filter problem

Hi, In excel 2003 the filter will show only the first 1000 results hence you are not able to view data beyond 1000(but custom filters will work), where as this problem will not be there in excel 2007, Regards Sathish Jalendran From: excel-macros@googlegroups.com

$$Excel-Macros$$ Query

How to put zero ('0') in Blank Cells scattered in a table? - Ankur Satija, Consultant --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA

$$Excel-Macros$$ Variable Workbook name used in range formula

Hello all, new to group! I will contribute as I am able, but to start, I am really hoping someone can help me with a problem. I have a named workbook as follows: CarrierGrid = Range(O CStr(R)) Range(Control!B4).Value .xls This is giving me CarrierGrid as HDMU 08.31.xls, which is what it

$$Excel-Macros$$ Copy Pivot Table Filters through code

Hi, i've got the following problem : We use excel files with many sheets, each containing a single pivot table. All tables on the different sheets (but same file) have the same filters ( filtering years ) but different views. If i have to change a filter ( eg. add a new year ) this only affects

$$Excel-Macros$$ Re: Insert and name sheets based on data on a column

Amazing.just amazing what is available here the help from the Gurus Thanks !! best regards Subu On Sep 8, 5:09 pm, Mudassar Ramzan johnplaye...@gmail.com wrote: Use attached Adds-On Regards, Mudassar Ramzan - Original Message - From: Subu mail_to_s...@yahoo.com To: MS

$$Excel-Macros$$ VBA / Macro to Download pages listed on a column

Dear folks Thanks for the help so far... I wish to know if the following can be automated using VBA ? Step 1 : I have a list of URL listed in a column. I wish to download the contents of each of these pages one by one, i.e. without me clicking on each URL...or cutting and pasting the

$$Excel-Macros$$ Copy and paste drop down menus

I am currently creating an excel based estimating software and have hit a brick wall. Two-Fold Problem: My current database format utilizes drop down items under each estimate sub-item. First I want to be able to, once an item is selected, have another line automatically copy and paste the

$$Excel-Macros$$ Re: Lookup Query

Enter the following formula in cell J7 and copy it down: =INDEX($C$6:$G$6,MATCH(I7,C7:G7,0)) Norman On Tue, Sep 8, 2009 at 2:46 AM, gyanesh jain gyanjai...@gmail.com wrote: Hi friends, I have some Query related with Lookup. its in attachment. can any provide the solution? -- Thanks,

$$Excel-Macros$$ Re: Variable Workbook name used in range formula

 I think you're missing the square brackets []. I used:     Range(data) = _     =VLOOKUP(RC[-1],'[ CarrierGrid ]OAK'!C1:C5,5,FALSE) and it worked great. (try recording a macro where you insert the formula, then replace the file name with the variable syntax. Just leave the other

$$Excel-Macros$$ Re: (with attachment) Merging Data of two different sheets of two different files

Dear Prasad, Please try asap utility , its free add in to excel - link is http://www.asap-utilities.com/download-asap-utilities.php you should be done with it. Reply do u still face a problem Regards, Prashant From: excel-macros@googlegroups.com

$$Excel-Macros$$ Re: Puzzle #1 - Generate the Sample Pattern (VBA)

Hi Sandeep, I couldn't find any macro in the file. Please check On Tue, Sep 8, 2009 at 6:47 PM, Sandeep sandymau...@gmail.com wrote: Hi Ashish, Check the result. Regards Sandeep - Original Message - *From:* Ashish Jain 26may.1...@gmail.com *To:*

$$Excel-Macros$$ Re: Query

Follow below steps: 1. *Select table where blank cells exist.* 2. *Press F5* 3. *Click on Special and then Blanks.* 4. *Enter 0 and press Ctrl+Enter simultaneously.* U r done. On Tue, Sep 8, 2009 at 3:10 PM, Ankur Satija ankursat...@gmail.com wrote: How to put zero ('0')

$$Excel-Macros$$ Re: Filter problem

Hi Prashant,Unfortunately, excel can show you first 100 unique entries only in auto filter (It is hard coded in Excel) Workaround can be pivot table. On Tue, Sep 8, 2009 at 11:56 AM, Prashant Pednekar prashant...@gmail.comwrote: Dear all Thanks for the knowlege enrichment of excel by you

$$Excel-Macros$$ How to predict row height from font size?

Excel gurus, Is there a precise formula to calculate the row height (in points or pixels) from the font size? Here are my specifics: * Screen resolution is 96dpi * Default font is Verdana 8pt * Verdana font has an ascent of 1005 and a descent of -209 (total span is 1214; 1.214em?) With this

$$Excel-Macros$$ Re: NEED HELP on multiple vlookup

i need to ask one question what if keys are alpha numaric Regards Santosh Bahuguna On Sat, Sep 5, 2009 at 7:50 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Madhur, Attached is the solution to your query along with the explanation. Thanks -- DILIP KUMAR PANDEY MBA-HR,B

$$Excel-Macros$$ Re: Variable Workbook name used in range formula

Hi, I haven't tested this, but I think you need: Range(data) = =vlookup(R[-1]C,[ CarrierGrid ]OAK!L:R,7,False) ie, use square brackets instead of ' Regards - Dave Date: Tue, 8 Sep 2009 07:26:00 -0700 Subject: $$Excel-Macros$$ Variable Workbook name used in range formula From:

$$Excel-Macros$$ How to remove an add in

Hi Folks I have used an add-in on one of my sheets ... and now wish to remove that This is what I have done : Double click the add in sent here, opened it on an active work book, saved the work book with the add in This is what I see : Tools - Add ins - shows the name of this add in This is

$$Excel-Macros$$ Re: VBA / Macro to Download pages listed on a column

Hi Subu This link can help you with Step 1 - http://www.excelitems.com/2009/03/access-search-engines-on-browser.html -- Thanks Regards Ashish Jain (Excel Macros - Google Group Manager) http://www.excelitems.com (Developer

$$Excel-Macros$$ hey thanks for your help

hi just wanted to ask how t make an addin and make it visible in excel 2007 and also can i use macro as add in or i have to create function to put as add in like a make a proper macro how can i put it as add in Thanks all Regards Ashish --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: How to remove an add in

Dear, Subu you can't delete addins permanently using tools menu. If you want to remove it permanently goto bellow address: C:\Documents and Settings\*Your User name*\Application Data\Microsoft\AddIns In addins folder delete the addin you want to remove. NOTE: You cannot delete inbuilt addins