RE: $$Excel-Macros$$ Re: FW: Auto update Data, Row & Columns

2014-06-18 Thread Rajeev
Dear Experts, What I am trying to do is as below: - I have a excel file as attached. I want to add or update fields in master sheet only When i add / update master sheet, data must be update in other worksheet (other worksheet are separated from master sheet) Same I used to upd

$$Excel-Macros$$ Display button after 10 seconds in vba

2014-06-18 Thread Raihan Khan
i created one button and after my workbook loads , i want my button to appear after 10 seconds , i don't want my button to show it right away, i want my button to appear after 10 seconds Dim ButtonOneClick As Boolean Sub Button3_Click() Sub

$$Excel-Macros$$ Urgent required QA Engineer (Manual Testing) - Dublin, OH

2014-06-18 Thread recruiter099
*Please respond to gurjant.si...@damcosoft.com * *Position: QA Engineer (Manual Testing) Duration: 6+ months Location: Dublin, OH* *Visa: USC/GC/EAD only* Exp: 5 to 8 years Start Date: July 10, 2014 Skills: *"Web Testing" and server "side testing" must required* Job description: manual Test

Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-18 Thread Vaibhav Joshi
Chek this,,, On Wed, Jun 18, 2014 at 7:08 PM, SG wrote: > yeah got it...one more thing..in reports, we can't say customer to select > * for "All" because it's not user friendly. What to do in that case?? > > > On Wednesday, June 18, 2014 6:53:29 PM UTC+5:30, Vabz wrote: > >> when you say "ALL",

Re: $$Excel-Macros$$ [Urgent Help] Insert New Paragraph

2014-06-18 Thread Vaibhav Joshi
Hey You can increase line spacing.. Sub para() Dim oPara As Paragraph For Each oPara In ActiveDocument.Paragraphs If Not (Len(oPara.Range.Text) <> 1 And Not oPara.Range.ListFormat.ListType = bulletList) Then With oPara .SpaceAfter = 0

$$Excel-Macros$$ Re: FW: Auto update Data, Row & Columns

2014-06-18 Thread pankaj khairanar
Hi Can you please share more details? it couldent be possible for any one to provide you correct macro without understanding the proper requirement. Regards, Pankaj On Wednesday, June 18, 2014 2:08:42 PM UTC+5:30, Raj wrote: > Dear Experts, > > > > Is there any chance.

Re: $$Excel-Macros$$ [Urgent Help] Insert New Paragraph

2014-06-18 Thread Ashish Kumar
Hi Davidson, PFA..!!! If, its not meet your requirement then elaborate more. Regards Ashish On 18 June 2014 19:25, Davidson Chew wrote: > Hi everyone, I need some real urgent help with my VBA Macro for Microsoft > Word. > > Here's my current code: > Dim oPara As Paragraph > F

$$Excel-Macros$$ [Urgent Help] Insert New Paragraph

2014-06-18 Thread Davidson Chew
Hi everyone, I need some real urgent help with my VBA Macro for Microsoft Word. Here's my current code: Dim oPara As Paragraph For Each oPara In ActiveDocument.Paragraphs If Not (Len(oPara.Range.Text) <> 1 And Not oPara.Range.ListFormat. ListType = bulletList) Then oPa

Re: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO

2014-06-18 Thread Vaibhav Joshi
Cheers!! On Wed, Jun 18, 2014 at 6:58 PM, Rohan Young wrote: > > On Wed, Jun 18, 2014 at 6:50 PM, Vaibhav Joshi wrote: > >> ActiveSheet.Range("G" & j).Value = strFile > > > ITS DONE now, Gr8 dear, excellent > > thanks alot bro, very-2 thanks to you :-) > > -- > Are you =EXP(E:RT) or =NOT(EXP(E

Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-18 Thread SG
yeah got it...one more thing..in reports, we can't say customer to select * for "All" because it's not user friendly. What to do in that case?? On Wednesday, June 18, 2014 6:53:29 PM UTC+5:30, Vabz wrote: > > when you say "ALL", for excel / computer it is * (asterik), remember old > days when DO

Re: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO

2014-06-18 Thread Rohan Young
On Wed, Jun 18, 2014 at 6:50 PM, Vaibhav Joshi wrote: > ActiveSheet.Range("G" & j).Value = strFile ITS DONE now, Gr8 dear, excellent thanks alot bro, very-2 thanks to you :-) -- 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 Fac

Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-18 Thread Vaibhav Joshi
when you say "ALL", for excel / computer it is * (asterik), remember old days when DOS were used & where command was Dir *.* Cheers!! On Wed, Jun 18, 2014 at 6:48 PM, SG wrote: > Amazing Vabz...thanksss..Can you please explain the idea behind this??? > > > On Wednesday, June 18, 2014 6:30:28

Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-18 Thread SG
Amazing Vabz...thanksss..Can you please explain the idea behind this??? On Wednesday, June 18, 2014 6:30:28 PM UTC+5:30, Vabz wrote: > > Hi > > In cell C2 put * (only asterik) instead of ALL. > > Cheers!! > > > On Wed, Jun 18, 2014 at 6:10 PM, SG > > wrote: > >> >> Hi Experts, >> >> I'm looking f

Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-18 Thread Vaibhav Joshi
Hi In cell C2 put * (only asterik) instead of ALL. Cheers!! On Wed, Jun 18, 2014 at 6:10 PM, SG wrote: > > Hi Experts, > > I'm looking for a solution to summarise the data based on multiple > criterias in drop downs. My data has 3 dropdowns.I have tried it using > advance filter > but it fai

$$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-18 Thread SG
Hi Experts, I'm looking for a solution to summarise the data based on multiple criterias in drop downs. My data has 3 dropdowns.I have tried it using advance filter but it fails when all criterias selected as "All". The problem starts when any of the dropdown is selected as "All" .I'm unable

Re: $$Excel-Macros$$ Formulae in Conditional Formatting

2014-06-18 Thread Vaibhav Joshi
hey share sample file so that solution given matches your expectation. Thanks On Wed, Jun 18, 2014 at 5:06 PM, Nicci Deaves wrote: > I want to match names in a column on one sheet to names in a column in > another sheet in the same workbook and conditionally format the cell to > show whether

$$Excel-Macros$$ Formulae in Conditional Formatting

2014-06-18 Thread Nicci Deaves
I want to match names in a column on one sheet to names in a column in another sheet in the same workbook and conditionally format the cell to show whether there is a match or not, I know I need to use ISNA and VLOOKUP but can't work out the formula! Keep getting formula error message. Can an

$$Excel-Macros$$ FW: Auto update Data, Row & Columns

2014-06-18 Thread Rajeev
Dear Experts, Is there any chance..? Regards, From: Rajeev [mailto:rajeevk...@gmail.com] Sent: 17 June 2014 16:30 To: 'excel-macros@googlegroups.com' Subject: Auto update Data, Row & Columns Dear Experts, Please find attached file and please do the needfu

Re: $$Excel-Macros$$ Data validation help

2014-06-18 Thread Vaibhav Joshi
Hi chek this.. http://www.contextures.com/xlDataVal02.html Cheers!! On Wed, Jun 18, 2014 at 12:17 PM, Rakesh kumar wrote: > > Dear Friends, > > i want to use data validation in excel. > > first validation - Value would not be repeat in list. > and > In second Validation , show only those va