$$Excel-Macros$$ pls help me solve my query.

2012-08-03 Thread Kenil Gala
hi folks,i am having a query in getting external data,pls help me for the same.i have written my query in the excel sheet. Thanks in adv, Regards, -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,

$$Excel-Macros$$ just a wild thought regarding table in one cell

2012-08-03 Thread सुनिता पौडेल
Dear all, Is there any possibility to create a small table where data can be put to clarify the reason of the amount of one certain cell instead of inserting a comment box? I mean if we can insert a table instead of only text like in insert box. If it is possible then it will help me on my work

Re: $$Excel-Macros$$ just a wild thought regarding table in one cell

2012-08-03 Thread अनिल नारायण गवली
pl share a data with groups. Regards, Gawli Anil On Fri, Aug 3, 2012 at 11:52 AM, सुनिता पौडेल tosune...@gmail.com wrote: Dear all, Is there any possibility to create a small table where data can be put to clarify the reason of the amount of one certain cell instead of inserting a comment

Re: $$Excel-Macros$$ just a wild thought regarding table in one cell

2012-08-03 Thread सुनिता पौडेल
I have tried to explain what I want it to be in comment box. I hope I am able to explain. Thanx On Fri, Aug 3, 2012 at 12:09 PM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: pl share a data with groups. Regards, Gawli Anil On Fri, Aug 3, 2012 at 11:52 AM, सुनिता पौडेल tosune...@gmail.com

$$Excel-Macros$$ manpower service

2012-08-03 Thread vivek
As per the new provision of reverse charge mechanism, 75% of service tax on supply of manpower service is to be paid by the service recipient if the service recipient is a company and the service provider is an individual, firm or AOP. My question is whether security agencies service also

Re: $$Excel-Macros$$ Need 1st highest 2nd highest user details

2012-08-03 Thread Lokesh Loki
Hi Noorain and Kantilal, Thanks for your valuable reply and the formula is working and also i got an exact resolution. Once again thank you for all. Regards Lokesh.M On Fri, Aug 3, 2012 at 11:08 AM, Kantilal Badale kantilal.bad...@gmail.comwrote: See Attached Sheet CA Kantilal Badale

Re: $$Excel-Macros$$ Fw: Urgent Help needed

2012-08-03 Thread dguillett1
Why is your request more urgent than the request of any of the others? Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: francis vinod Sent: Friday, August 03, 2012 2:35 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fw: Urgent Help needed

Re: $$Excel-Macros$$ Plz Help Me

2012-08-03 Thread dguillett1
When requesting help use a meaningful subject line explain in the post and in the file what you want where, from where, and why, You sent a file and expected all to read your mind. A look in the help index for COUNTIF would be helpful Oh heck, HERE =COUNTIF(Report!I:I,C5) Don Guillett

$$Excel-Macros$$ Re: Excel to Access Data

2012-08-03 Thread wirelesscellularguy
On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote: Hi All, I am trying to relate Access data queries to excel. The excel will be the user interface. This excel will contain the various buttons to get specific informations and clicking these buttons will fetch

$$Excel-Macros$$ Re: Excel to Access Data

2012-08-03 Thread wirelesscellularguy
Hi Swapnil, Many thanks. I will practice with the samples shared by you and will consult you in case I find any issues. Regards, Wireless On Friday, August 3, 2012 6:08:55 PM UTC+5:30, wirelesscellularguy wrote: On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:

Re: $$Excel-Macros$$ Fw: Urgent Help needed

2012-08-03 Thread francis vinod
Hi Don, I never said my request is more urgent than other's request, since I didn't get any response to my earlier mail and I had to do some reporting so included the word 'urgent' in the subject line that's all.   Thanks Regards, Francis From: dguillett1

$$Excel-Macros$$ Trace Precedents and Trace Error

2012-08-03 Thread Rajan_Verma
Hi Group, Is there any difference in Trace Precedents and Trace Error in Excel?? I don't need any link to see because I have already Google it. Regards Rajan verma +91 7838100659 [IM-Gtalk] -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

2012-08-03 Thread Sam Mathai Chacko
Trace Precendents and Trace Error is different from each other literally as it sounds. For any single cell containing any formula, its precedents are nothing but any cell or cells that it references in that formula. Trace Error on the other hand for any single cell containing any formula, is the

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

2012-08-03 Thread ChilExcel
Rajan These tool in Excel allows us to Trace Precedents in a formula, Trace Dependents , Show formulas, Error checking and Evaluating formula in Excel. [image: Imágenes integradas 1] detail *Trace Precedents:* When you click this button, Excel draws arrows to the cells (the so-called *direct

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

2012-08-03 Thread Sam Mathai Chacko
Rajan isn't asking about Formula Auditing, which I am sure he is aware of. His question is about the difference between Trace Precedents and Trace Error which are two separate features in Excel. Please read my post before. Regards, Sam Mathai Chacko On Fri, Aug 3, 2012 at 9:34 PM, ChilExcel

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

2012-08-03 Thread ChilExcel
Mr.Sam Mathai Chacko I only answer queries or questions .. if you do not like my answer you propose another solution .. and everyone happy!!! Chilexcel 2012/8/3 Sam Mathai Chacko samde...@gmail.com Rajan isn't asking about Formula Auditing, which I am sure he is aware of. His question

$$Excel-Macros$$ Marquee text in Powerpoint

2012-08-03 Thread rekha siri
Hi Experts, Please assist in this concern i deal with xlius earlier now we are using only power point dashboard presentation. is there any possibility to place the scrolling marquee kind of text as Headings of power point slides. which needs to be scrolling continously. Thanks, Rekha --

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

2012-08-03 Thread Sam Mathai Chacko
1. Your post came on top of my post, so there is no way of me proposing 'another' solution. 2. It is not your answer ( http://www.dummies.com/how-to/content/understanding-excel-2010s-formula-auditing-tools.html ) 3. There is no reason to feel offended. I was only saying that it was a different

$$Excel-Macros$$ Oracle DBA West Norristown, PA 6+ Months

2012-08-03 Thread Andrew Thomas
*Oracle DBA West Norristown, PA* *6+ Months* 7+ years working experience as a DBA 5+ years working experience on Unix/Linux Experience managing multi-terabyte databases. Proficient experience with Oracle 9i/10g/11g. Ability to design, implement and support Oracle production databases for high

RE: $$Excel-Macros$$ Trace Precedents and Trace Error

2012-08-03 Thread Rajan_Verma
Thanks Sam, answer was really helpful. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: 03 August 2012 9:34 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$

RE: $$Excel-Macros$$ Trace Precedents and Trace Error

2012-08-03 Thread Rajan_Verma
Thank chile. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ChilExcel Sent: 03 August 2012 9:34 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Trace Precedents and Trace Error

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

2012-08-03 Thread ChilExcel
1) I'm trying to say is that no matter if 1 or 2 to response, if bad or good response anrterior just answer something to contribute and you! 2) yes is a copy of ( http://www.dummies.com/how-to/content/understanding-excel-2010s-formula-auditing-tools.html) You will not wait to draft all

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

2012-08-03 Thread Sam Mathai Chacko
:) ending this here. No comments On Fri, Aug 3, 2012 at 10:27 PM, ChilExcel chilexcel...@gmail.com wrote: 1) I'm trying to say is that no matter if 1 or 2 to response, if bad or good response anrterior just answer something to contribute and you! 2) yes is a copy of (

Re: $$Excel-Macros$$ Oracle DBA West Norristown, PA 6+ Months

2012-08-03 Thread noorain . ansari
Dear andrew, Job posting is ban here. Sent from BlackBerry® on Airtel -Original Message- From: Andrew Thomas andrew...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 3 Aug 2012 22:03:52 To: andrew...@gmail.com Reply-To: excel-macros@googlegroups.com Subject:

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

2012-08-03 Thread ChilExcel
Mr Sam Mathai Chacko Yes i make last comment ...!! You start a discussion unutil only to draw attention? or just bothering I do not know how you use your time but mine is important Now yes.. I end up here Chilexcel 2012/8/3 Sam Mathai Chacko samde...@gmail.com :) ending this here.

$$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-03 Thread Ayush Jain
Dear members, Noorain Ansari has been selected as 'Most Helpful Member' for the month of July'12. He has posted 143 posts in July 2012 and helped many forum members through his excel expertise. I truly appreciate his consistency and commitment to the group. He is really doing great job. Thanks

Re: $$Excel-Macros$$ Oracle DBA West Norristown, PA 6+ Months

2012-08-03 Thread Prince Dubey
Gys please don't post anything that is related with job posting. On Friday, August 3, 2012 10:37:55 PM UTC+5:30, NOORAIN ANSARI wrote: Dear andrew, Job posting is ban here. Sent from BlackBerry® on Airtel -- *From: * Andrew Thomas andrew...@gmail.com *Sender: *

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

2012-08-03 Thread Prince Dubey
Hi Sam, Nice Answer. I wanted to ask this question before well doesn't matter to me, I got my answer. regards Prince On Friday, August 3, 2012 9:34:10 PM UTC+5:30, Sam Mathai Chacko wrote: Trace Precendents and Trace Error is different from each other literally as it sounds. For any

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-03 Thread Sam Mathai Chacko
Congrats Noorain. As always, your contributions help many. Regards, Sam Mathai Chacko On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain jainayus...@gmail.com wrote: Dear members, Noorain Ansari has been selected as 'Most Helpful Member' for the month of July'12. He has posted 143 posts in July

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-03 Thread respuzy
Congrats Boss. Keep up the momentum Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Ayush Jain jainayus...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 3 Aug 2012 23:10:25 To: excel-macrosexcel-macros@googlegroups.com Reply-To:

RE: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-03 Thread Asa Rossoff
Congratulations Noorain! From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Jain Sent: Friday, August 03, 2012 10:40 AM To: excel-macros Subject: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012 Dear members, Noorain Ansari has

Re: $$Excel-Macros$$ Marquee text in Powerpoint

2012-08-03 Thread David Grugeon
You might do better asking PowerPoint questions on a Powerpoint forum. As its name indicates this forum is about Excel Macros. On 4 August 2012 02:24, rekha siri rekha.siri2...@gmail.com wrote: Hi Experts, Please assist in this concern i deal with xlius earlier now we are using only power

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-03 Thread dguillett1
Good work! Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Ayush Jain Sent: Friday, August 03, 2012 12:40 PM To: excel-macros Subject: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012 Dear members, Noorain Ansari has been selected as 'Most

Re: $$Excel-Macros$$ Run-time error popup message

2012-08-03 Thread Lokesh Loki
Hi All, Still i am not getting reply from the experts. Please do the needful. Regards Lokesh.M On Thu, Aug 2, 2012 at 5:59 PM, lokesh lokeshsmg2...@gmail.com wrote: Hi All, When I am clicked the Get Report to know monthly report I got the error popup message window saying that

$$Excel-Macros$$ AUTO: Sharon Hutchison is out of the office (returning 20/08/2012)

2012-08-03 Thread Sharon Hutchison
I am out of the office until 20/08/2012. Any queries please contact x54455 Note: This is an automated response to your message $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 20 Messages in 11 Topics sent on 4/8/2012 1:10:52 AM. This is the only notification you will receive

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-03 Thread Manoj Kumar
*Cong Noorain! Ji* On Sat, Aug 4, 2012 at 4:16 AM, dguillett1 dguille...@gmail.com wrote: Good work! Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* Ayush Jain jainayus...@gmail.com *Sent:* Friday, August 03, 2012 12:40 PM *To:* excel-macros

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-03 Thread Govind Mori
Congrats Noorain. As always, your contributions help many. Govind Mori -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get

RE: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-03 Thread Rajan_Verma
Congrats noorain. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Jain Sent: 03 August 2012 11:10 To: excel-macros Subject: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-03 Thread Kuldeep Singh
Congratulations Noorain Sir. Regards, Kuldeep Singh Back Office Executive (MIS) Info Edge India Limited (naukri.com) Phone.: +91-120-4763789, Extn.: 789,9716615535 naukrikuld...@gmail.com || www.naukri.com || www.naukrigulf.com *Please* *Consider the environment. Please don't print this e-mail

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-03 Thread अनिल नारायण गवली
congrats noorian ansari:) Regards, Gawli Anil On Sat, Aug 4, 2012 at 10:38 AM, Kuldeep Singh naukrikuld...@gmail.comwrote: Congratulations Noorain Sir. Regards, Kuldeep Singh Back Office Executive (MIS) Info Edge India Limited (naukri.com) Phone.: +91-120-4763789, Extn.:

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-03 Thread Deba Ranjan
My Heartiest Noorain Bro, congrts many more. Really heart of this members. Thanks Regards, *Deba Ranjan P* On Sat, Aug 4, 2012 at 10:44 AM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: congrats noorian ansari:) Regards, Gawli Anil On Sat, Aug 4, 2012 at 10:38 AM,

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-03 Thread Sanjib Chatterjee
Dear Noorain Ansari Congratulation for your achievement. As I stated early that you are the God of Excel. Please keep it going so that many excel lovers are get help. Thanking you Regards, Sanjib Chatterjee On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain jainayus...@gmail.com wrote: Dear