Fwd: $$Excel-Macros$$ Re: Good Laptop to Buy..

2013-12-13 Thread Pravin Gunjal
Hello, Is there any new updates on this subject? As periodically it's changing. Please suggest a good company and let me know what are all the accessories and other facilities should I check before buy. Look forward to hear from all experts. Thank you, Regards Pravin Gunjal. -- Forwarde

Re: $$Excel-Macros$$ Sharepoint

2013-12-13 Thread bhupendra singh raghav
Yes On Dec 14, 2013 1:56 AM, "B.N.Chethan Kumar" wrote: > Hi. > I am upload excel file to a SharePoint portal. In a day close to 100 file > need to be upload at different folder. Any macro which can automated it. > Regards > Ck > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you w

$$Excel-Macros$$ Sharepoint

2013-12-13 Thread B.N.Chethan Kumar
Hi. I am upload excel file to a SharePoint portal. In a day close to 100 file need to be upload at different folder. Any macro which can automated it. Regards Ck -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this

Re: $$Excel-Macros$$ Introduction to Array Formulas

2013-12-13 Thread xlstime
Dear Anoop, Request you to please do not send our web link.. this group for Questioning and answering not a advertisement Ayush:- Please take a action . Enjoy Team XLS On Tue, Dec 10, 2013 at 8:09 PM, anoop kumar wrote: > > http://excelautomate.blogspot.in/2013/12/

$$Excel-Macros$$ Re: Vlookup query

2013-12-13 Thread anoop kumar
shrini check this http://excelautomate.blogspot.in/2013/12/lookups-and-tables.html On Wednesday, 20 November 2013 17:10:46 UTC+5:30, shrini wrote: > > Dear All > Please find attached query. > Is it possible to write aformula as per my requirement > > -- > Shrini > -- Are you =EXP(E:RT) or =NO

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

2013-12-13 Thread anoop kumar
check this prabhu http://excelautomate.blogspot.in/2013/12/lookups-and-tables.html On Sunday, 24 November 2013 11:32:00 UTC+5:30, Prabhu Pinky wrote: > > Hi Experts, > > How to do vlookup in VBA. i have two sheets saved in different locations. > > i need to do vlookup in sheet1 by referring anoth

$$Excel-Macros$$ Re: VBA macro to replace Index and Match formula

2013-12-13 Thread anoop kumar
you can try conditional formatting option, like select the columns you want to compare or find duplicates. and go to conditional formatting highlight the duplicate cell it will give the correct answer. for Excel Automation visit www.excelautom

RE: $$Excel-Macros$$ Re: Please Help

2013-12-13 Thread Ravinder
PFA, may be helpful for you, first select path where you want to save file. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of pmyk Sent: Friday, December 13, 2013 4:58 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Please Help Try th

$$Excel-Macros$$ Re: Images in Excel - Prints Differently Than Displayed in Worksheet

2013-12-13 Thread anoop kumar
check www.excelautomate.blogpsot.in On Wednesday, 11 December 2013 21:22:04 UTC+5:30, Brian Keith wrote: > > I am copying an image to an Excel worksheet, and then sizing to the scale > I want and placing it where I want the image to show up in the worksheet > upon printing. What happens though i

$$Excel-Macros$$ Re: Conditional Format

2013-12-13 Thread anoop kumar
please see this site about how to write excel formulas http://excelautomate.blogspot.in/2013/11/how-to-work-with-formulas-in-excel.html On Friday, 13 December 2013 05:31:13 UTC+5:30, Troy Nieto wrote: > > I want to display in E8 "Complete" if D8 has a strikthrough format in the > cell, otherwise

RE: $$Excel-Macros$$ Need - formula help

2013-12-13 Thread Ravinder
YES From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shaikh Iqbal Sent: Friday, December 13, 2013 4:38 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need - formula help Ravinder, is it correct =IF(B2="Platinum",INT(C2/3

$$Excel-Macros$$ Re: Please Help

2013-12-13 Thread pmyk
Try this: [code] Private Sub CommandButton1_Click() Dim FilePath As String FilePath = "D:\VBTrials\VBToThisText.txt" 'If it is there it will be opened 'if it is not there it will be created Open FilePath For Output As #1 'Overwrite in text file 'Open FilePath For Append As #1 'append will add

Re: $$Excel-Macros$$ Need - formula help

2013-12-13 Thread Shaikh Iqbal
Ravinder, is it correct =IF(B2="Platinum",INT(C2/3)*1200,IF(B2="Gold",INT(C2/12000)*480,IF(B2="Silver",INT(C2/6000)*240))) On 13 December 2013 16:25, Ravinder wrote: > I think u r looking for this. > =IF(B2="Platinum",INT(C2/3),IF(B2="Gold",INT(C2/12000),IF(B2="Silver",INT(C2/6000

Re: $$Excel-Macros$$ Need - formula help

2013-12-13 Thread Shaikh Iqbal
Ravinder, Ya its fine but slab multiply with card Platinum*1200 / Gold*480 & Silver*240 On 13 December 2013 16:25, Ravinder wrote: > I think u r looking for this. > =IF(B2="Platinum",INT(C2/3),IF(B2="Gold",INT(C2/12000),IF(B2="Silver",INT(C2/6000 > > > > *From:* excel-macros@googlegrou

RE: $$Excel-Macros$$ Need - formula help

2013-12-13 Thread Ravinder
I think u r looking for this. =IF(B2="Platinum",INT(C2/3),IF(B2="Gold",INT(C2/12000),IF(B2="Silver",IN T(C2/6000 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shaikh Iqbal Sent: Friday, December 13, 2013 4:07 PM To: excel-macros@googlegroups.com

$$Excel-Macros$$ Need - formula help

2013-12-13 Thread Shaikh Iqbal
Dear Exports, Need your help for if condition. Pls find attached file. Rgds, Iqbal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use

$$Excel-Macros$$ Re: Help in creating macro to identify number of people birthday on particular day in a month

2013-12-13 Thread Reyn
> > well, just need to wait for someone to get this.. ((= > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles.