Hi Nadine,
Have a look at the attached.
It's a bit long-winded, but seems to work ok.
Regards - Dave.
Date: Sun, 1 Aug 2010 08:23:35 -0700
From: n8dine4ma...@yahoo.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
I have information in the first three cells of a worksheet
Hi,
This is close, but not quite there. The lookup is in cell A1, and
there are two tables, B2 thru C15 and D2 thru E15. The Formula is in
cell A2. It still needs some work, but I think the concept is there.
15
T1 1 1 15 15
2 2 16 16
3 3
You're welcome
Dave.
> Date: Sun, 1 Aug 2010 10:24:21 -0700
> Subject: Re: $$Excel-Macros$$ Question re: cell comments and validated lists
> From: simon_mc_webs...@yahoo.co.uk
> To: excel-macros@googlegroups.com
>
> That's it exactly! Many thanks Dave,
>
> Sid.
>
> On 1 Aug, 13:32, Dave Bona
Hello. I'd like to use the equation editor in excel 2010 through VBA. In
Word, the equation object is OMath (
http://msdn.microsoft.com/en-us/library/bb256563%28office.12%29.aspx), and
the macro recorder records some actions done to such an object (like
changing equations from professional to inlin
That's it exactly! Many thanks Dave,
Sid.
On 1 Aug, 13:32, Dave Bonallack wrote:
> I forgot to say that the drop-down is in C1
>
> Regards - Dave.
>
> > Date: Sun, 1 Aug 2010 01:36:25 -0700
> > Subject: $$Excel-Macros$$ Question re: cell comments and validated lists
> > From: simon_mc_webs...@y
Hi All,
The report that I generate is sorted on column "S" and then it is hidden
using VBA code.After the sorting is done I want to display only characters
from 7 to 25 from row b6 to B1000.
Eg. PM 00 New York,NY. We need to diaplay only New York,NY.How to
do this programatically?
Tha
Resending with a subject. Sorry.
I have information in the first three cells of a worksheet and in the forth is
a
Yes or No.
In worksheet 2 the first three columns contain the same type of information as
in sheet1 but sheet 1 can list that information mult
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 file through this control, it will show a pop-up of
> "File Download".
>
> I tried to handle it automatically and hove done this.
>
> But now I want to hi
I have information in the first three cells of a worksheet and in the forth is
a
Yes or No.
In worksheet 2 the first three columns contain the same type of information as
in sheet1 but sheet 1 can list that information multiple times whereas sheet 2
only lists that unique combination once.
Exam
Any progress on the file formating?
*Joel*
On Sun, Jul 25, 2010 at 03:35, Sandeep Kumar Maurya
wrote:
> Hi,
> I got your file but next time use gmail and attach in the mail.
>
>
> Thanks & Regards
> Sandeep
>
> On Sun, Jul 25, 2010 at 1:02 AM, JD <5635.daw...@gmail.com> wrote:
> > How do I atta
hi friend,
i attached an excel file, which having some information in it, now i want
that if i will do any type of change in it, i will be able to trace it,
means, i change in some of the column or row, or i introduce any new row ,or
delete any row. every type of change i want to trace.,
plz help.
I forgot to say that the drop-down is in C1
Regards - Dave.
> Date: Sun, 1 Aug 2010 01:36:25 -0700
> Subject: $$Excel-Macros$$ Question re: cell comments and validated lists
> From: simon_mc_webs...@yahoo.co.uk
> To: excel-macros@googlegroups.com
>
> Good Evening Gurus,
>
> I have a quick que
Hi,
I think this can only be done with an event macro.
Have a look at the attached.
regards - Dave.
> Date: Sun, 1 Aug 2010 01:36:25 -0700
> Subject: $$Excel-Macros$$ Question re: cell comments and validated lists
> From: simon_mc_webs...@yahoo.co.uk
> To: excel-macros@googlegroups.com
>
> G
Hi Team,
Can anyone provide me a macro which can extract the sent items mail details
from Microsoft Outlook 2007
I want the details in excel sheet
& required Details are
Mail Recd from Recd Date recd Time Mail Sent date Mail sent to
Subject Mail sent Date mail sent Time
All details Can
how is it possible to doi this ? :) Regards
2010/8/1 N.Shivkumar
> Dear Kamlesh Jain
> Is it possible to send me the file I will find the passwod
>
> BYe
>
> N.SHIVKUMAR
> Mobile : +919422613567
> Office : +912332301775
> Alternate Email: shiv1...@yahoo.com
>
>
>
> On 31 July 2010 21:08, Vikas
Good Evening Gurus,
I have a quick question (the answer to which has probably been staring
me in the face all day!).
Is it possible to make a selection from a drop down validated list and
have the associated comment attached to the cell in that list 'follow'
the selection to the target cell?
For
Hi,
Try changing the formula in M3 to:
IF(COUNT(M1,M2)>0,SUM(M1:M2),"")
I think M1+M2 is the problem. The '+' operand can't seem to handle non-numeric
inputs, whereas the SUM function has a built-in ability to ignore them.
Regards - Dave.
Date: Sat, 31 Jul 2010 22:42:34 -0700
Subjec
17 matches
Mail list logo
