$$Excel-Macros$$ help..

hi i want to concatenate a text like abc to a cell then paste tried this but not working abc Range(n i).text.Copy Destination:=Range(ca5) Thanks -- -- Some important links for excel users: 1. Follow us on

$$Excel-Macros$$ he need help

http://free.timeanddate.com/clock/i1wel3cw/n176/tt0http://www.linkedin.com/redirect?url=http%3A%2F%2Ffree%2Etimeanddate%2Ecom%2Fclock%2Fi1wel3cw%2Fn176%2Ftt0urlhash=mDaV HI i need a vba solution which will browse above site and assign its data a= cureent time whatever is there lets suppose

Re: $$Excel-Macros$$ need help urgently from excel to word

need help on this matter On Thu, Jan 28, 2010 at 6:47 PM, ashish koul koul.ash...@gmail.com wrote: hi i have a list in excel file with company name website etc, information a and want to put the same in word as i have given in the word format please can anyone give me the vba coding

$$Excel-Macros$$ Re: he need help

any help please On Fri, Jan 29, 2010 at 2:16 PM, ashish koul koul.ash...@gmail.com wrote: http://free.timeanddate.com/clock/i1wel3cw/n176/tt0http://www.linkedin.com/redirect?url=http%3A%2F%2Ffree%2Etimeanddate%2Ecom%2Fclock%2Fi1wel3cw%2Fn176%2Ftt0urlhash=mDaV HI i need a vba solution which

Re: $$Excel-Macros$$ need help urgently from excel to word

, this will help u ..u can see code there..adjust according to your need On 29/01/2010, ashish koul koul.ash...@gmail.com wrote: need help on this matter On Thu, Jan 28, 2010 at 6:47 PM, ashish koul koul.ash...@gmail.com wrote: hi i have a list in excel file with company name website etc

Re: $$Excel-Macros$$ Auto Filter using Macro or Formula

Hi check the attachment On Fri, Jan 29, 2010 at 8:43 AM, Sandip Patel myitems2...@gmail.com wrote: Hi Friends, I have 10,000 rows excel sheet which has many column as well. I want to create a Macro or Formula which will filter the data by *“Type”*, in the separate sheet, from the file

Re: $$Excel-Macros$$ Macro For Filter by Colour or Comments

hi check the attachment after this you can filter it manually or if you want it to be done by vba then let me know On Thu, Jan 28, 2010 at 11:27 PM, maulik desai mauliksde...@gmail.comwrote: Hi I want a macro that can do a filter data by comments filter data by colour -- Thanks Regards,

$$Excel-Macros$$ need help urgently from excel to word

hi i have a list in excel file with company name website etc, information a and want to put the same in word as i have given in the word format please can anyone give me the vba coding for the same regards ashish --

Re: $$Excel-Macros$$

hi find the attachment On Sun, Jan 24, 2010 at 9:57 PM, Shilpa Rao shilpa...@gmail.com wrote: Hi Team, Kindly help me in writing macro for a vlookup formula, since I have line item more thant 50k lines so I want get macro for this. Regards, Shilpa --

Re: $$Excel-Macros$$ How to Extract Data from a Line written in a cell.

Ichek it F(NOT(ISERROR(FIND(No.,A1))),MID(A1,FIND(No.,A1)+4,10),IF(NOT(ISERROR(FIND(No,A1))),MID(A1,FIND(No,A1)+3,10), )) On Tue, Jan 19, 2010 at 12:17 AM, Rahul Gandhi. myname.ra...@gmail.comwrote: Guys, I am facing some problem to Extract the A/c no. from Line written in Particular Cell.

Re: $$Excel-Macros$$ HELP needed for macro

based on material** and the diffidence of these fields should come in filed diff*.Hope you will help me.Thanking you in advance. aju v chacko On Sat, Jan 16, 2010 at 1:20 PM, ashish koul koul.ash...@gmail.comwrote: hi check it r u looking for this On Fri, Jan 15, 2010 at 10:28 PM, aju

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

hi check it On Thu, Jan 14, 2010 at 4:49 PM, kvc praveen kumar pkkara...@gmail.comwrote: Hello Vinod, PFA the soln to fill your column c using VBA. Please let me know in case you have any queries. Regards, Praveen On Thu, Jan 14, 2010 at 1:34 PM, vinod rao vinod.ma...@gmail.comwrote:

Re: $$Excel-Macros$$ Export from word to excel

thanks a lot for the solution can u please make it for notepad files too On Sun, Jan 10, 2010 at 3:02 PM, Alokeshwar Tiwary alokeshwar.tiw...@yahoo.com wrote: Criteria or parameters aren't necessory but it may not be extracting data in a useful format. I have modified the macro to Select

$$Excel-Macros$$ help required

hi Can someone please change this code as per my requirement . i want that if i am doing nothing in my workbook its idle lets say for 3 or 4 minutes its should automatically save and close it ...also let me know in which event i have to put the macro workbook open or activate , etc. Const

$$Excel-Macros$$ help required want to add oulook signature with logos in it

ho to insert outlook signature with logos in email while sending a mil from excel Sub SendWithAtt() Dim olApp As Outlook.Application Dim olMail As MailItem Dim i As Long Dim SigString As String Dim Signature As String Application.ScreenUpdating = False Set olApp =

$$Excel-Macros$$ help please urgently

hi please check the attached query its urgent thanks a lot regards Ashish -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2.

Re: $$Excel-Macros$$ help on .pdf to excel

can u please mail your file or also try free online pdf to excel converter websites first On Sun, Dec 20, 2009 at 11:31 AM, Dilip Pandey dilipan...@gmail.com wrote: Hi Pooja, It is something related with text capturing from an image (PDF) file which is beyond the capabilities of Excel,

Re: $$Excel-Macros$$ Concatenate after checking all cell

TEXT(IF(ISTEXT(B41)=FALSE,B41,IF(ISTEXT(C41)=FALSE,C41,IF(ISTEXT(D41)=FALSE,DC41,IF(ISTEXT(E41)=FALSE,E41,IF(ISTEXT(F41)=FALSE,F41,IF(ISTEXT(G41)=FALSE,G41,)),DD-MMM-) try this see whether it works for you o On Fri, Dec 18, 2009 at 10:51 AM, rf1234 rf1234 rfhyd1...@gmail.com wrote:

Re: $$Excel-Macros$$ Hide and unhide option

On Wed, Dec 2, 2009 at 8:20 AM, suresh k brave.sur...@gmail.com wrote: Dear Excel masters, Anyone know this solution or not? On Tue, Dec 1, 2009 at 1:12 PM, suresh k brave.sur...@gmail.com wrote: Hi Excel masters, I have created a macro for maintaining attendance. In sheet

$$Excel-Macros$$ non excel query

hi can any one give me a macro for mail merge with attachment Thanks -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2.

Re: $$Excel-Macros$$ Urgent!!!!!!!!!!

you have copied it from pdf file can u send that tooo On Mon, Nov 30, 2009 at 4:28 PM, amresh kumar amreshkushw...@gmail.comwrote: Hi My All Friends, please help me i want convert to attached image in excel format.if any solution please let me know ASAP Regards Amresh --

Re: $$Excel-Macros$$ Concatenate, including blank fields

hi CONCATENATE(IF(ISBLANK(A1), ,A1),IF(ISBLANK(B1), ,B1),IF(ISBLANK(C1), ,C1),IF(ISBLANK(D1), ,D1),IF(ISBLANK(E1), ,E1),IF(ISBLANK(F1), ,F1),IF(ISBLANK(G1), ,G1),IF(ISBLANK(H1), ,H1) also attached in workbook On Mon, Nov 23, 2009 at 2:31 PM, Steve sca...@aol.com wrote: I am trying

Re: $$Excel-Macros$$ hi need ur help

) Is the corrected formula. Regards, Andy On Thu, Nov 12, 2009 at 11:44 AM, ashish koul koul.ash...@gmail.comwrote: hi sir can u please check whats wrong in the formual want to do case sensitive vkooup thanks

$$Excel-Macros$$ hi help please

how can i go for case sensitive Vlookup and as well as using case sensitive in if condition thanks -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at

$$Excel-Macros$$ hi need ur help

hi sir can u please check whats wrong in the formual want to do case sensitive vkooup thanks -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at

$$Excel-Macros$$ wishing u all a happy and prosperous Diwali

thanks ashish --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel

$$Excel-Macros$$ help plz

inserting a blank row with matching value in a cell like when my cell vale in colm b is parent co i want to insert a blank row and shifting my data down Thanks Ashish --~--~-~--~~~---~--~~

$$Excel-Macros$$ HEY NEED HELP

8/3/2009 8/3/2009 8/3/2009 8/4/2009 8/4/2009 8/4/2009 5/8/2009 5/8/2009 5/8/2009 5/8/2009 5/8/2009 5/8/2009 THEY ARE IN DD MM I WANT TO CONVERT THEM INTO MM DD regards ashish --~--~-~--~~~---~--~~

i tried but it is not working Re: $$Excel-Macros$$ Re: HEY NEED HELP

, ashish koul koul.ash...@gmail.comwrote: 8/3/2009 8/3/2009 8/3/2009 8/4/2009 8/4/2009 8/4/2009 5/8/2009 5/8/2009 5/8/2009 5/8/2009 5/8/2009 5/8/2009 THEY ARE IN DD MM I WANT TO CONVERT THEM INTO MM DD regards ashish

$$Excel-Macros$$ hey also i was trying to convert these into date

plz help and also day, month function is not working in thsi file --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins

$$Excel-Macros$$ hi all backup code

hi i need a code which will automatically create a backup of my file at the location i specify to it thanks --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel

$$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$$ hi thanks for the help

hi can you please give ma codes which will remove the unwated or_ at the end of emailds in attachment thanks ashish --~--~-~--~~~---~--~~ -- Some important links for excel

$$Excel-Macros$$ hi daniel i was trying this code also but it is showing some errors can u check plzzzzzzzz

Sub test() Dim c As Range Dim x As Integer For Each c In Selection If c.Value Then c.Value = Application.Clean(c.Value) c.Value = Application.Trim(c.Value) c.Value = Application.Substitute(c.Value, , ) c.Value = LCase(c.Value)

$$Excel-Macros$$ Re: help plz

@googlegroups.com [mailto: excel-mac...@googlegroups.com] *On Behalf Of *ashish koul *Sent:* dimanche 6 septembre 2009 18:00 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Re: help plz hi thanks i went through the site i am able to clean and trim but in below case i am not abe

$$Excel-Macros$$ help plz

hi all hi can anyone give me code or macro to clean as well as trim my data in a sheet thanks ashish --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA

$$Excel-Macros$$ help needed

hi i need a code or macro who will clean unwanted spaces and character in the colums conatings email ids like ashish k...@gmail.com. result should be ashishk...@gmail.com koulashish @gmail.com...result should be koulash...@gmail.com koul.ashish @gmail.com result should be

$$Excel-Macros$$ Re: help needed

hi daniel i tried your code its working perfectly thanks but wht in this situation in attached sheet i want to remove all non wanted charters at the end of email ids... Thanks Ashish --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: help plz

hi thanks i went through the site i am able to clean and trim but in below case i am not abe to find the solution ashish k...@gmail.com. result should be ashishk...@gmail.com koulashish @gmail.com...result should be koulash...@gmail.com koul.ashish @gmail.com result should be

$$Excel-Macros$$ help

hi thanks for the solving the previous problem can u plz help me in this one too i was trying to use index and match but it gave me some error thanks ashish --~--~-~--~~~---~--~~

$$Excel-Macros$$ help plz

hi i want to apply vlookup formula to gind the age of person in the attached sheet in sheet 1 for example i want to find the age of rajesh and i don't know whther it is in sheet 2,or 3 or 4 .. have to search aal the sheets and give me the result thanks ashish

<    9   10   11   12   13   14