Re: $$Excel-Macros$$ Masking Password in input box

2012-10-24 Thread ashish koul
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed t

$$Excel-Macros$$ help plz

2009-08-29 Thread ashish koul
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

2009-08-30 Thread ashish koul
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

2009-09-06 Thread ashish koul
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 Tu

$$Excel-Macros$$ help needed

2009-09-06 Thread ashish koul
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 koul.as

$$Excel-Macros$$ Re: help needed

2009-09-06 Thread ashish koul
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

2009-09-06 Thread ashish koul
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 kou

$$Excel-Macros$$ hi thanks for the help

2009-09-06 Thread ashish koul
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 users

$$Excel-Macros$$ harmeet thanks for the solution

2009-09-07 Thread ashish koul
sorry i forget to ask u this that email can end with.net or .org. or.in etc. Thanks ashish --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Vi

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

2009-09-07 Thread ashish koul
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.

$$Excel-Macros$$ Re: help plz

2009-09-07 Thread ashish koul
; *From:* excel-macros@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

$$Excel-Macros$$ hey thanks for your help

2009-09-08 Thread ashish koul
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$$ help plz

2009-09-11 Thread ashish koul
hi i wanted a formula in sheet 2 which will tell me under which column no 1 or 7 or etc is falling for eample 1 answer should be ir Thanks ASHISH --~--~-~--~~~---~--~~ -- Some imp

$$Excel-Macros$$ hi all backup code

2009-09-15 Thread ashish koul
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 and

$$Excel-Macros$$ HEY NEED HELP

2009-09-21 Thread ashish koul
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

2009-09-21 Thread ashish koul
just attcahed a file for example On Mon, Sep 21, 2009 at 6:46 AM, Aindril De wrote: > Right Click on the cells > Select Format Cell > Under Number Tab > Choose Custom in Category > In the Type box type MM/DD/ > Click OK > > Regards, > Andy > > On Mon, Sep

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

2009-09-21 Thread ashish koul
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$$ thanks ..........

2009-09-21 Thread ashish koul
09 at 6:19 PM, Sonia Singla wrote: > >> Hi Ashish >> >> do you want a macro for this because this you can do by changing the >> format. >> >> Sonia >> >> On Mon, Sep 21, 2009 at 12:35 PM, ashish koul wrote: >> >>>8/3/2009 8/3/20

$$Excel-Macros$$ help plz

2009-09-22 Thread ashish koul
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$$ Re: help plz

2009-09-23 Thread ashish koul
it. > Means your data already have "parent co" in column B are you going to enter > it in column B. > > Regards > Sandeep > > > On Wed, Sep 23, 2009 at 10:29 AM, ashish koul wrote: > >> inserting a blank row with matching value in a cell >> >>

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

2009-10-16 Thread ashish koul
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 tu

$$Excel-Macros$$ hi help please

2009-11-11 Thread ashish koul
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 h

$$Excel-Macros$$ hi need ur help

2009-11-11 Thread ashish koul
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 http://

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

2009-11-12 Thread ashish koul
) > > Is the corrected formula. > > Regards, > Andy > > On Thu, Nov 12, 2009 at 11:44 AM, ashish koul wrote: > >> hi sir >> >> can u please check whats wrong

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

2009-11-23 Thread ashish koul
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 wrote: > > I am try

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

2009-11-30 Thread ashish koul
you have copied it from pdf file can u send that tooo On Mon, Nov 30, 2009 at 4:28 PM, amresh kumar wrote: > 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

2009-12-01 Thread ashish koul
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. E

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

2009-12-02 Thread ashish koul
On Wed, Dec 2, 2009 at 8:20 AM, suresh k wrote: > Dear Excel masters, > > Anyone know this solution or not? > > > On Tue, Dec 1, 2009 at 1:12 PM, suresh k wrote: > >> Hi Excel masters, >> >> I have created a macro for maintaining attendance. >> >> In sheet 1 i have created a box, If

Re: $$Excel-Macros$$ Send Email from Excel to Multiple Addresses

2009-12-16 Thread ashish koul
hi check the attchment i made it for my own purpose it send the email to all the email ids mentioned in col b with different attachmnet as in col e and col f you can romve the attchment option and can also add more attchament options rember attachment cols e and f and col b can not be blan

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

2009-12-18 Thread ashish koul
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 wrote: > Dear paul Thanks

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

2009-12-19 Thread ashish koul
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 wrote: > Hi Pooja, > > It is something related with text capturing from an image (PDF) file which > is beyond the capabilities of Excel, so try searching

Re: $$Excel-Macros$$ Send Email from Excel to Multiple Addresses

2009-12-20 Thread ashish koul
how can i do this. I mean i want to mark > more than one person in "To" and more than one person under "Cc" > category. Is it possible through Excel, if yes, how? > > - > Manish > > On Dec 16, 4:30 pm, ashish koul wrote: > > hi > > > > check

$$Excel-Macros$$ help please urgently

2009-12-31 Thread ashish koul
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

$$Excel-Macros$$ help needed

2010-01-06 Thread ashish koul
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 macr workbook open or activate , etc. Const idleT

$$Excel-Macros$$ help required

2010-01-07 Thread ashish koul
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 idle

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

2010-01-07 Thread ashish koul
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 = N

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

2010-01-10 Thread ashish koul
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 Selec

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

2010-01-14 Thread ashish koul
hi check it On Thu, Jan 14, 2010 at 4:49 PM, kvc praveen kumar wrote: > 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 wrote: > >> Hello Friends, >> Can i ge

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

2010-01-17 Thread ashish koul
elds **unrestricted & Quantity 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 wrote: > >> hi check it r u

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

2010-01-18 Thread ashish koul
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. wrote: > Guys, > > I am facing some problem to Extract the A/c no. from Line written in > Particular Cell. > > Ther

Re: $$Excel-Macros$$

2010-01-24 Thread ashish koul
hi find the attachment On Sun, Jan 24, 2010 at 9:57 PM, Shilpa Rao 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

2010-01-28 Thread ashish koul
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

2010-01-29 Thread ashish koul
http://free.timeanddate.com/clock/i1wel3cw/n176/tt0 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

2010-01-29 Thread ashish koul
need help on this matter On Thu, Jan 28, 2010 at 6:47 PM, ashish koul 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

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

2010-01-29 Thread ashish koul
any help please On Fri, Jan 29, 2010 at 2:16 PM, ashish koul wrote: > http://free.timeanddate.com/clock/i1wel3cw/n176/tt0<http://www.linkedin.com/redirect?url=http%3A%2F%2Ffree%2Etimeanddate%2Ecom%2Fclock%2Fi1wel3cw%2Fn176%2Ftt0&urlhash=mDaV> > > HI i need a vba solutio

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

2010-01-29 Thread ashish koul
lp u ..u can see code > there..adjust according to your need > > On 29/01/2010, ashish koul wrote: > > need help on this matter > > > > On Thu, Jan 28, 2010 at 6:47 PM, ashish koul > wrote: > > > >> hi > >> > >> i have a list in exce

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

2010-01-29 Thread ashish koul
Hi check the attachment On Fri, Jan 29, 2010 at 8:43 AM, Sandip Patel 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 > *“ORIGINAL DATA”

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

2010-01-29 Thread ashish koul
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 wrote: > Hi > > I want a macro that can do a filter data by comments & filter data by > colour > > -- > Thanks & Regards, > Maulik Desa

$$Excel-Macros$$ help..

2010-01-30 Thread ashish koul
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

Re: $$Excel-Macros$$ how to get top ten values from a list

2010-02-03 Thread ashish koul
hi check the attachment On Wed, Feb 3, 2010 at 1:39 PM, vicky wrote: > volume sales > 1.13 2423 > 1.532423 > 2.92 33243 > 1.47 3243 > 1.49 234234 > 1.35 343423 > 3.45 32423 > > > i need top ten sales values for volume > 1 and volume < 2 > > -- > > -

$$Excel-Macros$$ need help

2010-02-04 Thread ashish koul
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 : http://twit

$$Excel-Macros$$ Re: need help

2010-02-04 Thread ashish koul
any help On Thu, Feb 4, 2010 at 8:46 PM, ashish koul wrote: > hi > > i have a input in sheet 1 and its not limited > > and want result in sheet2 like in col1 > > > regards > > ashish > -- --

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

2010-02-05 Thread ashish koul
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" Column

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

2010-02-06 Thread ashish koul
gt; > > On Fri, Feb 5, 2010 at 11:27 AM, ashish koul wrote: > >> any help >> On Thu, Feb 4, 2010 at 8:46 PM, ashish koul wrote: >> >>> hi >>> >>> i have a input in sheet 1 and its

$$Excel-Macros$$ help

2010-02-08 Thread ashish koul
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

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

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

2010-02-18 Thread ashish koul
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 Wo

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

2010-02-18 Thread ashish koul
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, Sh

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

2010-02-19 Thread ashish koul
gt; > Thank you, > > Sarojkumar. > > > > On Sun, Feb 7, 2010 at 1:47 PM, Umesh Matkar wrote: > >> Thanx Ashish…its work..thanx again >> >> >> >> - Umesh Matkar >> >> >> >> *From:* excel-macros@googlegroups.co

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

2010-02-21 Thread ashish koul
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 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 activi

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

2010-03-04 Thread ashish koul
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

2010-03-04 Thread ashish koul
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 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 other sheet nex

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

2010-03-07 Thread ashish koul
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

Re: $$Excel-Macros$$ Who to remove hyperlinks

2010-03-22 Thread ashish koul
sub a() selection.hyperlinks.delete end sub On Mon, Mar 22, 2010 at 10:22 PM, Sandeep Kumar Maurya < sandymau...@gmail.com> wrote: > Hi, > > write 1 in a blank cell and then copy it and use multiply option in 'paste > special'. > It also put 0 in blank selected cells. > > Regards > Sandeep >

Re: $$Excel-Macros$$ Navigate worksheet from Dropdown list

2011-09-16 Thread ashish koul
users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com

Re: $$Excel-Macros$$ Excel chart challenge

2011-09-17 Thread ashish koul
om > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><>&l

Re: $$Excel-Macros$$ List of text files with data to Excel.

2011-09-19 Thread ashish koul
ming but have very little experience with file data > extracting > > > > > and parsing. > > > > > > > Thanks > > > > > > > -- > > > > > > > > ---

Re: $$Excel-Macros$$ List of text files with data to Excel.

2011-09-19 Thread ashish koul
= i + 1 Cells(j, 7).Value = strLine If i = 3 Then s = "" s = Cells(j, 7).Value Cells(j, 8).Value = Left(Right(s, Len(s) - InStr(s, "(")), Len(Right(s, Len(s) - InStr(s, "("))) - 1) Cells(j, 7).Value = Left(s, InStr(s, "(") - 1) Exit Do End If End If Lo

Re: $$Excel-Macros$$ Template to modify workbooks

2011-09-19 Thread ashish koul
t; 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros a

Re: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread ashish koul
ng messages and I can not see how to attach my workbook. > > > On Sep 19, 9:21 pm, ashish koul wrote: > > Hi Harry > > > > 1 are all the workbooks in xlsm or xls format is it possible for u to > share > > a sample workbook > > > > On Tue, Se

Re: $$Excel-Macros$$ Using VBA to switch between calculated fields

2011-09-21 Thread ashish koul
gt; 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegro

Re: $$Excel-Macros$$ help

2011-09-24 Thread ashish koul
pot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><>&l

Re: $$Excel-Macros$$

2011-09-24 Thread ashish koul
t;><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think

Re: $$Excel-Macros$$ Retrieving data in horizontal form

2011-09-24 Thread ashish koul
cks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><&

Re: $$Excel-Macros$$ examine three columns return the one that matches criteria

2011-09-27 Thread ashish koul
l-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discu

Re: $$Excel-Macros$$ Union to transfor a non-contiguous to a contiguous range In VBA

2011-09-28 Thread ashish koul
LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group,

Re: $$Excel-Macros$$ Hidden Columns and Save Location

2011-09-28 Thread ashish koul
__ > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Lin

Re: $$Excel-Macros$$ Extract (%) Numbers from the text

2011-10-01 Thread ashish koul
gt; To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Jus

Re: $$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times)..

2011-10-02 Thread ashish koul
for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. E

Re: $$Excel-Macros$$ PPT

2011-10-04 Thread ashish koul
ot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <

$$Excel-Macros$$ job

2011-10-04 Thread ashish koul
rean-partners.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and l

Re: $$Excel-Macros$$ PPT

2011-10-06 Thread ashish koul
e. > > Regards, > > Chandra Shekar B > > > On Tue, Oct 4, 2011 at 4:43 PM, Chandra Shekar < > chandrashekarb@gmail.com> wrote: > >> Thanks Ashish its working fine :) >> >> >> On Tue, Oct 4, 2011 at 9:36 AM, ashish koul wrote: >> &g

Re: $$Excel-Macros$$ Querry ncg

2011-10-08 Thread ashish koul
ogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><>

$$Excel-Macros$$ job

2011-10-10 Thread ashish koul
rrent CTC:- Exp CTC:- Notice Period:- Reason for Change:- Please send me your updapted resume ASAP Thanks & Regards Akankasha Talwar Planman HR akankasha.tal...@planmanconsulting.com 01130268207 -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think

$$Excel-Macros$$ job

2011-10-11 Thread ashish koul
knowledge in an MS-Excel If you are interested please send me your updated profile. Total Experience: Relevant Experience: CTC: ECTC NP Reason for Job change. Thanks and Regards Malathi -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment

Re: $$Excel-Macros$$ Querry ncg

2011-10-11 Thread ashish koul
> On Oct 10, 12:10 pm, Nemi Gandhi wrote: > > Thanks excel macro freinds. > > > > Nemi Gandhi > > > > On Oct 8, 8:46 pm, ashish koul wrote: > > > > > > > > > > >

Re: $$Excel-Macros$$ Pivot Help

2011-10-14 Thread ashish koul
acebook.com/discussexcel > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. J

Re: $$Excel-Macros$$ Formula needed to extract the text from string

2011-10-15 Thread ashish koul
t; http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blo

Re: $$Excel-Macros$$ Dynamic chart range

2011-10-15 Thread ashish koul
dIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to exce

Re: $$Excel-Macros$$ Help

2011-10-15 Thread ashish koul
/exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><>&l

Re: $$Excel-Macros$$ conditional formatting- more than 3

2011-10-17 Thread ashish koul
ps and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><

Re: $$Excel-Macros$$ queary about a jpg file into excel or pdf file

2011-10-18 Thread ashish koul
><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/*

Re: $$Excel-Macros$$ querry ncg

2011-10-19 Thread ashish koul
;<><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before pri

Re: $$Excel-Macros$$ Color count in a row

2011-10-19 Thread ashish koul
t; > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join

Re: $$Excel-Macros$$ Need help resolving runtime errors and crashes (or different approach)

2011-10-20 Thread ashish koul
> > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Ju

Re: $$Excel-Macros$$ Need help resolving runtime errors and crashes (or different approach)

2011-10-20 Thread ashish koul
oose chase down a blind alley, yet I am profoundly > grateful for the aid and the neat macro that you have provided. > > I will have to mark this problem "Solved" > > Warm regards, > -Sean- > > On Oct 20, 10:19 pm, ashish koul wrote: > > hi Sean > > try this

$$Excel-Macros$$ ass links to blog

2011-10-21 Thread ashish koul
http://www.excelvbamacros.com/2011/10/sort-data-on-basis-of-font-color.html -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- -- Some important

Re: $$Excel-Macros$$ ass links to blog

2011-10-21 Thread ashish koul
Sorry Guys By mistake i send this link on this group On Fri, Oct 21, 2011 at 1:19 PM, ashish koul wrote: > http://www.excelvbamacros.com/2011/10/sort-data-on-basis-of-font-color.html > > -- > *Regards* > * * > *Ashish Koul* > *http://www.excelvbamacros.com/* > >

$$Excel-Macros$$ Sorry Guys By mistake i send this link on this group

2011-10-21 Thread ashish koul
On Fri, Oct 21, 2011 at 1:38 PM, ashish koul wrote: > Sorry Guys By mistake i send this link on this group > > > > On Fri, Oct 21, 2011 at 1:19 PM, ashish koul wrote: > >> >> http://www.excelvbamacros.com/2011/10/sort-data-on-basis-of-font-color.html >> >&

Re: $$Excel-Macros$$ Looking Up Words When You Only Have A Few Letters

2011-10-21 Thread ashish koul
l Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><>

<    3   4   5   6   7   8   9   10   11   12   >