$$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

$$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 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$$ 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$$ 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 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 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$$ 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$$ 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$$ 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

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

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$$ 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 --

$$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$$ 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$$ Find Distance and Time between two cities using Google Map In excel

Hi Group Try this udf it will help you in finding the time and distance between two cities using Google Map -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

-macros@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread

Re: $$Excel-Macros$$ Help Please

. -- To post to this group, send email to excel-macros@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986

Re: $$Excel-Macros$$ Code for extracting google search results in excel

it on box.net please download it from above link) Also check Ron's (Excel Genius) Google search Addin http://www.rondebruin.nl/Google.htm Regards, Ashish Koul On 3/30/12, seema mba seema.mba2...@gmail.com wrote: Hi, I have a sheet with the list of companies.I want a code which picks up

Re: $$Excel-Macros$$ Need Power point code help

to excel-macros@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate

Re: $$Excel-Macros$$ Looking for Excel/Access vba job with 6 years of experience

* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ Need help with code to automate copy/paste

to excel-macros@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise

Re: $$Excel-Macros$$ AN URGENT HELP ON GRAPH

to this group, send email to excel-macros@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1

$$Excel-Macros$$ Happy Birthday Ayush

*Wishing you a Happy Birthday * -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use

$$Excel-Macros$$ Group Suggestion Feedback

Hi Ayush Can we add unsubscribe link (and steps to unsubscribe) in the signature of the group . Like we have forum rules. Also it would be great if you can show it on home page of dicussexcel.com too. -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http

Re: $$Excel-Macros$$ Code for range shifting based on month

or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *Regards* * * *Ashish

$$Excel-Macros$$ JOB Fwd: Excellent opportunity for VBA Developers / Specialist (Coding) , Polaris Financial Technology, Pune -Need Immediate Joinees.

is strictly prohibited. Visit us at http://www.polarisFT.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED

Re: $$Excel-Macros$$ REMOVE ME

. -- To post to this group, send email to excel-macros@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before

Re: $$Excel-Macros$$ Apportioned of Expenses

for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http

Re: $$Excel-Macros$$ unable to use advance vlookup

or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *Regards* * * *Ashish Koul

Re: $$Excel-Macros$$ Converting from a single column to different rows

to excel-macros@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise

Re: $$Excel-Macros$$ Need to protect my excel workbook

in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *Regards* * * *Ashish Koul* *http

$$Excel-Macros$$ Job: An opening from Bank of America-Gurgaon.(Report preparation)

written by Experts. Call 1800-102-5557 now! (Toll-Free) -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1

Re: $$Excel-Macros$$ VBA code required to save the data from textbox

or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *Regards* * * *Ashish Koul* *http

Re: $$Excel-Macros$$ CONVERT PDF FILE IN TO EXCEL

-- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ Double click Bar Charts

to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use

Re: $$Excel-Macros$$ Double click Bar Charts

Drill down Charts. Thanks and regards, Pankaj Michael On Tue, May 22, 2012 at 7:42 AM, ashish koul koul.ash...@gmail.comwrote: can you share the sample data On Tue, May 22, 2012 at 7:40 AM, pankaj gmail account pankaji...@gmail.com wrote: Dear Gurus, I want to create a chart with click

Re: $$Excel-Macros$$ wildcard

. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before

Re: $$Excel-Macros$$ Copy Validation while splitting workbooks

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already

Re: $$Excel-Macros$$ adjusting graph

. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before

Re: $$Excel-Macros$$ How to find paritcular word from sentence

to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about

Re: $$Excel-Macros$$ Kindly help on multiplication table macro

. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http

Re: $$Excel-Macros$$ How to find paritcular word from sentence

*check the attachment see if it helps * On Sun, Jun 3, 2012 at 2:09 PM, SUDHIR VERMA newinex...@gmail.com wrote: Dear Ashish, Thank you so much and Please can u explain this for understanding me. thanking you On 03/06/2012, ashish koul koul.ash...@gmail.com wrote: check the attachment

Re: $$Excel-Macros$$ Date format

...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles

Re: $$Excel-Macros$$ Text Cleaning

-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise

Re: $$Excel-Macros$$ Text Cleaning

%2bunsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise

Re: $$Excel-Macros$$ Extract Names from different sheet into one sheet

. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http

Re: $$Excel-Macros$$ Extract Names from different sheet into one sheet

to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use

Re: $$Excel-Macros$$ Extract Names from different sheet into one sheet

activate the macro to extract, i get a debug error @ Noorain, i get a compile error when i run the code. i guess formula wont work for this type of problem. thanks On Wed, Jun 6, 2012 at 4:30 PM, ashish koul koul.ash...@gmail.com wrote: please find the updated file as it will treat first

Re: $$Excel-Macros$$ Need a file on commonly used Formulas and Functions for MS Excel 2010

...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

: On Fri, Jun 29, 2012 at 9:19 PM, ashish koul koul.ash...@gmail.comwrote: can you attach the sample file On Fri, Jun 29, 2012 at 9:18 PM, jmothilal gjmothi...@gmail.com wrote: Dear any one I want 3 cell values in 1 cell line by line Thanks in advance like MOTHILAL NAVEEN RAJA MOTHILAL

Re: $$Excel-Macros$$ How to get Min rate Which is greater than zero

. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http

Re: $$Excel-Macros$$ Macro to populate Output file

. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

extremely happy to inform you that two members of the group are awarded Microsoft Most Valuable Professional Award. My heartiest congratulations to *Ashish koul* and *Dilip Pandey* and thanks for their big support to this forum. Keep posting ! Best regards, Ayush Jain Group Manager Microsoft MVP

Re: $$Excel-Macros$$ Query on Email via macro

. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com

Re: $$Excel-Macros$$ How to get Min rate Which is greater than zero

a and rate b With Regards, Haris na.har...@gmail.com On 1 July 2012 11:13, Haris na.har...@gmail.com wrote: Thank you so much* Mr. Ashish koul.* This is what i exactly looking for. I appreciate your generous support. With Regards, Haris na.har...@gmail.com On 1 July 2012 09:53, ashish

Re: $$Excel-Macros$$ Macro to populate Output file

Mismatch. Thank you to a prompt response. On Mon, Jul 2, 2012 at 4:25 PM, OJEMENI Uzoma uojem...@gmail.com wrote: Thank you Ashish. The macro worked perfectly. On Mon, Jul 2, 2012 at 3:02 PM, ashish koul koul.ash...@gmail.comwrote: try this see if it helps Sub create_txtfile() Dim arv

Re: $$Excel-Macros$$ CTRL+D macro

to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use

Re: $$Excel-Macros$$ Need Urgent Help on If statement

...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ help regarding range selection from worksheet

. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http

Re: $$Excel-Macros$$ Mails IDs from Outlook

. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http

Re: $$Excel-Macros$$ drawing chart based on the given data

to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use

Re: $$Excel-Macros$$ drawing chart based on the given data

-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment

Re: $$Excel-Macros$$ Spreadsheet for IST to BST and BST to IST

. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* * * *Join Us On Facebook

Re: $$Excel-Macros$$ How Offset function Works

-- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help

Re: $$Excel-Macros$$ Re: to insert rows ,rows inserted should be equal to integer in corresponding cell in the top row

. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http

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$$ 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,

$$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.

$$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 =

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

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$$ 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$$ 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$$

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 --

$$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 --

$$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$$ 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$$ need help

hi i have a input in sheet 1 and its not limited and want result in sheet2 like in col1 regards ashish -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

$$Excel-Macros$$ Re: need help

any help On Thu, Feb 4, 2010 at 8:46 PM, ashish koul koul.ash...@gmail.com wrote: hi i have a input in sheet 1 and its not limited and want result in sheet2 like in col1 regards ashish -- -- Some

Re: $$Excel-Macros$$ how to copy a particular column at a particular time to a new sheet

Private Sub Workbook_Open() Application.OnTime TimeValue(21:59:00), time1 End Sub Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Application.OnTime TimeValue(11:00:00), time1 End Sub Sub time1() Application.OnTime TimeValue (11:00:00), time1

$$Excel-Macros$$ help

how can i save a active word doucmtn in we page fromat in vba what changes i have to make in below code ActiveDocument.SaveAS FileName:=(C:Program FilesWill WizardTemplates emp Trim(Str(TMPNum)) .doc) -- --

Re: $$Excel-Macros$$ books for learning excel vba

http://www.esnips.com/_t_/writing%20excel%20macro?m=0q=writing%20excel%20macro check this site and download books On Sat, Feb 13, 2010 at 7:20 PM, Umesh Matkar matkarum...@gmail.com wrote: Dear Excel Guru’s /Masters can u please suggest me some books for learning excel vba / macro ..from

Re: $$Excel-Macros$$ Copy data from diff. sheets

hi check the attachment Sub Macro1() Dim I As Long Dim J As Integer Dim N, Z As Long Dim x As String Worksheets(1).Activate Range(a1).Select Selection.End(xlToRight).Select Dim temp As String temp = ActiveCell.Address x = Mid(temp, 2, (InStr(2, temp, $) - 2)) For J = 2 To

Re: $$Excel-Macros$$ Rename the files

hi check the attachment are you looking for this also just to avoid writing that 111 222 manually can u tell us how account no are related top file names can u provide few examples of file names and is it fixed that sbi is having 111 or hsbc 222 On Thu, Feb 18, 2010 at 4:11 PM, Chidurala,

  1   2   3   4   5   6   7   8   9   10   >