$$Excel-Macros$$ How to attach?

2010-08-06 Thread robert cheung
I have a project I'd like to share on this discussion board, but every time I click "New Post", there is not a place for me to attach a file with my request. How can I do this? -- -- Some important links for excel use

Re: $$Excel-Macros$$ Excel VBA : Unique Values

2010-08-06 Thread Neeraj Lamba
Sundarvelan, Uploaded a file in http://groups.google.com/group/excel-macros/files with Team+List_Home.xls name. This will add new name automatically when you add name in your data. Does any one help me? I am not getting option to upload file in post? How & From where I can upload in post directly?

$$Excel-Macros$$ Question asked in Interview...

2010-08-06 Thread Vijay Kr. Aggarwal
Hi, Please check attached file. Kindly provide answers through macro and functions. Regards, Vijay Kumar Aggarwal 048542 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and li

Re: $$Excel-Macros$$ Re: find a value of intersection of two graph in excel

2010-08-06 Thread Rayfoskidd
Hi, A neat little solution. However the answer interpolates between the values on each side. A series based on curves will lose accuracy, regards Ray In a message dated 06/08/2010 17:17:43 GMT Daylight Time, m99pan...@gmail.com writes: Cell B4 isnt blank...I suggested that he put

Re: $$Excel-Macros$$ Urgent: Help required in VBA form

2010-08-06 Thread madhukar reddy
Hi Pankaj What is the password of Excel sheet Regards Madhu From: Intelligent But Crazy To: excel-macros@googlegroups.com Cc: Intelligent But Crazy Sent: Tue, 3 August, 2010 9:43:41 PM Subject: $$Excel-Macros$$ Urgent: Help required in VBA form Hi g

Re: $$Excel-Macros$$ Need max date

2010-08-06 Thread Srinivasan Ethirajalu
you can use whole "# & Date" columns for in preparing pivot table On 8/6/10, Nadine S wrote: > > Thank you but a pivot table won't work for me. It needs to be a formula > in the particular cell all the way down the row of data. I wish I could use > the pivot table and I'd be done but it

RE: $$Excel-Macros$$ Time Slot from Time

2010-08-06 Thread Deepak Jena
Hi owner,   Can you please remove my email id from the mailing list regards Deepak --- On Sat, 7/17/10, Dave Bonallack wrote: From: Dave Bonallack Subject: RE: $$Excel-Macros$$ Time Slot from Time To: "excel-macros@googlegroups.com" Date: Saturday, July 17, 2010, 7:31 PM Hi, Have a look

$$Excel-Macros$$ Re: find a value of intersection of two graph in excel

2010-08-06 Thread Michael Hayes
Cell B4 isnt blank...I suggested that he put his X Axis coordinates beginning in cell B4. In cell B4, I said enter the number 1. In cell C4 enter the number 2 etc. Part of the difficulty in solving the math behind this problem is that there were missing variables. The X axis coordinates were missin

$$Excel-Macros$$ Re: WebBrowser

2010-08-06 Thread Kishan Reddy, K
Can you send your application. I will check once. Regards, Kishan Reddy, K kishanreddy.kethire...@gmail.com On Aug 1, 9:07 pm, Anju wrote: > Any Updates ? > > > > On Sat, Jul 31, 2010 at 7:40 PM, anju wrote: > > I am using a WebBrowser control in my application. When i try to > > download the

Re: $$Excel-Macros$$ Excel VBA : Unique Values

2010-08-06 Thread Kishan Reddy, K
Just use Pivot table. Regards, Kishan Reddy, K On Aug 6, 4:29 pm, Sundarvelan N wrote: > Hi Abhishek, > > Could you help in one more task also. > > That is under each Team leader i need to have corresponding agents name. > > Please help. > > Thanks > Sundarvelan > > > > > > On Fri, Aug 6, 2010

Re: $$Excel-Macros$$ Re: find a value of intersection of two graph in excel

2010-08-06 Thread sudhir kumar
Dear michael, thanks for the solution, but it is better if you will send all this formula in a excel sheet. then its easy for me to understand. Regards. On Fri, Aug 6, 2010 at 2:10 AM, Michael Hayes wrote: > Sudhir, > > I am assuming by the subject matter of your posting you need to find > the X

Re: $$Excel-Macros$$ Need max date

2010-08-06 Thread Nadine S
Thank you but a pivot table won't work for me.  It needs to be a formula in the particular cell all the way down the row of data.  I wish I could use the pivot table and I'd be done but it just won't work in this case. From: Srinivasan Ethirajalu To: excel-ma

RE: $$Excel-Macros$$ Fwd: Help needed - Count Unique Values based on matching criteria

2010-08-06 Thread Dhartikumar Sahu
Hi pravin Use countif Regards Dhartikumar -Original Message- From: praveen kumar Sent: 06 August 2010 14:38 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fwd: Help needed - Count Unique Values based on matching criteria -- Forwarded message -- From: pravee

Re: $$Excel-Macros$$ Excel VBA : Unique Values

2010-08-06 Thread Sundarvelan N
Hi Abhishek, Please help to proceed with ur idea. Thanks, Sundarvelan On Fri, Aug 6, 2010 at 1:27 PM, Abhishek Jain wrote: > Dear Sundar, > > There are two things - > > First - > > If you want to put all unique values (the existing ones and the newly > added) in those 3 columns and are ready to

Re: $$Excel-Macros$$ Excel VBA : Unique Values

2010-08-06 Thread Abhishek Jain
Sundar, I don't understand "what is my idea". I told you two different options. Does the first option not help you ? Have you tried adding those 2 lines in your code ? I mean that's what you asked at the first place. The code was giving an error upon running second time because the cells were not

Re: $$Excel-Macros$$ Fwd: Help needed - Count Unique Values based on matching criteria

2010-08-06 Thread Abhishek Jain
Dear Praveen, Please see the attached file and advise if this is what you want. Please note that the formula is an array formula and has to be entered with Ctrl+Shift+Enter each time you make a change in that. Cheers! AJ On 8/6/10, praveen kumar wrote: > > -- Forwarded message ---

$$Excel-Macros$$ Fwd: Help needed - Count Unique Values based on matching criteria

2010-08-06 Thread praveen kumar
-- Forwarded message -- From: praveen kumar Date: Thu, Aug 5, 2010 at 7:47 PM Subject: Help needed - Count Unique Values based on matching criteria To: mac...@googlegroups.com Hi Group, Help me to get this done. -- Regards, praveen -- Regards, praveen -- -

Re: $$Excel-Macros$$ Help with Macros and Userform!

2010-08-06 Thread Abhishek Jain
Hi, This seems to be interesting and I am sure many in the group would eagerly help you out. If you could share your file (or similar file) then it would be much easier to undestand and provide you solution(s). That's my opinion. Regards, AJ On 8/6/10, robert cheung wrote: > > So I just got

Fwd: $$Excel-Macros$$ Re: automation error

2010-08-06 Thread mohd ateeq
Hi Dave, i have seen you solving many issues, so i request you to even have a look at the problem i am facing. i tried different ways but still it shows the same error and excel crashes. please help me out. -- Forwarded message -- From: mohd ateeq Date: Thu, Aug 5, 2010 at 8:00

$$Excel-Macros$$ CAN HTML file Connect to Excel file

2010-08-06 Thread Rajesh Nair
Hi , CAN HTML file Connect to Excel file Can any one please send me the examples Regards, Rajesh. N -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.

$$Excel-Macros$$ Help with Macros and Userform!

2010-08-06 Thread robert cheung
So I just got a side project dumped on my plate at work doing some VBA stuff because I'm the only one there that knows anything about any language (I do mostly web stuff). It kinda sucks because I am not great with object oriented stuff (by that I mean I'm a noob). So I was humbly wondering if you

$$Excel-Macros$$ Re: automation error

2010-08-06 Thread Stuart Redmann
On 19 Jul., mohd ateeq wrote: > > > HI all, > > > Can anyone help me out with the following error: > > > Run-time error ‘-2147417848 (80010108)’: > > > Automation error > > > The object invoked has disconnected from its clients > > > It occurs when I create around 30-40 new excel files based on som

$$Excel-Macros$$ Re: find a value of intersection of two graph in excel

2010-08-06 Thread anandydr
@ Michael Hayes Dear Michael, I went through the solution you sent for Mr Sudhir. Using his spreadsheet I used the formula you have suggested. I got the results but not the logic behind. How are we getting results even though the cells B4 & C5 are blank, and what are these being used for??? Rega

Re: $$Excel-Macros$$ Excel VBA : Unique Values

2010-08-06 Thread Abhishek Jain
Dear Sundar, There are two things - First - If you want to put all unique values (the existing ones and the newly added) in those 3 columns and are ready to hit Update button every time then add the following two lines in the beginning of your code - *Range("N5:P65000").Select Selection.ClearCo