Re: $$Excel-Macros$$ multiple sheet reference..

Then you can use Global Vlookup Formula,provided by *Anil*. But it will very lengthy in case of 11 sheets. Syntax is here. in Excel 2007+ Version =iferror(*1st sheet vlookup*,iferror(*2ndsheet Vlookup*,iferror(*3rd Sheet Vlookup*,iferror(*4th Sheet Vlookup*...continue till 11 sheet

Re: $$Excel-Macros$$ multiple sheet reference..

Dear Mr. Ansari, thanks a lot for solution.. but i dont know that the particluar article place in which sheet. Means.. i cant select sheet from drop down list manually. Can you please advice how can i find that artilce from that 11 sheet by formula.? Thanks in advance. Regards Jafna kuwait. --

Re: $$Excel-Macros$$ Need Help for Access 2007- How to remove unwanted characters from table.

Use Clean function On Fri, Nov 9, 2012 at 12:09 AM, Mangesh Vimay wrote: > Hi Friends, > > I need your help. > I have Excel file containing some data. I have import this data to MS > Access 07 table by using Append query. > But when I access the table, it contains some un-wanted characters like

Re: $$Excel-Macros$$ VBA : Class does not support automation error.

Dear Amol , Pl share a sheet with group. Thanks & Regards, Gawli Anil On Fri, Nov 9, 2012 at 12:07 PM, Amol Jadhav wrote: > Hello Experts, > > > I need your expert advice. > > I created a tool using VBA form and OWC 10.0. I am exporting chart which > is on chartspace component(OWC 10.0). On so

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

Hey, I'm on break for exam n doesn't have access to my PC/Lalptop. I'll be able to see in to this not before sun eve or monday. If sum one can help then would be great!! Cheerz Thanks::Vabs Sent on my BlackBerry® from Vodafone -Original Message- From: Jayaprakash S Sender: excel-mac

Re: $$Excel-Macros$$ Required Unique data with funtion

How to achieve this thro' functions without manually sorting. Regards Eugene On Fri, Nov 9, 2012 at 11:56 AM, Kuldeep Singh wrote: > > Sure Priyanka, > > First Sort data then use formula. It's working fine. > > Regards, > Kuldeep Singh > > > On Fri, Nov 9, 2012 at 11:52 AM, Eugene Bernard > wr

Re: $$Excel-Macros$$ Required Unique data with funtion

Sure Priyanka, First Sort data then use formula. It's working fine. Regards, Kuldeep Singh On Fri, Nov 9, 2012 at 11:52 AM, Eugene Bernard wrote: > Dear Kuldeep, > > Is it possible to get the data in sorted order. > > Regards > Eugene > > > On Tue, Oct 30, 2012 at 12:05 PM, Kuldeep Singh > wro

Re: $$Excel-Macros$$ Required Unique data with funtion

Dear Kuldeep, Is it possible to get the data in sorted order. Regards Eugene On Tue, Oct 30, 2012 at 12:05 PM, Kuldeep Singh wrote: > > Dear Priyanka, > > See attached file. > > Regards, > Kuldeep Singh > Back Office Executive (MIS) > Info Edge India Limited (naukri.com) > > > On Tue, Oct 30,

Re: $$Excel-Macros$$ multiple sheet reference..

Dear Satiqja Anil Solution is excellent Apart of this, You can also try below formula with sheet name in List =VLOOKUP(F10,INDIRECT(TRIM(G6)&"!B:C"),2,0) see attachment for more clarity. On Fri, Nov 9, 2012 at 5:18 AM, satiqjaffar satiqjaffar < satiqjaffar...@gmail.com> wrote: > Hello brothe

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

Hi Vabz, Here with enclosing the file with VBA script which i'm currently using (it is working for manual stuff but fails when data linked to application)... the Data what i'm talking about is linked to application and it will get refreshed each second (Refer Yahoo-finance for more info on how th

$$Excel-Macros$$ Re: Need Help for Access 2007- How to remove unwanted characters from table.

Hi Mangesh, Can you plase share your workbook with us ? Regards Prince On Friday, November 9, 2012 12:09:18 AM UTC+5:30, Mangesh wrote: > > Hi Friends, > > I need your help. > I have Excel file containing some data. I have import this data to MS > Access 07 table by using Append query. > But

$$Excel-Macros$$ multiple sheet reference..

Hello brothers and sisters, first of all i want to convey my thanks to all for your great service on excel. Then i want to know how can i get multiple sheet (morethan 10) reference for vlookup.. please find the attachment of excel and advice the tric.. thanks in advance. Regards Jafna kuwait --

Re: $$Excel-Macros$$ Re: Magical Diwali Template (Excel Version)

Dear Ayush, When we double click on the sheet, Text began to move one by one. It has created by help of power-point presentation. and call through Insert-Object. On Thu, Nov 8, 2012 at 9:38 PM, Ayush Jain wrote: > Dear Noorain > > Please share, what is magical in this template > thanks > > -

$$Excel-Macros$$ Need Help for Access 2007- How to remove unwanted characters from table.

Hi Friends, I need your help. I have Excel file containing some data. I have import this data to MS Access 07 table by using Append query. But when I access the table, it contains some un-wanted characters like "question mark in square i.e. [image: Inline image 1]", etc. I want to remove these cha

Re: $$Excel-Macros$$ Required tutorials to learn Basics of DashBoards.

Hi Sandeep, You can visit www.dashboardspy.com or chandoo.org for learning the dashboards Noorain, I am not sure how the document that you shared will be helpful in learning dashboards. That attachment is specifically designed to guide "Digital Dashboard function in IMMEX" that may be som

$$Excel-Macros$$ Re: Magical Diwali Template (Excel Version)

Dear Noorain Please share, what is magical in this template thanks -Ayush Jain On Thursday, 8 November 2012 17:12:23 UTC+5:30, NOORAIN ANSARI wrote: > > Dear Group, > > Please find attached template and double click on it. > > > -- > With Regards, > Noorain Ansari > http:// >

RE: $$Excel-Macros$$ Accoount payable excel templates

May be B Sharma Can help you on this forum. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajasekhar Praharaju Sent: 08 November 2012 9:11 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$

$$Excel-Macros$$ Accoount payable excel templates

Hi friends, Please share the excel template of accounts payable if any one of u is having. basically i am planning to build up a template on accounts payable data in excel for forecasting and analysis. and need your experts advise. Please do share if any of you are having such stuff. Thanks in

Re: $$Excel-Macros$$ run macro from another file

ok found it   http://www.actuarialoutpost.com/actuarial_discussion_forum/showthread.php?t=210201   From: pawel lupinski To: "excel-macros@googlegroups.com" Sent: Thursday, November 8, 2012 1:34 PM Subject: $$Excel-Macros$$ run macro from another file Hi All,

RE: $$Excel-Macros$$ K.A. Mr.Rajan Verma: Help need to get multiple values by vlookup

I have just Change LookupRange.Address to LookupRange.Address(, , , 1) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kanwaljit Singh Sent: 08 November 2012 7:11 To: excel-macros@googlegroups.co

Re: $$Excel-Macros$$ K.A. Mr.Rajan Verma: Help need to get multiple values by vlookup

Dear Rajan, Kindly tell Exactly what changes or modifications you have made to the code ! On Thu, Nov 8, 2012 at 6:31 PM, Rajan_Verma wrote: > *You can use this one > > * > > *Function MLOOKUP(TableArray As Range, ByVal LookupVal, LookupRange As > Range, _* > > *

$$Excel-Macros$$ run macro from another file

Hi All,   I'd like to ask you for help. I'd like to run macro from different file. So I have master file where I have all data, this data a copied to another file and after that macro need to be run. issue is: each day name of the file is different so I can use stable one like   Application.Run

RE: $$Excel-Macros$$ Picture are not showing help req.

Is it picture format ? If it is you need a software to open those file.. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of neeraj chauhan Sent: 08 November 2012 5:49 To: excel-macros@googlegroups.co

Re: $$Excel-Macros$$ Required tutorials to learn Basics of Dashboards.

Dear Sandeep, Please use below link How to create Excel Dashboards http://www.contextures.com/excel-dashboards.html http://www.exceldashboardwidgets.com/ On Thu, Nov 8, 2012 at 4:52 PM, Kuldeep Singh wrote: > > Hi Sandeep, > > See below link: > > http://chandoo.org/wp/excel-dashboards/ > > Re

RE: $$Excel-Macros$$ K.A. Mr.Rajan Verma: Help need to get multiple values by vlookup

You can use this one Function MLOOKUP(TableArray As Range, ByVal LookupVal, LookupRange As Range, _ Optional ByVal NthMatch As Long) ' Author: Krishnakumar @ ExcelFox.com ‘Modified by :- Rajan Verma @ ExcelPoweruser.wordpres

$$Excel-Macros$$ Picture are not showing help req.

Dear Experts, kindly see the atached snaps, which are not showing. kindly convert -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Ple

RE: $$Excel-Macros$$ Vlookup Book

Sure... thanks a lot. Best Regards, Amit From: NOORAIN ANSARI [mailto:noorain.ans...@gmail.com] Sent: 08 November 2012 16:47 To: Amit Desai (MERU) Cc: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Vlookup Book Dear Amit, I am still committed on my words. But I need some more time

$$Excel-Macros$$ Re: Chart stuff

Yes On Thursday, 8 November 2012 00:33:40 UTC+5:30, santosh wrote: > > Hello, > > Can the graph in the attchment be modified as per the below table. > > If so would request you to please help me with this > > Group110% > Group220% > Group330% > Group415% > Gr

Re: $$Excel-Macros$$ Required tutorials to learn Basics of Dashboards.

Hi Sandeep, See below link: http://chandoo.org/wp/excel-dashboards/ Regards, Kuldeep Singh On Thu, Nov 8, 2012 at 4:45 PM, Sandeep Chhajer wrote: > Dear Excel gurus, > > How to use this tutorials? Nothing has been provided in this to make excel > dashboards. > > ** ** > > *Thank you >

Re: $$Excel-Macros$$ Vlookup Book

Dear Amit, I am still committed on my words. But I need some more time to complete it perfection and after completing it I will definitely share it with group without any further reminder. Kindly don't mark any mail to my official ID. -- With Regards, Noorain Ansari http://

RE: $$Excel-Macros$$ Required tutorials to learn Basics of Dashboards.

Dear Excel gurus, How to use this tutorials? Nothing has been provided in this to make excel dashboards. Thank you Regards Sandeep Kumar Chhajer. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 08 November 2012 11:28 To:

Re: $$Excel-Macros$$ Required tutorials to learn Basics of DashBoards.

Thank you sir. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI Sender: excel-macros@googlegroups.com Date: Thu, 8 Nov 2012 11:27:38 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required tutorials to learn Basics

RE: $$Excel-Macros$$ Vlookup Book

Dear Noorain, Could you please share the Vlookup book if it is prepared at your end? Best Regards, Amit From: Amit Desai (MERU) [mailto:amit.de...@merucabs.com] Sent: 02 November 2012 16:46 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Vlookup Book Dear Noorain, Are you bac

$$Excel-Macros$$ sum base on condition

Hi All, Can you help me on this example. I’m looking for excel function that will be summarized what I have to buy and I’ve bought already. I have table with requirements. On this base I’m ordering components from different suppliers. For my budget I need to know how much I’ve already paid and