Re: $$Excel-Macros$$ need your help on Validation

to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My

Re: $$Excel-Macros$$ TOUGHEST Query to Solve

://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com

Re: $$Excel-Macros$$ Macro to Sort

/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Conditional copy and row insert based on criteria

and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot

Re: $$Excel-Macros$$ Fwd: insert a blank row

/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Sort

-- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ How to protect a cell based value in other cell

to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http

Re: $$Excel-Macros$$ Selecting specified information from within a cell under a condition and paste that information to a second sheet

http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing

Re: $$Excel-Macros$$ Fwd: Help required for formule

/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Queries

our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com

Re: $$Excel-Macros$$ Again Doubt in project

Sub On Sun, Nov 28, 2010 at 3:47 PM, SAJID MEMON sajidwi...@hotmail.com wrote: dear Dilip ashish koul Sheets(Dump).Range(a1:D65356).Clear If i do the above line in attached project then entire data will be deleted. My doubt is only pink color data display should be deleted from dump

Re: $$Excel-Macros$$ select the specified sheet

To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul

Re: $$Excel-Macros$$ PROJECT DOUBT

on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10

Re: $$Excel-Macros$$ **URGENT**Help Required

Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http

Re: $$Excel-Macros$$ Need Urgent Help

our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com

Re: $$Excel-Macros$$ Re: Convert PDF files to RTF File.

our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com

Re: $$Excel-Macros$$ VBA Code Required

our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http

Re: $$Excel-Macros$$ Problem with Identify WorkSheet

@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http

Re: $$Excel-Macros$$ seqence no using vba macro

to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http

$$Excel-Macros$$ Re: Thanks

check sheet 3 for macro solution sheet 1 for text data sheet 2 for numeric data On Fri, Nov 12, 2010 at 9:38 AM, Manjunath C cmanjunathchen...@gmail.comwrote: Thanks a lot Ashish koul, Is it possbile to get the answeres in vertical ones, 1.what will happen if lookup data is in alphabet

Re: $$Excel-Macros$$ Re: OPEN EXCEL - Needs your support and enthusiasm...

follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P

Re: $$Excel-Macros$$ LOOK

?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Re: Excel Encyclopedia ppt

page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub

Re: $$Excel-Macros$$ Conditional Formatting

://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think

Re: $$Excel-Macros$$ Attention Please

/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about

Re: $$Excel-Macros$$ FW: is there a printer installed on this computer?

on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish

Re: $$Excel-Macros$$ Fwd: Delete rows from a Sheet based on value found on previous cell

Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

$$Excel-Macros$$ Wishing you all A Very Happy Diwali...

Wishing you all A Very Happy Diwali... -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

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

-4144 6339 / 6340 Email - shrinivas.chidur...@citi.com -- *From:* excel-macros@googlegroups.com [mailto: excel-mac...@googlegroups.com] *On Behalf Of *ashish koul *Sent:* Sunday, October 31, 2010 6:04 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel

Re: $$Excel-Macros$$ moving data to another sheet by using vba macro

email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http

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

End If ActiveSheet.Range($A$1:$B$27).AutoFilter Field:=2, Criteria1:= _ =$d$1, Operator:=xlAnd, Criteria2:==$e$1 End Sub Regards Rajesh Kainikkara On 10/28/10, ashish koul koul.ash...@gmail.com wrote: Sub applyfilter() If ActiveSheet.AutoFilterMode = True

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

=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

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

://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing

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

://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http

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

HI use it ony if you are not using any background colors in file code: Private Sub Worksheet_SelectionChange( ByVal Target As Range) Columns(2).Interior.ColorIndex = xlNone Cells(ActiveCell.Row, 2).Interior.Color = vbYellow End Sub On Mon, Oct 25, 2010 at 9:32 PM, ashish koul koul.ash

Re: $$Excel-Macros$$ VLOOKUP PROBLEM

values but data in large no of lines then what? On Oct 14, 9:06 pm, ashish koul koul.ash...@gmail.com wrote: hi check the attachment see if it helps you you can apply customer filter on temp column and choose greater than 1 and copy all and paste into sheet2 On Thu, Oct 14, 2010

$$Excel-Macros$$ excel vba opening

Hi, Prithvi Information Solutions Ltd is a global provider of enterprise solutions and services that strategically harness the power of Information Technology to help customers maximize their business values in the new economy. Prithvi has offices in USA, Canada, United Kingdom, Singapore, and

Re: $$Excel-Macros$$ VLOOKUP PROBLEM

* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

$$Excel-Macros$$ received a mail regarding job opening see if anyone intrested in it

DynPro specializes in helping companies build infrastructures that can weather the most fierce storms by focusing on strong fundamentals: appropriate and effective systems, the right people, and proven business processes. Our worldwide force of technology and business experts can identify the

Re: $$Excel-Macros$$ excel macro to remove shadow from shapes

to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http

Re: $$Excel-Macros$$ How to eliminate Zeros

page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http

Re: $$Excel-Macros$$ Help: Getting data from website into .xls

-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830

Re: $$Excel-Macros$$ Formula for Last Leave Date

* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Formula for Last Leave Date

* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Clear cookies, cahce

about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My

Re: $$Excel-Macros$$ An excel data entry problem

have u checked that attachment its working fine at my place -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about

Re: $$Excel-Macros$$ An excel data entry problem

no problem welcome. On Wed, Sep 8, 2010 at 5:38 PM, api gud aparnagud...@gmail.com wrote: Sorry for the inconvenience. I have disabled the macros..that was not able to run the macro attached. Now its working perfectly. Thanks Ashish On Sep 8, 8:19 am, ashish koul koul.ash

Re: $$Excel-Macros$$ Examine data in rows and move some to columns

check the attachment see if it helps you.. Regards Ashish koul akoul.blogspot.com On Tue, Sep 7, 2010 at 4:26 AM, Bad at VBA non.at...@gmail.com wrote: Hi everyone, I've got data that shows build information vertically in rows down a column, but my users would prefer to see some

Re: $$Excel-Macros$$ Need Solution

see if this helps you regards ashish koul akoul.blogspot.com On Tue, Sep 7, 2010 at 12:49 AM, Idhrees Mohamed idhrees...@gmail.comwrote: Dear Guys I have two column, job no value. In this i need particular job no with the total value in serial wise. Can anybody help me. (I attach sample

Re: $$Excel-Macros$$ Top Poster of the month :- Dave Bonallack

Thanks Dave.. for all the support... Regards Ashish Koul akoul.blogspot.com On Fri, Sep 3, 2010 at 3:43 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Congratulation Dave for your valuable support. Keep it up... Thanks, Noorain Ansari On Fri, Sep 3, 2010 at 10:31 AM, Ayush jainayus

Re: $$Excel-Macros$$ Help in Separate the Num Alpha in a cell into another two cells

check the attachment if it helps On Sun, Aug 29, 2010 at 1:21 PM, Dave Bonallack davebonall...@hotmail.comwrote: Hi, Unfortuneately, your data is not as it appears. On the workbook you posted, select cell B5. Look in the formula bar (just above the Column headers) You will see: *180.5*

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

in reference select Microsoft outlook Regards Ashish koul akoul.blogspot.com On Fri, Aug 27, 2010 at 10:06 AM, amrahs k amrahs...@gmail.com wrote: Hi Koul, Thanks a lot for your effort and time. I have a response for the below code. I get compile error: Can't find project or library

Re: THANK YOU $$Excel-Macros$$ Lookup Multiple values and display horizontally

welcome dear. Regards Ashish koul akoul.blogspot.com 2010/8/27 ҉Shine shin...@gmail.com Hi Ashish, Bruno Maries Thanks a lot I appreciate your help. All the three solutions work. Thank you :) Shine On 25 August 2010 05:06, Bruno Bruno brunobbr...@gmail.com wrote: See

Re: $$Excel-Macros$$ Lookup Multiple values and display horizontally

HI see if this helps you regards ashish koul akoul.blogspot.com 2010/8/24 ҉Shine shin...@gmail.com Thank you Ashish. I appreciate your effort and time you spent for it. But I am looking for a combination function that can do the job. VBA cannot be used Thank you Best Regards Shine

Re: $$Excel-Macros$$ Lookup Multiple values and display horizontally

regards ashish koul akoul.blogspot.com On Mon, Aug 23, 2010 at 5:32 PM, shin...@gmail.com wrote: Attached: Lookup Multiple values and display horizontally Message from shin...@gmail.com: Hi It would be helpful if someone can provide a solution without using VBA I have a series of data

Re: $$Excel-Macros$$ sending e mail based on data in column in excel

check the attachment see if it helps you Regards Ashish koul http://akoul.blogspot.com/ On Sat, Aug 21, 2010 at 10:31 AM, Chandra Gupt Kumar kumar.bemlmum...@gmail.com wrote: Could you please share how it is possible. Regards, C.G.Kumar *From:* excel-macros

Re: $$Excel-Macros$$ sending e mail based on data in column in excel

vbCrLf Congrats message vbCrLf ActiveSheet.Range(e I).Text .Display '.send End With Set olMail = Nothing End If Regards Ashish koul http://akoul.blogspot.com/ On Sat, Aug 21, 2010 at 10:31 AM, Chandra Gupt Kumar kumar.bemlmum...@gmail.com wrote: Could

Re: $$Excel-Macros$$ Rupee symbol on PC

To install font download it copy rupee font file - Go To RUN- TYPE FONTS- PRESS ENTER- PASTE THE RUPEE FONT FILE On Sat, Aug 21, 2010 at 7:44 PM, ashish koul koul.ash...@gmail.com wrote: check the attachment regards ashish koul akoul.blogspot.com On Sat, Aug 21, 2010 at 6:57 PM

Re: $$Excel-Macros$$ Removing selected letters and symbols from a cell

check the attachment Regards Ashish akoul.blogspot.com On Wed, Aug 18, 2010 at 5:21 PM, Alexander Cargill zanderman1...@googlemail.com wrote: Hi all I was wondering if you could help. I have a sheet with entrys into a cell that looks like this: AAECHO::DELTA (422|279) K24

Re: $$Excel-Macros$$ Google Translator Using VBA - HELP !!!

=SUMIF(C456:F456,#N/a) or =SUMIF(C456:F456,0)+SUMIF(C456:F456,0) regards ashish koul akoul.blogspot.com On Thu, Jul 15, 2010 at 11:27 AM, preeti vora preeti86v...@gmail.comwrote: Hi is that any formula when we do sum formula but some time in our data #N/A in list that's WY we not able

Re: $$Excel-Macros$$ Re: WAV FILES DURATION FINDER

See if this helps you http://www.webandmacros.net/excel-macro-list-files.htm Regards Ashish koul http://akoul.blogspot.com On Fri, Jul 9, 2010 at 6:26 PM, Bhasker bhask...@gmail.com wrote: Hi I am a medical transcriptionist by profession, I am in requirement of one tool where i can find

Re: $$Excel-Macros$$ Urgent help....

check the attachment =A2,B2 regards ashish koul http://akoul.blogspot.com/ On Mon, Jul 5, 2010 at 5:59 PM, Ankit Chandna ankit.chan...@yahoo.inwrote: Hi, hi to all ..i need a help PFA and help me to get reqired result. Regards, Ankit

Re: $$Excel-Macros$$ EXRACT WHOLE TEXT AND NUMBER

extractalltext = text1 End Function Regards Ashish koul akoul.blogspot.com On Sun, Jul 4, 2010 at 10:25 AM, memonkavi memonk...@gmail.com wrote: DEAR SIR PLS ME I NEED EXRACT WHOLE TEXT AND NUMBER DIFFERENT CELLS WITH ONE FUNCTION OR TWO REGRADS KAVI NOTE -HOW

Re: $$Excel-Macros$$ Fwd:

hi dave can you explain the formula how it is working =FIND(CHAR(1),SUBSTITUTE(A1, ,CHAR(1),LEN(TRIM(A1))-LEN( SUBSTITUTE(A1, , On Fri, Jul 2, 2010 at 10:29 PM, praveen kumar bhspra...@gmail.com wrote: Here with have attached one pdf file. from that if i copy paste data to excel then

Re: $$Excel-Macros$$ Fwd:

Thanks a lot Dave. On Sat, Jul 3, 2010 at 2:22 PM, Dave Bonallack davebonall...@hotmail.comwrote: Hi, A1 = *United States of America* =FIND(CHAR(1),SUBSTITUTE(A1, ,CHAR(1),LEN(TRIM(A1))-LEN(SUBSTITUTE(A1, , Firstly, we need to find out how many spaces there are in the text. We do

Re: $$Excel-Macros$$ Looking for password prompt before user can execute macro

On Sun, Jun 27, 2010 at 12:10 PM, ashish koul koul.ash...@gmail.com wrote: hi check the attachment instead of calling abc here you call the macro you have recorded . let me know in case of any help password in this case is ashish regards ashish koul akoul.blogspot.com

Re: $$Excel-Macros$$ MACRO WHICH CAN FILTER THE CURRENT CELL

:= _ ActiveCell.Value End Sub BIG SMILE SAVLA On Thu, Jun 10, 2010 at 10:19 PM, ashish koul koul.ash...@gmail.comwrote: Criteria1:=ActiveCell.Value TO TAKE THE PHOTO PRESS printscreen orprt scr button and goto ms paint press ctrl +v or paste it then cut the image and send

Re: $$Excel-Macros$$ Import Data into excel from notepad

run it select the notepad file and click on ok On Thu, Jun 10, 2010 at 9:59 AM, Mahesh mahender.bi...@gmail.com wrote: Hi Ashish, Thank for the codes but i m not able to use them, Can u give my the process how to start and how to end the same. On Tue, Jun 8, 2010 at 7:14 PM, ashish

Re: $$Excel-Macros$$ MACRO WHICH CAN FILTER THE CURRENT CELL

Criteria1:=ActiveCell.Value TO TAKE THE PHOTO PRESS printscreen orprt scr button and goto ms paint press ctrl +v or paste it then cut the image and send it On Thu, Jun 10, 2010 at 5:00 PM, big smile bigsmile...@gmail.com wrote: Hellow Gorup Masters, I want the help to write the

$$Excel-Macros$$ not allow user to paste any thing in data validation column

hi need any macro that will not allow user to paste any thing in data validation column for example i have put validation on col a anyone can copy data from any cell and paste in any cell of col a .. how can it be stopped or not allowed . regards ashish --

$$Excel-Macros$$ not allow user to paste any thing in data validation column

hi need any macro that will not allow user to paste any thing in data validation column for example i have put validation on col a anyone can copy data from any cell and paste in any cell of col a .. how can it be stopped or not allowed . regards ashish --

Re: $$Excel-Macros$$ Need Help to pickup Rate List for formula

for Rate'!D8 With Regards, Hitesh From: excel-macros@googlegroups.com [mailto: excel-mac...@googlegroups.com] On Behalf Of ashish koul Sent: Wednesday, May 05, 2010 10:59 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros

Re: $$Excel-Macros$$ Re: Extract Right Word in Line

Public Function exright(Str) Dim i, NumStr1 NumStr1 = For i = Len(Str) To 1 Step -1 If (Mid(Str, i, 1))Then NumStr1 = Mid(Str, i, 1) NumStr1 Else Exit For End If Next i exright = NumStr1 End Function On Thu, May 6, 2010 at 6:15 PM, anand

Re: $$Excel-Macros$$ Urgent Help

try this it may help you 1. Go to the directory where your folder is in. 2. Create a new notepad file and paste this without the double quotes: ren Users.{21EC2020-3AEA-1069-A2DD-08002B30309D} Users (Make sure to replace the word “Users” with the name of your folder.) 5. In Notepad, go to File

Re: $$Excel-Macros$$ Finding cell address of a formula referred to in a cell

check this Sub checkforformula() Dim i As Long Dim cell As Range For Each cell In Cells.SpecialCells(xlCellTypeFormulas) MsgBox cell.Address Next cell End Sub Sub ab() Dim i As Long Dim cell As Range 'ActiveSheet.UsedRange.Select Cells.Select For Each cell In Selection If

$$Excel-Macros$$ help regarding send keys

hi i am trying to select the all the data of page and paste into excel Sub ABC() Dim IE Dim objShell Set IE = CreateObject(InternetExplorer.Application) Set objShell = CreateObject(WScript.Shell) With IE .Left = 20 .Top = 20 .Height = 540 .Width = 950

Re: $$Excel-Macros$$ how to query if a given sheet exists?

Sub a() Dim i As Integer Dim K As Boolean K = False For i = 1 To Worksheets.Count If Worksheets(i).Name = Budget 2011 Then MsgBox Sheet (i) IS Budget 2010 K = True Exit For End If Next i If K = False Then MsgBox Budget 2011 Sheet does not exits End If End Sub On Sat, Apr 10, 2010 at

Re: $$Excel-Macros$$ Single Data Type Number Length Growing

try using this Format( result , #,##0.000) example Sub a() Dim i As Integer i = 3.000567 MsgBox Format(i, #,##0.000) End Sub On Wed, Apr 7, 2010 at 10:15 PM, mike mikesal...@gmail.com wrote: I'm working with variables that hold three decimal point numbers such as .001 and 3.185. Excel

Re: $$Excel-Macros$$ Single Data Type Number Length Growing

try for Range(a1).NumberFormat = 0.000 On Wed, Apr 7, 2010 at 11:26 PM, ashish koul koul.ash...@gmail.com wrote: try using this Format( result , #,##0.000) example Sub a() Dim i As Integer i = 3.000567 MsgBox Format(i, #,##0.000) End Sub On Wed, Apr 7, 2010 at 10:15 PM, mike

Re: $$Excel-Macros$$ HELP: Appending multiple sheet into one

hi janet use this code to get the file names of all folders in the directory then use seema's code to append Public Sub ListWorkbooks() Dim Directory As String Dim FileName As String Dim IndexSheet As Worksheet Dim rw As Long 'Change the directory below as needed Directory =

Re: $$Excel-Macros$$ Need help in function

=TEXT(D5-C5,[MM]) 2010/4/6 ╚►♥ѕαη∂єєρ♥◄╝ sandeepxxxku...@gmail.com Hi All, I want to calculate difference between two date , but i want result in minute's. please suggest function, Please find attached if u r sending solved reply Please CC sandeepxxxku...@gmail.com -- Thanks

Re: $$Excel-Macros$$ Need help in function

=TEXT(D5-C5,[MM]) On Tue, Apr 6, 2010 at 10:06 AM, ashish koul koul.ash...@gmail.com wrote: =TEXT(D5-C5,[MM]) 2010/4/6 ╚►♥ѕαη∂єєρ♥◄╝ sandeepxxxku...@gmail.com Hi All, I want to calculate difference between two date , but i want result in minute's. please suggest function, Please find

Re: $$Excel-Macros$$ Plz Help me urgent

check it if this helps u On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena anilsaxena170...@gmail.comwrote: Hi Dilip plz do the needful it is urgent I want the same ans match with ID and Questions ? Plz Sir show the Formula also Regards Anil Saxena --

Re: $$Excel-Macros$$ Need help in function

hi yes to avoid making it text u an got right click on cell - format - cutom format - [mm] On Tue, Apr 6, 2010 at 11:36 PM, paulwillekens paul.johan.willek...@gmail.com wrote: Hi Gaurav, Did you try my solution? =(D3 - C3) * 24 * 60 What's wrong about that? The result remains numeric,

Re: $$Excel-Macros$$ Need help in function

Paul your solution is working fine thanks, i always get to learn something new from this group Thanks to all On Wed, Apr 7, 2010 at 9:07 AM, ashish koul koul.ash...@gmail.com wrote: hi yes to avoid making it text u an got right click on cell - format - cutom format - [mm] On Tue

Re: $$Excel-Macros$$ Importing Text file

Sub ImportData() Dim I As Long Dim Filename As String I = 1 Filename = C:\Documents and Settings\akoul\Desktop\my desktop\TESTSPLIT.txt Open Filename For Input As #1 Do While (Not EOF(1)) Input #1, Streng Cells(I, 1) = Split(Streng) I = I + 1 If I = 1048575 Then

Re: $$Excel-Macros$$ Filtering in Google-Docs Spreadsheet

you can filter data with filter function Lets suppose you have this data in sheet1 nameagesex ashish28m vishal25F and you want to filter all the m in it goto sheet2 and write =filter(Sheet1!A1:C3,Sheet1!C1:C3=m) same ways u can

Re: $$Excel-Macros$$ Re: Finding a diff b/w two time

right click on cell click on format cell- choose the custom format - nad type this [hh]:mm On Sun, Mar 7, 2010 at 12:42 PM, Harpreet Singh Gujral harpreetguj...@gmail.com wrote: Ayush, I tried your solution, it works to some extent, but it doesnt work if the date and time in B1, is more by

Re: $$Excel-Macros$$ Clever way to transpose required

Sub Macro1() Dim c As Integer Dim j As Long j = 0 Dim add, l As String Sheets(Sheet1).Select Range(XFD1).Select Selection.End(xlToLeft).Select add = ActiveCell.Address l = Mid(add, 2, (InStrRev(add, $) - 2)) c = ActiveCell.Column Dim i, k, clm As Long Sheets(Sheet1).Select

Re: $$Excel-Macros$$ Urgent Badly help needed Excel formula

see the attachment r u looking for this but for that u need to create that temp col in sheet1 On Thu, Mar 4, 2010 at 8:14 PM, Puttu puttu...@gmail.com wrote: Hello Team, I need a formula or VB macro where as I have two different sheets with Same data, when it match the result should show in

Re: $$Excel-Macros$$ Re: Time Difference Calculations

TEXT(((TEXT(D3,dd/mmm/)TEXT(E3, hh:mm))-(TEXT(B3,dd/mmm/)TEXT(C3, hh:mm))),HH:MM) On Sun, Feb 21, 2010 at 2:01 PM, Akash $urkatha akash4...@yahoo.com wrote: Dear all, Attached is the sheet containing some Start Date, Start Time on the same Day and End Day, End Time of a particular

Re: $$Excel-Macros$$ Please help - consolidate all shets in main shet

, Umesh Matkar matkarum...@gmail.comwrote: Thanx Ashish…its work..thanx again - Umesh Matkar *From:* excel-macros@googlegroups.com [mailto: excel-mac...@googlegroups.com] *On Behalf Of *ashish koul *Sent:* Saturday, February 06, 2010 7:57 PM *To:* excel-macros@googlegroups.com

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,

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

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

<    8   9   10   11   12   13   14   >