Re: $$Excel-Macros$$ Re: Need Small Help to pull values based on the criteira!
Dear Sharma, You are welcome. If you need any other help let us know. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel 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 5. Excel Tips 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/discussexcel
$$Excel-Macros$$ need help!
Plz solve my problem! -- syed aliya -- -- Some important links for excel 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 5. Excel Tips 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/discussexcel Solve.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: Excel Interview Question - Help
Hi, You will find a lot of questions in Mr Ashish Koul's link besides you can prepare for following questions: 1. What are database functions e.g what would be the difference between SUM ( ) and DSUM ( )? 2. How are array functions useful ? 3. What is the syntax for VLOOKUP ( ) / HLOOKUP ( ) function? 4. What functions can be used to lookup data on both the sides of criteria mentioned ( INDEX ( ) / OFFSET ( )) 5. Name any error handling formulas included in Excel built in functions Questions would vary according the requirements of profile. Somehow I have found that error handling functions and lookup functions are asked in almost all the profiles that need good MS Excel skills. Hope that helps, Regards, Anand Kumar -- -- Some important links for excel 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 5. Excel Tips 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/discussexcel
$$Excel-Macros$$ Excel Utility for retrieving data from website
Hi All I want to make a utility to extract data from website or refresh after desired time and save option too. What i want exactly is : i want to extract share prices from website and want to make a dashboard type to see & save the price. otherwise i have the option to type that data manually from the website. Please Help Regards, Deepak -- -- Some important links for excel 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 5. Excel Tips 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/discussexcel
Re: $$Excel-Macros$$ need help!
First problem: Read guidelines for posting questions. DESCRIBE THE PROBLEM! Your Subject line should give a brief description of the problem. You should elaborate in the email, and explain what you've tried and where the error is. THEN attach a file if it helps. We have many helpful users here who value their time. People with a passion for pivot tables will jump right in when there is a pivot table question. If the problem is with date calculations, others will be helpful. A fewer number have expertise in Oracle or Access database access. But only the really bored ones will take the time to investigate posts like: Need Help! Urgent! Please answer! Instead, there are people like me that receive between 50 and 200 emails every night and USUALLY simply delete those where the author isn't willing to spend the time to describe his/her problem, but expects everyone to drop what they're doing and help simply because it's "urgent"... sorry for the rant... It just happened to strike at a bad time... P From: syed aliya raza hashim To: excel-macros@googlegroups.com Sent: Wed, April 13, 2011 1:52:33 AM Subject: $$Excel-Macros$$ need help! Plz solve my problem! -- syed aliya -- -- Some important links for excel 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 5. Excel Tips 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/discussexcel -- -- Some important links for excel 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 5. Excel Tips 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/discussexcel
$$Excel-Macros$$ Re: need help!
Dear Syed, Pls attach the solution file. Pls let me know was it helpful or any problem. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel 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 5. Excel Tips 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/discussexcel Copy of Solve.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Excel formula help
Thank you for your solution. On Wed, Apr 13, 2011 at 10:19 AM, STDEV(i) wrote: > try this formula and see if it helps > > =SUM(OFFSET($D8:$I8,0,0,1,MONTH(TODAY( > > > > On Wed, Apr 13, 2011 at 12:23 AM, vinod rao wrote: > >> Hi, >> I need a formula adding each month one column. >> Attached file has a details. >> >> Regards, >> Vin >> > -- > > -- > Some important links for excel 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 > 5. Excel Tips 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/discussexcel > -- -- Some important links for excel 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 5. Excel Tips 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/discussexcel
Re: $$Excel-Macros$$ need help!
find the attached workbook Thanks, Irfan Khan On Wed, Apr 13, 2011 at 11:22 AM, syed aliya raza hashim wrote: > Plz solve my problem! > > > -- > syed aliya > > -- > -- > Some important links for excel 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 > 5. Excel Tips 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/discussexcel > -- Thanks, Irfan Ahmed Khan -- -- Some important links for excel 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 5. Excel Tips 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/discussexcel Copy of Solve.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Open Excel addin is unavailable
Dear Expert, The download link of the Open Excel addin is unavailable on http://www.openexcel.com The unavailable link is http://excel-macros.googlegroups.com/web/OpenXLBeta1.0.0.0.zip?gda=7UqvmUcAAABeK1bCvIVb6K29sqTYZWWthiVAWnx9NyJFXKNtI9V7lZpobs5UV66bp34JBeMmF1cbzHe87USdioT9uNiA7PHaeV4duv6pDMGhhhZdjQlNAw If you would provide any other link then it would be helpful. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel 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 5. Excel Tips 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/discussexcel
Re: $$Excel-Macros$$ need help!
On Wed, Apr 13, 2011 at 11:22 AM, syed aliya raza hashim < hashim...@gmail.com> wrote: > Plz solve my problem! > > > > -- > syed aliya > > -- > > -- > Some important links for excel 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 > 5. Excel Tips 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/discussexcel > -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel 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 5. Excel Tips 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/discussexcel Solve.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ MACRO :PASTE SPECIAL
Hi All, Yes. Thank you all for the generosity displayed for me . This is working now. But, the macro causes loss of formating i.e. Column & row width . Is it possible to avoid this. Thanks in Advance. Regards, C.G.Kumar AMW-2 On Wed, Apr 13, 2011 at 1:39 AM, hanumant shinde wrote: > I think its done. please check and let us know if this is what you wanted > to do. > > > *From:* C.G.Kumar > *To:* excel-macros@googlegroups.com > *Cc:* schreiner_p...@att.net > *Sent:* Mon, 11 April, 2011 8:52:17 PM > *Subject:* Re: $$Excel-Macros$$ MACRO :PASTE SPECIAL > > Thanks Paul. > > I have amended macro.Pls find attached file with Macro named Paul() .But > still the function is not working. > > Objective is to > > 1. Copy each sheet and paste values retaining format in the same sheet > except Sheet M10701403 in the workbook. > > > Hope u suggest me way out. > > > Regards, > > C.G.Kumar > > > > > On Mon, Apr 11, 2011 at 6:28 PM, Paul Schreiner wrote: > >> I was going to ask what it was doing, or not doingif you stepped through >> the code. >> >> But I think I see your main problem. >> >> the statemtent: >> Select Case "M10701403" >> >> means nothing.. >> you're not COMPARING anything! >> >> I think what you're wanting is: >> >> Select case ws.Name >>Case "M10701403" >>'Do Nothing >>Case Else >> Cells.Select >> Selection.Copy >> Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, >> SkipBlanks _ >> :=False, Transpose:=False >> Application.CutCopyMode = False >> End Select >> >> Next: >> >> ws.UsedRange.Copy >> should copy the cells that are "used" to the Excel clipboard. >> >> Cells.Select >> Selection.Copy >> Immeately replaces the clipboard with ALL cells in the worksheet. >> >> You should use one or the other... using both is a waste of resources. >> >> hope this helps, >> >> Paul >> >> -- >> *From:* C.G.Kumar >> *To:* excel-macros@googlegroups.com >> *Sent:* Mon, April 11, 2011 5:47:04 AM >> *Subject:* $$Excel-Macros$$ MACRO :PASTE SPECIAL >> >> Dear all, >> >> Following code i am using to select each worksheet (except ) to copy and >> paste special values in each worksheet in same workbook. But, i am not >> getting desired output . >> >> Could you one help to rectify the following code; >> >> >> Sub ConvertToValues() >> Dim ws As Worksheet >> For Each ws In Worksheets >> Select Case "M10701403" ' EXCLUDED Sheet M107014031 To DO NOTHING >> >> Case Else >> ws.UsedRange.Copy >> Cells.Select >> Selection.Copy >> Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, >> SkipBlanks _ >> :=False, Transpose:=False >> Application.CutCopyMode = False >> End Select >> Next ws >> Application.CutCopyMode = False >> End Sub >> >> >> -- >> >> -- >> Some important links for excel 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 >> 5. Excel Tips 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/discussexcel >> >> -- >> >> -- >> Some important links for excel 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 >> 5. Excel Tips 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/discussexcel >> > > -- > > -- > Some important links for excel 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 > 5. Excel Tips 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/discussexcel > > -- > >
$$Excel-Macros$$ inputbox format
In Column C I have a format of h:mm:ss. How do I tell my inputbox when the user enters a number such as 10, or 20 etc... that it should be 0:10:0, 0:20:0, etc... Thanks so much for any help at all. -- -- Some important links for excel 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 5. Excel Tips 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/discussexcel
$$Excel-Macros$$ optionbuttons
Why is some option buttons linked to each other and some not? I have 2 that will cancel each other out when the oposite one is selected. Then I have 4 others that do the same but are not affected by the first 2. Thanks for any help. -- -- Some important links for excel 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 5. Excel Tips 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/discussexcel