Re: $$Excel-Macros$$ Re: Help Required!

Hi, This works great. Thanks for your efforts and help. Though I have a small need as well. The code gives the output through message box. Due to this I am unable to copy the value (i.e) Output. Also the code is only execute for the input AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR. What

Re: $$Excel-Macros$$ data cleaning in excel

Good solution Dililp, The data scenario sure presents the conflict you have mentioned. What can be done to work around it? Warm regards, Anand Kumar anand...@gmail.com On Oct 27, 11:26 am, SAJID MANSOOR sajidmansooral...@gmail.com wrote: Good! On Sun, Dec 13, 2009 at 6:01 PM, Dilip Pandey

$$Excel-Macros$$ Parsing a range to an array

Hi Everyone, I am building a series of wizards for handling some internal processes at my office. We are extracting data from from '3rd party' data sources into excel worksheets. To further process this data by hand is slow, so I was asked to write a few macros etc to speed things up. The issue I

$$Excel-Macros$$ Re: New Member

Welcome Ted, Please feel free to post your queries. Hope we all learn together Warm regards, Anand Kumar On Oct 26, 7:47 pm, Ted suicid...@gmail.com wrote: Hi, just joined the group to take a look at what I could learn.  I'll be posting any questions I have shortly. --

RE: $$Excel-Macros$$ Parsing a range to an array

Hi, You can test for a non-contiguous selection with the following line of code: A = Selection.Areas.Count Use this in an If statement - eg If Selection.Areas.Count 1 then msgbox You can't use non-contiguous cells.: Exit Sub Hope this helps. Regards - Dave. Date: Thu, 28 Oct 2010

Re: $$Excel-Macros$$ manage lengthy database

hi Ashish Thanks for ur reply, but i am using windows XP,I coukdn't open the file u send.let me know what to do. Regards Rajesh On 10/28/10, ashish koul koul.ash...@gmail.com wrote: check the attachment for custom filter on dates. in case you are using background colors . On Wed, Oct 27,

Re: $$Excel-Macros$$ Re: Help Required!

I don't understand which linguage do you use? In visual basic as I have proposed is a function you can pass any text and use its result regards r 2010/10/28 amrahs k amrahs...@gmail.com Hi, This works great. Thanks for your efforts and help. Though I have a small need as well. The

RE: $$Excel-Macros$$ How to consolidate the data using macro

Hi Excel Gurus, I would like to prepare the consolidated file on daily basis using macro. I am using excel 2010. My team is working daily on some excel files(around 25-50 files). All excel files are save in a particular folder on daily basis with name containing the date stamp. I would like

Re: $$Excel-Macros$$ Excel Date format dd/mm/yyyy hh:mm:ss

Hi, Forst Select your dat then go to format in the Home Menu(if your using Excel 2007) or format if you are using older versions.In the format menus dialog box you can select date formats as you like.At the last the is Customs format. If you select that and specify what ever type of format you

Re: $$Excel-Macros$$ data cleaning in excel

Hi, You can download an add-in called asUltimate add-in which is available for Excel @007 and for older versions also(Excel 2000.2003,2005 etc). It contains a tool called Duplicate remover. There are also mainy other very useful tool in that add-in which will be very useful to you.But make sure

Re: $$Excel-Macros$$ manage lengthy database

Hi Rakesh, You can also change gridline colour or give colours to the cells in which you want to see your Cursor.To change thecoulour of gridline(if you are using excel 2007) Go to the Excel ribbon Button then go to the Excel option Button In that go to that advanced option. In that advanced

Re: $$Excel-Macros$$ How to consolidate the data using macro

try attached file see if it helps . On Thu, Oct 28, 2010 at 3:46 PM, Hiren Sheth hiren.sh...@viteos.com wrote: Hi Excel Gurus, I would like to prepare the consolidated file on daily basis using macro. I am using excel 2010. My team is working daily on some excel files(around 25-50

Re: $$Excel-Macros$$ manage lengthy database

Sub applyfilter() If ActiveSheet.AutoFilterMode = True Then ActiveSheet.AutoFilterMode = False End If ActiveSheet.Range($A$1:$B$27).AutoFilter Field:=2, Criteria1:= _ =10/31/2010, Operator:=xlAnd, Criteria2:==11/18/2010 End Sub Sub RemoveFilter() If ActiveSheet.AutoFilterMode = True

RE: $$Excel-Macros$$ How to consolidate the data using macro

Perfect solution sir. Thanks a million. Regards Hiren From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ashish koul Sent: Thursday, October 28, 2010 8:07 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to consolidate the data using

Re: $$Excel-Macros$$ Non-Uniform Random Number Generator

Hello! If you have your distribution 1 to 1000 for exemple. So, do =*RANDBETWEEN*(1:1000) Sorry if I posibly understand wrong Best Regards André Luiz D´Avila - Auditor Moore Stephens Audit 2010/10/27 busboy10 andrew.var...@gmail.com Hi All, Trying to do some modeling where I would like Excel