Re: $$Excel-Macros$$ Required editable maps in Excel

visit these links http://www.clearlyandsimply.com/clearly_and_simply/choropleth-maps/ http://www.clearlyandsimply.com/clearly_and_simply/2009/06/choropleth-maps-with-excel.html http://www.clearlyandsimply.com/clearly_and_simply/2009/06/multicolored-choropleth-maps-with-excel.html Regards Ashish

Re: $$Excel-Macros$$ i want fix the given value in the rows

Thanks sir it working what i am expecting . Thanks with mothilal On Sat, Jul 6, 2013 at 2:50 PM, ravinder negi wrote: > PFA,...please advise if any changes needed. > > --- On *Sat, 7/6/13, jmothilal * wrote: > > > From: jmothilal > Subject: Re: $$Excel-Macros$$ i want fix the given value in t

Re: $$Excel-Macros$$ SAVE As file name

Hi, Paste the code in a module and try to execute again. I will attach the working excel if possible. Thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Autofilter criteria

Hi All, Please assist with Auto filter Here the data is limited only few lines as sample i have given. but in reality data will more two lac lines .. can you please place even if data rows count increases. i tried for vlookup like dis Range("F2").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(

$$Excel-Macros$$ Creating a personalized "data" form (VBA/Macros) - To add, retrieve, modify & delete info

I find it very easy to create forms that allow you to enter information. Creating a form that generates reports or a form that retrieves "profiles" or information is another story... I want a main form that is always opened (I've seen the codes for this before, not a major issue) and I want it

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

This group becomes special and the popular in a very small span of timebecause of the members like you and others. Thanks a lot !!! On 7/6/13, vba wrote: > Thanks for Acknowledgement.. Cheers!! > > > On Sat, Jul 6, 2013 at 5:50 PM, Mangesh Vimay > wrote: > >> Thanks you both for your great h

Re: $$Excel-Macros$$ Validation through Macro!!!

Hi Indrajit, You have asked something diff.. PFA sheet where i have set restrictions for few cases.. I hope you can manage show for rest cases.. Let me know if you need further help. How it works: Set min & max value in sheet 1 & error message . As soon as you select any cell in sheet 2, ce

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

Thanks for Acknowledgement.. Cheers!! On Sat, Jul 6, 2013 at 5:50 PM, Mangesh Vimay wrote: > Thanks you both for your great help. > > Ravinder, > > I didn't get what you said. Do I need to use the mentioned formula in > data validation box? > > Please suggest. > > On 7/6/13, ravinder negi wrote

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

Thanks you both for your great help. Ravinder, I didn't get what you said. Do I need to use the mentioned formula in data validation box? Please suggest. On 7/6/13, ravinder negi wrote: > PFAtry this and advise if this does not work propery.. you just need to > copy paste formula in valida

Re: $$Excel-Macros$$ required Result on Conditions

From: Rakesh Kumar Sharma To: MS EXCEL AND VBA MACROS Sent: Thursday, 4 July 2013 11:42 AM Subject: $$Excel-Macros$$ required Result on Conditions Dear Experts, I want Result on  conditions. Pls find the attachment. -- Regards, Rakesh Kumar Sharma

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

Simply Great !!! Could you please share final workbook. Sorry, for this. Thanks a ton !!! On 7/6/13, vba wrote: > Hi > > You dont have to create name, this will be created programatically for data > in DATA sheet. > > Just copy paste B2 or drag down. > > > Hoe Name is created by this Macro: >

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

Hi You dont have to create name, this will be created programatically for data in DATA sheet. Just copy paste B2 or drag down. Hoe Name is created by this Macro: First Data sheet is sort on the basis of ID; then unique ID is pasted in range J2 & downwards. Then Name is defined for each ID begi

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

Hi, Thanks for the help. But, how to create data validations in the first sheet based on the list which you have retrieved by using code. Please help. On 7/6/13, vba wrote: > Hey > > PFA. > > HTH > > > On Sat, Jul 6, 2013 at 11:20 AM, Mangesh Vimay > wrote: > >> Hi Be Tran Van, >> >> Thank you

$$Excel-Macros$$ Required editable maps in Excel

Hi Friends, I required editable map of EMEA Region or atleast by Continents in excel. With Regards, Putta Madaiah -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexce

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

Hey PFA. HTH On Sat, Jul 6, 2013 at 11:20 AM, Mangesh Vimay wrote: > Hi Be Tran Van, > > Thank you for your quick help. > > However, in my original workbook there are total 1200 lists and its > quite time consuming job to create named range for all 1200 lists and > then to specify the source f