$$Excel-Macros$$ Re: Excel VBA Code for Zip Password

Hi Check following link: Link Rgds//Vabs On Monday, October 8, 2012 11:48:57 AM UTC+5:30, Dhartikumar Sahu wrote: > Hi Experts > > Kindly provide me a code for Zip file with password Protection. > > Q. How to Zip the folders with password in exc

$$Excel-Macros$$ How we use CHOOSE function with VLOOKUP in Excel

Dear Experts, I want to know How we can use CHOOSE function with VLOOKUP in Excel. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Us

Re: $$Excel-Macros$$ How we use CHOOSE function with VLOOKUP in Excel

=VLOOKUP(MAX(C4:C17),CHOOSE({1,2,3},C4:C17,B4:B17,D4:D17),{2,3},0) Regards, Kuldeep Singh On Tue, Oct 9, 2012 at 12:52 PM, Rakesh Kumar Sharma wrote: > Dear Experts, > > I want to know How we can use CHOOSE function with VLOOKUP in Excel. > > > > > > -- > Regards, > > Rakesh Kumar Sharma > Cont

$$Excel-Macros$$ formula required for addition of amount for duplicate entry

Dear All, I have an excel sheet wherein commission is generated for each business placed by our intermediary. I need to have a formula for monthly consolidated amount for Gross Amount (Column E) and TDS Deduction (Column I) of each intermediary without first sorting and subsequently adding each en

$$Excel-Macros$$ Is it possible to Open a Particular Website and Login to it using VBA???

*The file is good but when we click on "Google Login" in the file it goes to G-Mail entrance page and it is insisting us to enter the details again not opening the mail with the ID & Password given in the excel file.* * * *Regards* *Pravin Gunjal* -- Forwarded message -- From: Sam

Re: $$Excel-Macros$$ Macro to Filter OR Copy and Paste row data to a new worksheet based on Mult Data Values

So, instead of separate workbooks based on Sales#, you'd like separate workbooks based on SalesID? with all Sales#'s for that SalesID? I'll see what I can do. I'll get back with you in the next few minutes.   Paul - “Do all the good you can, By all the means

Re: $$Excel-Macros$$ Is it possible to Open a Particular Website and Login to it using VBA???

Hi, Pls find attached excel. Regards, Swapnil. On Tue, Oct 9, 2012 at 4:36 PM, Pravin Gunjal wrote: > *The file is good but when we click on "Google Login" in the file it goes > to G-Mail entrance page and it is insisting us to enter the details again > not opening the mail with the ID & Pass

Re: $$Excel-Macros$$ Macro to Filter OR Copy and Paste row data to a new worksheet based on Mult Data Values

Yes sir. I apologize for not being clear. I purchased the 2007 Excel Bible last night. Hopefully I'll be able to help people such as you do. Thank you so much! On Tuesday, October 9, 2012 7:22:44 AM UTC-4, Paul Schreiner wrote: > > So, instead of separate workbooks based on Sales#, > you

$$Excel-Macros$$ Help needed to create a function within a macro

Hi NG, I need to insert a function into cell D1 with an Excel2007 macro that executes the following: A B C D row 1 12343 row 21 123444 row 31 43322 row 4

Re: $$Excel-Macros$$ Macro to Filter OR Copy and Paste row data to a new worksheet based on Mult Data Values

This is amazing! Thanks again! I think I need to tweak a few things but I can't thank you enough. This really going to help. Works very well. I get a "Path not found" error but I believe that's because I ran it on my machine. Notice you created a destination folder seemingly unique to your

Re: $$Excel-Macros$$ Macro to Filter OR Copy and Paste row data to a new worksheet based on Mult Data Values

Yeah, that's the part where I said: You'll notice in the macro that the Destination folder, and Sheet names will need to be "set".   '- --     ShtData = "Source Data Format"     ShtID = "Sales IDs"     DestFolder = "C:\temp\VBA\testing\" '-

Re: $$Excel-Macros$$ Help needed to create a function within a macro

Hi, Insert followibg formula in D1 cell. =if(and(or(a1=1,b1=1),c1>23400),3,0) Hope this is what u want. Regards swapnil, On Oct 9, 2012 6:57 PM, "Henning Deschka" wrote: > Hi NG, > > I need to insert a function into cell D1 with an Excel2007 macro that > executes the following: > >

Re: $$Excel-Macros$$ formula required for addition of amount for duplicate entry

can you show us how do you want to see output On Tue, Oct 9, 2012 at 1:16 PM, ashish damor wrote: > Dear All, > > I have an excel sheet wherein commission is generated for each > business placed by our intermediary. I need to have a formula for > monthly consolidated amount for Gross Amount (Col

Re: $$Excel-Macros$$ Please HELP

No idea abt this Vist below links . See if they are useful http://www.sqaforums.com/showflat.php?Number=431568 http://h30499.www3.hp.com/t5/Quality-Center-Support-and-News/ActiveX-component-can-t-create-object-TDApiOle80-TDConnection/td-p/4742677#.UHRUTZjMhc0 On Tue, Oct 9, 2012 at 10:13 PM, sre

Re: $$Excel-Macros$$ Help needed to create a function within a macro

see the attachment check the cells with "Yellow" color On Tue, Oct 9, 2012 at 8:48 PM, Swapnil Palande wrote: > Hi, > > Insert followibg formula in D1 cell. > > =if(and(or(a1=1,b1=1),c1>23400),3,0) > > Hope this is what u want. > > Regards > > swapnil, > On Oct 9, 2012 6:57 PM, "Henning Deschk

Re: $$Excel-Macros$$ Re: Macro to create Pivot Table for each sheet in the workbook

Hello Ashish, Any guidance to solve the problem I am facing? Thanks Rashid Khan On Sunday, October 7, 2012 8:59:04 PM UTC+4, prkhan56 wrote: > Hello Ashish, > > When I run call_pivot > It gives Run-time Error '9' > Subscript out of range > and highlights the following line: > > Call create_pivo

$$Excel-Macros$$ Re: How we use CHOOSE function with VLOOKUP in Excel

Hi Rakesh, Just go through the below mentioned URL. *http://www.techonthenet.com/excel/formulas/index.php* Regards Prince. On Tuesday, October 9, 2012 12:53:08 PM UTC+5:30, rakesh sharma wrote: > Dear Experts, > > I want to know How we can u

$$Excel-Macros$$ Re: Help needed to create a function within a macro

Hi Henning deschka, Please paste this into C1. =SUMPRODUCT(--(($A$1:$A$10=1)+($B$1:$B$10=1)*($C$1:$C$10>23400))) Regards Prince On Tuesday, October 9, 2012 6:56:51 PM UTC+5:30, Henning Deschka wrote: > > Hi NG, > > I need to insert a function into cell D1 with an Excel2007 macro that > execut

$$Excel-Macros$$ Re: formula required for addition of amount for duplicate entry

Hi Ashish, Please use sumifs formula for getting total GROSS and TDS amount for each vendor. Regards Prince On Tuesday, October 9, 2012 1:16:22 PM UTC+5:30, ashish damor wrote: > > Dear All, > > I have an excel sheet wherein commission is generated for each > business placed by our intermedi

Fwd: $$Excel-Macros$$ Spark lines in Excel 2003

Pls Give me Idea about Sparklines -- Forwarded message -- From: amar takale Date: Mon, Oct 8, 2012 at 10:22 AM Subject: $$Excel-Macros$$ Spark lines in Excel 2003 To: excel-macros@googlegroups.com Hi all, Can Anybody help me for create Sparklines in excel 2003.Any formula or an

Re: $$Excel-Macros$$ Spark lines in Excel 2003

Hi Amar, Kindly see below links: http://sparklines-excel.blogspot.in/ http://sparklines-excel.blogspot.in/2009/03/auto-install-add-in-for-excel-2007.html Regards, Kuldeep Singh On Wed, Oct 10, 2012 at 12:22 PM, amar takale wrote: > Pls Give me Idea about Sparklines > > > -- Forwarded

Re: $$Excel-Macros$$ Re: formula required for addition of amount for duplicate entry

Dear Sir, Thanks will try and get back to you. On Wed, Oct 10, 2012 at 11:17 AM, Prince wrote: > Hi Ashish, > > Please use sumifs formula for getting total GROSS and TDS amount for each > vendor. > > Regards > Prince > > On Tuesday, October 9, 2012 1:16:22 PM UTC+5:30, ashish damor wrote: >> >>