Thanks a lot :-)
On Fri, Jul 1, 2011 at 6:06 PM, ashish koul wrote:
> try the attachment
>
>
> On Fri, Jul 1, 2011 at 3:50 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi,
>>
>> I need a formula which need to ignore weekends. Thanks
>>
>> For Ex:
>>
>> A1=01/07/2011 - Input
>
hi Asish sir,
Congrats...for this award...keep helping us like this
thanks
Best Regards,
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Sat, Jul 2, 2011 at 2:37 AM, Gyana Ranjan Das wrote:
> Hi Ashish,
>
hi rakesh
thnks for reply
this is not a simple vlookup formula case, i just want to get figure
by changing validation list..because calculation is having many
backhand formulas...
well... i want you tell that...this income tax calculation sheet
sample.the result which is showing is net inco
*Congratulations Ashish keep it uppp-- *
***
*
*-- *
*--
One Team One Dream One Goal
Warm Regards,
Brajesh Kumar Porwal
E-Mail :- brajeshkumarpor...@gmail.com
7503020750,
"We can't Spell S_ccess without U"
Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)
try this
select the folder in which files are saved
Function SelectFolder(Optional Title As String, Optional TopFolder _
As String) As String
Dim objShell As New Shell32.Shell
Dim objFolder As Shell32.Folder
Set objFolder = objShell.BrowseForFolder _
(0, Title, 1, TopFolder)
If Not objFolder Is
Congrats Ashish Ji..
You are really a MVP
--
--
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://
Thnaks you Pandeyji. ITs working fine
On Jun 29, 2:45 am, Dilip Pandey wrote:
> Hi Atul,
>
> You were clear in the first email itself. It is my mistake that I had
> overlooked the point.
> Now I have revised the macro and it should work fine.
>
> Feel free to get back in case of any queries. Th
First of all Congratulations Ashish Sir Ji for MVP Award. I already knew
that you'll definitely got this award. Thnx for your co operation & helps.
You solved our problems very well & gave us good knowledge of excel. I got
inspiration from you.
Last but not least I thank to Ayush Sir who has c
Hi,
I am using excel 2010. I have searched internet and have come up with
below codes to:
1- Open a folder
2- Loop through excel files and open them one by one.
3- Check existence of path in opened file (path is in the sheet called
"Path", cell B2 of opened file)
4- Give me a message if path does
Hallo,
i would like to convert a relative path in a HTML document like "../
images/image.jpg" to an absolute URL like
http://www.myserver.com/images/image.jpg
So far I have found the MakeAbs command :
http://msdn.microsoft.com/en-us/library/aa156144%28v=office.10%29.aspx.
Unfortunately there is
Congrats !!!
That's a very good news :D Keep up the good work Ashish
Warm regards,
Anand Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exce
Hi Ashish,
Congratulation for MVP award.Keep it up..!
*Thanks & Regards,*
*Gyana *
On Fri, Jul 1, 2011 at 9:25 PM, Ayush wrote:
> Dear Group,
> I am extremely happy to share a good news with you. One of our dearest
> group member 'Ashish Koul' is awarded Microsoft MVP award on 1st July
Hello,
Consider the NETWORKDAYS function. If you are using an older version than
Excel 2007, you’ll have to install the Analysis Tool Pack.
HTH
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Chandra Shekar
Envoyé : vendredi 1 juillet 201
Congratulation sir ji.for MVP award...
Please keep your helping process continue.
On Fri, Jul 1, 2011 at 10:20 PM, ashish koul wrote:
> Thank you all
>
>
> On Fri, Jul 1, 2011 at 9:36 PM, Venkatesan c wrote:
>
>> *Dear Asish,*
>> *
>> *
>> *Congrats...*
>> *
Hi Ashish
Heartiest Congratulations on your success ! Keep it up !
On Fri, Jul 1, 2011 at 10:20 PM, ashish koul wrote:
> Thank you all
>
>
> On Fri, Jul 1, 2011 at 9:36 PM, Venkatesan c wrote:
>
>> *Dear Asish,*
>> *
>> *
>> *Congrats...*
>> *
>> *
>> *Best Regards,*
>> *Venkat*
>> *
I think this is fabulous. Another Excel MVP. Ashish, your dedication
and capacity to help has been exemplary. Keep up the great work, and
hope this title continues.
Cheers, Sam
On Jul 1, 9:02 pm, Umesh Soni wrote:
> Congrats.. Ashish
>
>
>
>
>
>
>
>
>
> On Fri, Jul 1, 2011 at 4:55 PM
Thank you all
On Fri, Jul 1, 2011 at 9:36 PM, Venkatesan c wrote:
> *Dear Asish,*
> *
> *
> *Congrats...*
> *
> *
> *Best Regards,*
> *Venkat*
> *
> *
>
> On Fri, Jul 1, 2011 at 9:25 PM, Ayush wrote:
>
>> Dear Group,
>> I am extremely happy to share a good news with you. One of our dearest
*Dear Asish,*
*
*
*Congrats...*
*
*
*Best Regards,*
*Venkat*
*
*
On Fri, Jul 1, 2011 at 9:25 PM, Ayush wrote:
> Dear Group,
> I am extremely happy to share a good news with you. One of our dearest
> group member 'Ashish Koul' is awarded Microsoft MVP award on 1st July for
> his exceptional M
add this line after u import the data
Cells.Columns.EntireColumn.AutoFit
or
Cells.ColumnWidth = 20
On Fri, Jul 1, 2011 at 8:40 AM, Michael Hayes wrote:
>
>
> When I do web queries and create pivot tables in Excel 2007, I really
> dislike the automatic column width formattingthe columns ar
try the attachment
On Fri, Jul 1, 2011 at 3:50 PM, Chandra Shekar wrote:
> Hi,
>
> I need a formula which need to ignore weekends. Thanks
>
> For Ex:
>
> A1=01/07/2011 - Input
> B1=30/06/2011 - Result1
> C1=04/07/2011 - Result2 ' 02/07/2011 & 03/07/2011 are saturdays and
> sundays.
>
> --
>
> --
Please find the attached file.
Thanks,
Rakesh.
On Fri, Jul 1, 2011 at 5:49 PM, Markkim wrote:
> I'm not sure if I understand what you want correctly.
>
>
> O2 cell in your sample file
>
> you can have the following formula
>
> =VLOOKUP(M2,$A$1:$B$56,2,0) * VLOOKUP(M2,Sheet2!$A$1:$B$56,2,0)
>
> t
Congrats.. Ashish
On Fri, Jul 1, 2011 at 4:55 PM, Ayush wrote:
> Dear Group,
> I am extremely happy to share a good news with you. One of our dearest
> group member 'Ashish Koul' is awarded Microsoft MVP award on 1st July for
> his exceptional MS Excel skills and voluntary contributi
Heartiest congratulations Ashish . . !!
This is well deserved, keep the helping spirit high.
Best regards,
DILIPandey
On 7/1/11, Ayush wrote:
> Dear Group,
> I am extremely happy to share a good news with you. One of our dearest group
> member 'Ashish Koul' is awarded Microsoft MVP award on 1st
Dear Group,
I am extremely happy to share a good news with you. One of our dearest group
member 'Ashish Koul' is awarded Microsoft MVP award on 1st July for his
exceptional MS Excel skills and voluntary contribution.
He is well deserving for the award and I am very happy and proud of his
recogn
try thse video tutorial and websites
http://akoul.wordpress.com/2011/05/28/excel-video-tutorials/
http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-online/
On Fri, Jul 1, 2011 at 1:34 PM, kurikkal padinjarappalla <
padinjarappa...@gmail.com> wrote:
> please attach it
>
I'm not sure if I understand what you want correctly.
O2 cell in your sample file
you can have the following formula
=VLOOKUP(M2,$A$1:$B$56,2,0) * VLOOKUP(M2,Sheet2!$A$1:$B$56,2,0)
then do autofill ..
Is this what you want?
--
-
Hi,
I need a formula which need to ignore weekends. Thanks
For Ex:
A1=01/07/2011 - Input
B1=30/06/2011 - Result1
C1=04/07/2011 - Result2 ' 02/07/2011 & 03/07/2011 are saturdays and sundays.
--
--
Some important lin
Hi Modi,
Pls find the UDF for retreiving IP Address of your machine.
link
http://stackoverflow.com/questions/828496/how-to-retrieve-this-computers-ip-address
Function GetIPAddress()
Const strComputer As String = "." ' Computer name. Dot means local computer
Dim objWMIService, IPConfigSet, IPC
Dear Rakesh,
This code will help you get the desired result.
Sub ChangeAll()
Dim sh As Worksheet
Dim cl As Range
For Each sh In ActiveWorkbook.Worksheets
For Each cl In sh.UsedRange
If cl.Value < 0 Then
cl.Value = 0
End If
Next c
please attach it
On Fri, Jul 1, 2011 at 10:43 AM, ankur wrote:
> Dear friends
> I m agree that , the sites you all recommended are very useful ,but
> for a new user , the best way to learn VBA is getting a book dedicated
> on vba...becoz they provide step wise and detailed concepts
> there
sorry , i forget to attach a sample file in my query..
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Fri, Jul 1, 2011 at 5:14 PM, ankur wrote:
> hi ayush/ all members
>
> i have one data validation list, which is r
hi ayush/ all members
i have one data validation list, which is required in formula to get
a result i want the all results corresponding to each value in
different sheet or in different column in one click
any macro code is there ?
thanks in advance
Have A Nice Time & Enjoy Life
Regar
On 7/1/11, L.K. Modi wrote:
> Dear Group Members
>
>
> I need an excel file in wihch by running macro we can see our IP ADDRESS.
> Please provide me that file by which we can know the IP address of our
> System
>
>
> Regards
> LKModi
>
> --
> ---
Dear Group Members
I need an excel file in wihch by running macro we can see our IP ADDRESS.
Please provide me that file by which we can know the IP address of our
System
Regards
LKModi
--
--
Some important links
Dear friends
I m agree that , the sites you all recommended are very useful ,but
for a new user , the best way to learn VBA is getting a book dedicated
on vba...becoz they provide step wise and detailed concepts
there are many free ebooks on vba on the internet.download it
...learn basic f
hi Ayush/ other members
i need a very useful " open xl addin." i cant download it from
the site,.. link is not working properly over there..
urgent need
Have A Nice Time & Enjoy Life
Regards:,
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
--
---
36 matches
Mail list logo
