You are welcome Manoj...!! :)
Best Regards,
DILIPandey
On 9/15/10, Manoj Kukreja wrote:
> Thanks Dilip.
>
> -Original Message-
> From: Dilip Pandey [mailto:dilipan...@gmail.com]
> Sent: Tuesday, September 14, 2010 10:56 PM
> To: excel-macros@googlegroups.com
> Cc: Manoj Kukreja
> Subject
Hi,
I am assuming that your first unique invoice numberis in A2.
Format B2 of the same sheet as Date, then enter the following:
=Sumproduct(Max((OtherSheet!A2:A100=A2)*(OtherSheet!B2:B100)))
Then copy down to the end of your unique data.
If you can't get this to work, post again with a sample
I have a list of dates in one sheet.
Col A = Invoice Number
Col B = Payment Date
There will be multiple rows for the same invoice number as payments are made
against it until it is paid in full.
Some of these rows will contain dates and some won't.
The next sheet has the unique list of invoice n
Hello,
I work in a mixed enviroment of mainly Office 2002, 2003 and 2007
machines. I wrote some code using Excel 2002 which is used by people
using 2002, 2003, 2007. The code was protected by giving the project
a complex password. I got some complaints of loss of functionality
and when I looked
Hi,
I am a bit new to VBA, I figured out how to open a word document from xl vba
by browsing online but I am facing hard time in searching for a particular
text in the word document and updating it with a particular cell from my xl
spreadsheet.
*Dim wrdDoc2 As Word.Document
Set wrdDoc2 =
Hi everyone,
I am trying to create a fan chart that displays the probability of
different outcomes occurring in the future for a single variable. An
example can be seen here:
http://www.bankofengland.co.uk/publications/inflationreport/mktgdpfeb09large.gif
Producing the different lines is easy bu
Hi,
Can you please help.
Regards,
Hemant Shah
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http:
I created a file with a VB macro long time ago for the final at the
college and now i can't figure out what are the passwords i used: is
there a way i can recover them or wok something out to delete those
passwords without loosing the Macro?
--
Hi Manoj,
Please find the solution attached with this email.
Note:- Going forward please mark Group as well so that every one gets
equal chances of learn and to help others :)
@ Group:- I have also attached the original query (image003.png) in
this email so that all can understand the query.
G
Please use application in macro coding.
On Tue, Sep 14, 2010 at 4:50 PM, عمر wrote:
> *Range("A" & i + 2).* = a2
>
> *Resize(1, 6)** = a2:f2*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *neil johnson
> *Sent:* Tuesday, September 14,
Range("A" & i + 2). = a2
Resize(1, 6) = a2:f2
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of neil johnson
Sent: Tuesday, September 14, 2010 9:17 AM
To: villager.g...@gmail.com; davebonall...@hotmail.com
Cc: excel-macros@googlegroups.com
Subject: $$Excel
Hi Sir,
Please explain that highlighted code . What is that means.
Dim i As Long, j As Long
For i = 0 To Me.ListBox1.ListCount - 1
If Me.ListBox1.Selected(i) Then
*
Worksheets("Sheet1").Range("A" & i + 2).Resize(1, 6).*Copy
Worksheets("Sheet2").Range("A" & Rows.
Maries please email me as well the Diary Doc i cannot get it by following
the link also.
It looks very interesting. Thanks
On Tue, Sep 14, 2010 at 5:46 AM, P.VIJAYKUMAR wrote:
> Hello,
>
> You can also find a wide variety of useful templates in the New section
> of Excel ribbons button in Exce
13 matches
Mail list logo
