$$Excel-Macros$$ optionbuttons

2011-04-13 Thread Dick
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. -- -

$$Excel-Macros$$ inputbox format

2011-04-13 Thread Dick
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 importan

Re: $$Excel-Macros$$ MACRO :PASTE SPECIAL

2011-04-13 Thread C.G.Kumar
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 thin

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

2011-04-13 Thread rajan verma
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

$$Excel-Macros$$ Open Excel addin is unavailable

2011-04-13 Thread Bhushan Sabbani
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=7UqvmUcAAABeK1bCvIVb6K29sqTYZWWthiVAWnx9NyJFXKNtI9V7lZpobs5UV66bp34JBeMmF1cbzHe87USdioT9uNiA7PHaeV4duv6pDM

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

2011-04-13 Thread irfan khan
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. Foll

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

2011-04-13 Thread vinod rao
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 f

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

2011-04-13 Thread Bhushan Sabbani
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 tric

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

2011-04-13 Thread Paul Schreiner
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

$$Excel-Macros$$ Excel Utility for retrieving data from website

2011-04-13 Thread Deepak Rawat
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 f

$$Excel-Macros$$ Re: Excel Interview Question - Help

2011-04-13 Thread anandydr
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 ( ) func

$$Excel-Macros$$ need help!

2011-04-13 Thread syed aliya raza hashim
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.linkedi

Re: $$Excel-Macros$$ Re: Need Small Help to pull values based on the criteira!

2011-04-13 Thread Bhushan Sabbani
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 : h