for sharing the file… but file is not opening… it takes lot of time
> to open… and it shows the data is downloading from different sources
>
>
>
> Could you please help in this.
>
>
>
> Regards,Anil Bhange
>
> IP Phone - 512320 | Mobile - 90290 32123
>
>
&g
com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Ju
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
*Reg
w.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><
On Sat, Apr 2, 2011 at 6:54 PM, Ayush Jain wrote:
>>
>>> Hello Everyone,
>>>
>>> Ashish Koul has been selected as 'Most Helpful Member' for the month of
>>> March'11
>>> He has posted 48 posts in March 2011 and helped many people thr
ickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><&
ttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><>&
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.faceboo
.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this gr
ease help me out.
>
> Thanx in Advance .
>
>
> Regards
> Harkesh
>
--
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com <http://akoul.blogspot.com/>
*akoul*.wordpress.com <http://akoul.wordpress.com/>
My Linkedin Profile <http://in.linkedin.com/pub/ashish-ko
de some help to do macros in outlook also
>
>
>
> On Thu, Apr 7, 2011 at 11:07 AM, C.G.Kumar wrote:
>
>> Its awesome.Hats off to Ashish.
>> Regards,
>> C.G.Kumar
>>
>>
>> On Thu, Apr 7, 2011 at 10:35 AM, ashish koul wrote:
>>
>>> try t
To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.
ogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><&g
t;
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
*R
post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
&
$M:$M,$P6,$F:$F,$O6,$D:$D,Q$5)
>
>
>
> Regards,
>
> Dhananjay
>
> On Sat, Apr 9, 2011 at 4:07 PM, ashish koul wrote:
>
>> see if it helps
>>
>>
>> On Fri, Apr 8, 2011 at 7:04 PM, Nemi Gandhi
--
> 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://www.linkedin.com/groups?gid=1871310
>
;><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
*Regards*
* *
*Ashi
t;<><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/disc
lt;><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
*Regards
http://code.google.com/p/openexcel/downloads/detail?name=OPEN_XL.zip&can=2&q
=
On Fri, Apr 15, 2011 at 10:26 AM, ashish koul wrote:
> try this
>
> =SUBSTITUTE(B3,".","-")-SUBSTITUTE(A3,".","-")
>
> On Fri, Apr 15, 2011 at 8:34 AM,
t; 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><>&
g the layout as yours layout. But my pivot
> is little bit complicated.Why is that so happening?. Why did you use
> employee code in data instead of count of poor or count of avg etc.? I am
> sending you the attachment.
>
> Regards,
> Alisha
>
>
> On Fri, Apr 15, 2011 at 1
spot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><&
acros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><>
il to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.fac
ros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discu
;><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/d
> 2. Secondly it should display only those 4 rows in the result. Like if we
> are using a sort function.
>
>
> Regards,
>
> C.G.Kumar
>
--
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com <http://akoul.blogspot.com/>
*akoul*.wordpress.com <http://akoul.wordpr
tip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on faceb
On Tue, Apr 19, 2011 at 11:12 AM, C.G.Kumar wrote:
> Thnaks Ashish.
>
> It is very useful but i am not getting desired output when i copy VBA code
> to my actual workbook.Please suggest Where i have to make change.
>
> Regards,
>
> C.G.Kumar
>
>
>
> On Mon, Apr 18, 2011 at 6
lt;><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.c
t.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><>
<><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
*Regards*
* *
*As
://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><
book.com/discussexcel
> >
> > --
> >
> ------
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailyti
lt;><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on T
;><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
*Regards*
* *
;><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.c
BA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><&
"*Eng In out Report*" button.
> Please see attached sheet..
>
> Thanks in Advance
>
> --
> Thanks & regards,
> Noorain Ansari
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>
>
--
*Regards*
* *
*Ashish Koul*
*
link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Regards
> Muni
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks a
ricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
&
w
If CDate(Sheets("SMPS").Cells(j, 2).Value) <= DateSerial(Year(Now),
Month(Now), Day(Now)) Then
SWA3 = SWA3 & vbNewLine & Sheets("SMPS").Cells(j, 1).Value
End If
Next j
MsgBox "UPS" & ":-" & vbNewLine & SWA1 & vbNewLine & "---
ttp://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><>&
n.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
&
/exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like ou
groups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexce
> Hope I had made it clear.
>
>
>
> On Wed, May 4, 2011 at 9:57 PM, ashish koul wrote:
>
>> can you expaln with some example in workbook
>>
>>
>> On Tue, May 3, 2011 at 8:30 PM, keechak wrote:
>>
>>> Hi forum,
>>>
>>> Tha
/www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><&
Range("a65356").End(xlUp).Offset(1, 0).Select
ActiveSheet.Paste
s.Save
s.Close
Application.ScreenUpdating = True
End Sub
select the master file when it asks for workbook
On Thu, May 5, 2011 at 9:14 PM, ashish koul wrote:
> hi
> save all your daily files in a single folder
>
>
try this one
On Thu, May 5, 2011 at 9:11 PM, ashish koul wrote:
> see if it helps
>
>
> On Thu, May 5, 2011 at 7:23 AM, Mr excel wrote:
>
>> For example,
>> The billing cycle for supplier A is 5th of this month to 4th next
>> so all the transactions pertaini
spot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><>&l
To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow bel
p://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><&g
send email to excel-macros@googlegroups.com
and add the attachment
On Fri, May 6, 2011 at 4:24 PM, Bob wrote:
> Were is it located to attach file? Sorry I don't see it. Thanks
>
> On May 6, 1:25 am, ashish koul wrote:
> > can you share the sample file
> >
> &g
cks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
+91 9158998701
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.co
oup, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
>
t in the month
> column of the sheet.Name of the month should be printed like April'2011
> instead of *05-Apr-2011 TO 04-May-2011*.
>
> the above formula also is very helpful to me in another scenario..
>
> Really my joy knew no boundaries..
>
>
> On Fri, Ma
ip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on
;<><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
*Regards*
* *
ogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><>
;<><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
*Regards*
* *
*Ashish
:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
&g
t; To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just fol
p.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on faceboo
d type), in that
> situation what is the formula?
>
> please reply
>
> Thanks & Regds
>
> ROHAN
>
>
> On Tue, May 10, 2011 at 5:16 PM, ashish koul wrote:
>
>>
><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.c
betically), something like this:
> > more...
> >
> > Topic: .Refresh Background:-False
> >
> > Sobavia May 11 01:09AM -0500 ^
> >
> > Thanks Ashish. It helped
> >
> > Sent from my iPhone
> >
> > more...
> >
&g
--
> 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://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA
dailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our pa
//www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><&g
www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><>
RTMENT OPP.AMAR~APARTMENT OPERA SOCI., nava vikas road,
> PALDI ahm 380007
>
>
>
> # 27/161, Pragatinagar~Naranpura ahm 380013
>
>
>
> jp nagar 6 th phase near sindoora kalyana mantap sarakki signal
> Bangalore-560078
>
>
>
> THE FOYER HOUSE NO.52, 2ND CRSS HU
Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><>
gt; B in Sheet 2 (next to "termination").
> ===
>
> Is it possible for you to add this functionality?
>
> On May 13, 4:26 pm, ashish koul wrote:
> > try this code
> >
> > Sub tests()
use move to move files and copy to copy the files
Public f As Object, d As Object
Sub Main()
Dim Fso As Object
Set Fso = CreateObject("Scripting.FileSystemObject")
Set RootFolder = Fso.GetFolder("C:\Documents and
Settings\ashish\Desktop\ashish koul")
Folde
use this one
Public f As Object, d As Object, sw As Object
Sub Main()
Dim Fso As Object
Set sw = CreateObject("Scripting.FileSystemObject")
Set Fso = CreateObject("Scripting.FileSystemObject")
Set RootFolder = Fso.GetFolder("C:\Documents and
Settings\a
t;
>> what i meant is instead of the period,the formula is showing as a result
>> the formula should return only the month with the year.
>> For example,*05-Apr-2011 TO 04-May-2011*.
>> should return apr'2011.
>>
>> hope this is not confusing you...ashish
;><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
*Regards*
* *
*Ashish Koul*
*akoul*.*blogs
egroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
t; --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2.
d Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><
n VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><>
send email to excel-macros@googlegroups.com and attach your workbook
On Mon, May 16, 2011 at 12:08 PM, sagaraher wrote:
> How to upload a excel file??..kindly help
>
> On May 13, 7:29 pm, ashish koul wrote:
> > can you attach the sample sheet
> >
> >
> >
&g
& AVG for first record should be 100, 50 & avergage should be 87.5.
>
> Can we use sumproduct for all the formulas instead of array formulas.
> Thanks in advanc.
>
> Regards,
>
> Chandra Shekar B
>
> On Mon, May 16, 2011 at 9:15 PM, ashish koul wrote:
>
>>
email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> ht
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><
Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><
t http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><>&l
earn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><>
<><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
> --
>
> --
> Some important links for excel
om/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
>
me 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://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macr
on..
>
> Please help me
>
> On Tue, May 17, 2011 at 10:00 PM, ashish koul wrote:
>
>> http://akoul.blogspot.com/search?q=protect
>>
>>
>> Private Sub Worksheet_Change(ByVal Target As Range)
>>
>> If Target.Column = 3 Then
>>
>> &
at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><&g
ot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our p
edin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
301 - 400 of 1436 matches
Mail list logo