Re: $$Excel-Macros$$ regd: drop down button

2011-02-28 Thread §»VIPER«§
HI Naresh, Have look at this, i did something by using function, find the attachment. -- *Thanks Regards Thamu * On Mon, Feb 28, 2011 at 11:52 AM, SAJID MANSOOR sajidmansooral...@gmail.com wrote: Why are you using this lengthy formula? =INDIRECT(VLOOKUP($B$15,I$2:I$6,1,0)) instead of

Re: $$Excel-Macros$$ Multi User in Excel file

2011-02-28 Thread §»VIPER«§
Sajid Tools Share Workbook -- *Thanks Regards Thamu * On Sun, Feb 27, 2011 at 10:38 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Sajid, Yes, it can be done. Share your file and provide the LAN path of the file to all the respective users. Sharing of the file (workbook) will

$$Excel-Macros$$ Fomula to find the Missing Numbers in the sequence - Reg

2011-02-28 Thread Prathap
Dear All, I have an excel sheet in which i need to find the missing numbers in the sequence. Please help me with the formula to identify missing numbers in a list of consecutive numbers. Example : Best Regards, Prathap --

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

2011-02-28 Thread Aindril De
Hi Ayush, How about XLS (Excel Simplified in Short) Andy On Mon, Feb 28, 2011 at 12:42 PM, Dave Bonallack davebonall...@hotmail.comwrote: Hi Ayush, Perhaps you could play with the word 'Accelerate' Some suggestions would be: Excelerated Learning Excelerated Solutions Excelerating.com

Re: $$Excel-Macros$$ 20 days Left : Here is first Look of discussexcel.com

2011-02-28 Thread sudhir kumar
It is best. On 24 February 2011 18:38, Ayush jainayus...@gmail.com wrote: https://discussexcel.com Dear Group, I have completed the designing part and here is the first look of website. The content development is in progress. Please let me know if you have any feedback , suggestions on

$$Excel-Macros$$ Hi All,

2011-02-28 Thread Kishor Kumar Singh
Hi friends, I want make a software for Corrupted Excel Files . Please Suggest me It's Good or Bad as per depend on current Industry value. Can it success in the current position. I have request to you all people . please give me your advice. -- With Regards, Kishor Kumar Singh Sr.Software

Re: $$Excel-Macros$$ To Reconcile Two Reports

2011-02-28 Thread kurikkal padinjarappalla
Dear Mahesh, Thanks for your reply, I have tried using this, but it does not generated a proper output, it may due to the way I used it, please find the attached sheet showing the result which i got, and please rectify me where i did mistake. Regards, Kurikkal. On Sun, Feb 27, 2011 at 9:13 PM,

$$Excel-Macros$$ Re: Fomula to find the Missing Numbers in the sequence - Reg

2011-02-28 Thread saggi
Insert new column then use this formula in column C =RIGHT(B3,3) =IF(C2-C1=1,,missing) Regards Saggi -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ regd: drop down button

2011-02-28 Thread rakesh kumar
How does that drop down button auto hides. Could you please tell me ? How do I place same in my excel sheet. Regards On Mon, Feb 28, 2011 at 12:56 PM, §»VIPER«§ viper@gmail.com wrote: at this, i did something by using function, find the attachment. -- Rakesh kumar khowal +91

Re: $$Excel-Macros$$ regd: drop down button

2011-02-28 Thread naresh v
Thanks Thammu, Anil and Dilip. On Mon, Feb 28, 2011 at 11:52 AM, SAJID MANSOOR sajidmansooral...@gmail.com wrote: Why are you using this lengthy formula? =INDIRECT(VLOOKUP($B$15,I$2:I$6,1,0)) instead of =INDIRECT($B$15)   (Working Fine as above one) On Sun, Feb 27, 2011 at 10:19 PM, Dilip

Re: $$Excel-Macros$$ Urgent required help in excel

2011-02-28 Thread Jitender kumar
Dear Excel Guru/Ashish/Dilip Thanks for your valuable solution.But the problem is still here, Because I want to print it according to MRP Dcode wise on different sheet of paper(Pivot table can doit), I know page break works but doing page break on every dcode and MRP is very tough task wwhen

$$Excel-Macros$$ I repeat again, anyone can help me?

2011-02-28 Thread ChilExcel
I need to extract dynamic table, named worksheet or book name (for each double click) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip

$$Excel-Macros$$ Fwd: I repeat again, anyone can help me?

2011-02-28 Thread ChilExcel
attached file Thx -- Forwarded message -- From: ChilExcel chilexcel...@gmail.com Date: 2011/2/28 Subject: I repeat again, anyone can help me? To: excel-macros@googlegroups.com I need to extract dynamic table, named worksheet or book name (for each double click) --

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

2011-02-28 Thread Ayush Jain
Thanks Dave Aindril for awesome ideas i will share the final one soon :) Regards On Mon, Feb 28, 2011 at 4:09 PM, Aindril De aind...@gmail.com wrote: Hi Ayush, How about XLS (Excel Simplified in Short) Andy On Mon, Feb 28, 2011 at 12:42 PM, Dave Bonallack

Re: $$Excel-Macros$$ Fwd: I repeat again, anyone can help me?

2011-02-28 Thread ashish koul
try this Sub Macro1() Dim s, y As Range Set s = Sheets(PivoTTable).UsedRange For Each y In s If y.Value = 0 And Not IsEmpty(y.Value) Then If IsNumeric(y.Value) Then y.ShowDetail = True End If End If Next y 'Range(E13).Select 'Selection.ShowDetail = True End Sub On Mon,

Re: $$Excel-Macros$$ regd: drop down button

2011-02-28 Thread Mahesh parab
Hi Thamu well done ! On Mon, Feb 28, 2011 at 12:56 PM, §»VIPER«§ viper@gmail.com wrote: HI Naresh, Have look at this, i did something by using function, find the attachment. -- *Thanks Regards Thamu * On Mon, Feb 28, 2011 at 11:52 AM, SAJID MANSOOR sajidmansooral...@gmail.com

Re: $$Excel-Macros$$ 20 days Left : Here is first Look of discussexcel.com

2011-02-28 Thread Indrajit $nai
*Great going Ayush* On Mon, Feb 28, 2011 at 5:53 PM, sudhir kumar bluecore...@gmail.com wrote: It is best. On 24 February 2011 18:38, Ayush jainayus...@gmail.com wrote: https://discussexcel.com Dear Group, I have completed the designing part and here is the first look of website.

$$Excel-Macros$$ Export Data

2011-02-28 Thread Vikas Chouhan
HI Expats, Greeting for New Day !!! I want to export data from mysql to .csv format. just want to click in command button and data save to define location.. it's very urgent so pls help me ! -- One Team One Dream One Goal Warm Regards, *Vikas Chauhan*

Re: $$Excel-Macros$$ 20 days Left : Here is first Look of discussexcel.com

2011-02-28 Thread Dhartikumar Sahu
it's good product well designedkeep it up Ayush Dhartikumar Sahu Sr.Database Manager - Equity Research 9920342276 On Tue, Mar 1, 2011 at 1:01 AM, Indrajit $nai talk2indra...@gmail.comwrote: *Great going Ayush* On Mon, Feb 28, 2011 at 5:53 PM, sudhir kumar

Re: $$Excel-Macros$$ 20 days Left : Here is first Look of discussexcel.com

2011-02-28 Thread Vikash Chandra
Hi ayush, it's very good well designedkeep it up Ayush Thanx for your initiative Regards, Vikash Chandra Bangalore 9902622922 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

Re: $$Excel-Macros$$ Nakshtra querry

2011-02-28 Thread §»VIPER«§
Hi Find the attachment -- *Thanks Regards Thamu * On Wed, Feb 23, 2011 at 3:06 PM, Nemi Gandhi nemigan...@gmail.com wrote: file is attached. Please help. -- Nemi Gandhi 98204 92963 -- -- Some

RE: $$Excel-Macros$$ Insert row based on criteria

2011-02-28 Thread Pehrson, Dave
Ashish, This works great, I'm just beginning to learn the basics of VB, To a newbie like me, the code seems strange, if you have a minute could you explain what your simple commands are doing. Maybe I can learn to expand for other options. Again, thanks for your help and support.

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

2011-02-28 Thread Maries
Dear Ayush, Find below My suggestions: == *Excel World* or *Xcel Duniya* == *Excel Inspiration* or *Xcel Inspiration* Rgds, Maries. On Mon, Feb 28, 2011 at 9:14 PM, Ayush Jain jainayus...@gmail.com wrote: Thanks Dave Aindril for awesome ideas i will share the final one soon :) Regards

Fwd: $$Excel-Macros$$ To Reconcile Two Reports

2011-02-28 Thread kurikkal padinjarappalla
Can somebody help please -- Forwarded message -- From: kurikkal padinjarappalla padinjarappa...@gmail.com Date: Mon, Feb 28, 2011 at 12:40 PM Subject: Re: $$Excel-Macros$$ To Reconcile Two Reports To: excel-macros@googlegroups.com Cc: Mahesh parab mahes...@gmail.com, ashish koul

Re: $$Excel-Macros$$ To Reconcile Two Reports

2011-02-28 Thread ashish koul
can you send the report on which you want to apply the formulae On Tue, Mar 1, 2011 at 10:56 AM, kurikkal padinjarappalla padinjarappa...@gmail.com wrote: Can somebody help please -- Forwarded message -- From: kurikkal padinjarappalla padinjarappa...@gmail.com Date:

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

2011-02-28 Thread NOORAIN ANSARI
Hey Ayush.. As per my Idea : 1. Exlsolution.com 2. EXL-WORLD.com 3. EXL-Garden.com 4. EXL-Station.Com Thanks regards, Noorain Ansari On Tue, Feb 22, 2011 at 11:29 PM, Ayush Jain jainayus...@gmail.com wrote: Dear members, I am too excited to share that discussexcel.com website development