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
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?
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
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
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
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
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
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
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
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
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
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
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
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
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
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 ---
-- 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
--
-
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
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
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.
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
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
@ 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
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
24 matches
Mail list logo