Hi Ashish,
Its working perfectly. Thank you very much for all the help :-)
Regards,
Shraddha
On Tue, Sep 17, 2013 at 7:12 PM, ashish koul wrote:
> try this see if it helps
>
>
> Sub replace_tracker()
> Dim i As Long, j As Long
>
>
> For i = 2 To Sheets("Tracker").Range("a65356").End(x
try this see if it helps
Sub replace_tracker()
Dim i As Long, j As Long
For i = 2 To Sheets("Tracker").Range("a65356").End(xlUp).Row
With Application.WorksheetFunction
If .CountIf(Sheets("Daily Report").Range("a:a"),
Sheets("Tracker").Range("a" & i).Value) = 1 Then
j = .Matc
Yes
On 16 Sep 2013 20:12, "ashish koul" wrote:
> do u want to replace the exiting info on Tracker from Daily Report tab
>
>
> On Mon, Sep 16, 2013 at 5:44 PM, shraddha malvankar <
> shraddhamalvan...@gmail.com> wrote:
>
>> Hi,
>>
>> I am really new in macro, can you please help me in attached exc
do u want to replace the exiting info on Tracker from Daily Report tab
On Mon, Sep 16, 2013 at 5:44 PM, shraddha malvankar <
shraddhamalvan...@gmail.com> wrote:
> Hi,
>
> I am really new in macro, can you please help me in attached excel as well
> L I tired the same principle which you sent me l
Hi,
I am really new in macro, can you please help me in attached excel as
well LI tired the same principle which you sent me last time.
I have my entire report in tracker file which I send to team and they sent
me update daily in Daily report sheet. But they only work on few line items
Now I wan
Genius man…….
Thank you very much for help…This is exactly what I wanted…..
Really appreciated your help.
Regards,
Shraddha
On Sat, Sep 14, 2013 at 7:26 AM, ashish koul wrote:
> try this see if it works
>
> Sub send_venddetails()
> Dim i As Long
> Dim flname As String
> Dim objOL As Objec
try this see if it works
Sub send_venddetails()
Dim i As Long
Dim flname As String
Dim objOL As Object
Dim wkb As Workbook
Set objOL = CreateObject("Outlook.Application")
For i = 2 To Sheets("data").Range("a65356").End(xlUp).Row
With Sheets("Verification")
'clear exisitng if requir
Hi
R u using lotus notes or outlook for sending emails
Regards
Ashish
Sent on my BlackBerry® from Vodafone
-Original Message-
From: shraddha malvankar
Sender: excel-macros@googlegroups.com
Date: Fri, 13 Sep 2013 10:57:37
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Ma
Outlook.
Regards,
Shraddha
On Friday, 13 September 2013 22:10:58 UTC+4, ashish wrote:
>
> Hi
>
> R u using lotus notes or outlook for sending emails
>
> Regards
> Ashish
> Sent on my BlackBerry® from Vodafone
> --
> *From: * shraddha malvankar >
> *Sender: * excel-..
