date:20110617

$$Excel-Macros$$ Re: need help in soting

2011-06-17 Thread airen

Members please Help..

-- 
--
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 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

$$Excel-Macros$$ Protect (lock) cells or cell ranges based on time elapsed

2011-06-17 Thread AyaNayzgi ZeWolqait

Hello,

I am trying to find out if there is a way of protecting or preventing
modification of excel cells after a predetermined deadline has
elapsed. For instance in cells A1:A20 a user is expected to input his/
her initials if a task is completed by certain deadline, let's say
2:00 PM. However, if the current time is past 2:00 PM the cell range
A1:A20 would automatically lock preventing the user from entering
their initials in this cell range. In stead they will be required to
input their initials in another range where it will be noted as being
late.

Is there a function or Macro that  an do this for me on the background
with little to no manual intervention?

Thanks for your help in advance.

-- 
--
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 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

Re: $$Excel-Macros$$ Pad zeros

2011-06-17 Thread Skanda

Thank you all.it works like a charm!!

On Fri, Jun 17, 2011 at 7:28 AM, Rakesh Joshi wrote:

> instead of using below formula you can use.
> this formula it will work in any cell and for any value.
> *=REPT(0,LEN(B4)+(2)-LEN(B4))&B4
>
> *
> On Fri, Jun 17, 2011 at 10:46 AM, Venkatesan c wrote:
>
>> Hi Skanda,
>>
>> Please use Below formula for our query.
>>  =REPT(0,(9-LEN(B4)))&B4
>>
>>  *Best Regards,*
>> *Venkat*
>>
>> On Fri, Jun 17, 2011 at 3:46 AM, Skanda wrote:
>>
>>> Hi,
>>>   How to add zeros in front of a value with varying lengths so that the
>>> length of the column is 9?
>>> for instance a column policy id has values with varying lengths as
>>> follows:
>>>
>>> Policyid:
>>>  745689
>>> 2346789
>>>
>>>
>>> so i need to transform the above policyid to:
>>> 000745689
>>> 002346789
>>>
>>>
>>> --
>>>
>>> --
>>> 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 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
>>>
>>
>>
>>
>> --
>> *Best Regards,*
>> *Venkat*
>>
>>
>> --
>>
>> --
>> 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 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
>>
>
>
>
> --
> Rakesh Joshi
>

-- 
--
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 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

Re: $$Excel-Macros$$ Recover delete file.

2011-06-17 Thread STDEV(i)

use  Recuva
Recuva recovers files deleted from your Windows computer, Recycle Bin,
digital camera card, or MP3 player. And it's free!

http://www.piriform.com/recuva
 

On Fri, Jun 17, 2011 at 12:26 PM, Bhushan Sabbani wrote:

> Dear Excel Expert,
>
> I was using the below code to delete the temp data file by mistake my
> personal which contain all the macro and the senstive data got delete i have
> serach in the recycle bin and whereever pls help me to find the file the
> file name was "personal.xls"
>
> Sub Killed()
> Application.DisplayAlerts=False
> ThisWorkbook.ChangeFileAccess xlReadOnly
> Kill ThisWorkbook.FullName
> ThisWorkbook.Close False
> End Sub
>
> Thanks in advance.
>
> Bhushan Sabbani.
>
>

-- 
--
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 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

RE: $$Excel-Macros$$ 2003 to 2007 : VBA Code

2011-06-17 Thread Daniel

Hi,

 

I don’t think there are tool to automate the processbecause the syntax is
very similar. Can you post your code and tell which line produces the error
?

 

Regards.

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Chandra Shekar
Envoyé : vendredi 17 juin 2011 10:13
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ 2003 to 2007 : VBA Code

 

Hi,

 

How to convert 2003 VBA code to 2007, because some of codes what I am
running in 2003 is not running in 2007. Is there any way to convert this to
any office to get the same result.

 

I am getting following error... Run-time error '-2147467259 (84005'):
The specified dimension is not valid for the current chart type. 

Thanks,

 

Chandra Shekar B

-- 

--
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 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 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 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

RE: $$Excel-Macros$$ querry 3

2011-06-17 Thread Daniel

See attached file.

 

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nemi Gandhi
Envoyé : vendredi 17 juin 2011 08:28
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ querry 3

 

attached once again for some correction and explanation for my knowledge.

-- 
Nemi Gandhi
98204 92963

-- 

--
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 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 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 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


QUERRY-3-2.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Time running out on FREE Index/Match, Vlookup downloads

2011-06-17 Thread Ayush

Dear members, 
 
I saw that you didn't go and check out FREE Index/Match and Vlookup Syntax 
Memory Cards  that was 
released last week.
 
You should really go download them because they have gotten 100% positive 
feedback AND *Monday is the LAST day* you will be able to have access to 
them.
 
Get your FREE lookup downloads 
here
 
There are ALSO 3 free videos that you should really watch as well. They show 
you the logic of these "confusing" lookup formulas and show you some simple 
ways to operate them with success.
 
Get the free content HERE 
 
You should probably note as well that on Tuesday, June 21st John will be 
releasing his brand new Lookup training course and DISCUSSEXCEL group 
members will get special discount to buy the same. Keep watching this space. 
:)
 
So go to the page and check out all of the content!
 
Best Regards,
Ayush Jain
Group Manager

-- 
--
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 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

$$Excel-Macros$$ Sorting option in Filter Disable-Shortcut Key.Excel 2007

2011-06-17 Thread saravanan R

Hi Excelates,

I need an Urgent help on disabling the Sort in the filter dropdown.
Is there a way to disable only the short cut key i.e only the letter s
& a in the Filter Drop down list.(available in the Excell 2007)

thanks & regards,
Saravanan

-- 
--
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 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

RE: $$Excel-Macros$$ querry 3

2011-06-17 Thread Daniel

See attached file.

 

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nemi Gandhi
Envoyé : vendredi 17 juin 2011 08:28
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ querry 3

 

attached once again for some correction and explanation for my knowledge.

-- 
Nemi Gandhi
98204 92963

-- 

--
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 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 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 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


QUERRY-3-2.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

RE: $$Excel-Macros$$ querry 3

2011-06-17 Thread Daniel

I have trouble understanding ; can you post which result is expected ?

 

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nemi Gandhi
Envoyé : vendredi 17 juin 2011 08:28
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ querry 3

 

attached once again for some correction and explanation for my knowledge.

-- 
Nemi Gandhi
98204 92963

-- 

--
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 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 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 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

Re: $$Excel-Macros$$ querry-3

2011-06-17 Thread Nemi Gandhi

Thank you Daniel, but still need some correction and explanation for
my knoledge.
Querry is posted once again.
Nemi Gandhi.

On Jun 16, 10:59 am, "Daniel"  wrote:
> See attached file.
>
> Regards.
>
> Daniel
>
> De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
> la part de Nemi Gandhi
> Envoyé : jeudi 16 juin 2011 13:02
> À : excel-macros@googlegroups.com
> Objet : $$Excel-Macros$$ querry-3
>
> Dear Members,
> i need the formula please..
>
> --
> Nemi Gandhi
> 98204 92963
>
> --
> 
> --
> 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 athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below 
> linkhttp://www.facebook.com/discussexcel
>
>  QUERRY-3.xlsx
> 16KViewDownload

-- 
--
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 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

Re: $$Excel-Macros$$ Pad zeros

2011-06-17 Thread Rakesh Joshi

instead of using below formula you can use.
this formula it will work in any cell and for any value.
*=REPT(0,LEN(B4)+(2)-LEN(B4))&B4

*
On Fri, Jun 17, 2011 at 10:46 AM, Venkatesan c wrote:

> Hi Skanda,
>
> Please use Below formula for our query.
>  =REPT(0,(9-LEN(B4)))&B4
>
>  *Best Regards,*
> *Venkat*
>
> On Fri, Jun 17, 2011 at 3:46 AM, Skanda wrote:
>
>> Hi,
>>   How to add zeros in front of a value with varying lengths so that the
>> length of the column is 9?
>> for instance a column policy id has values with varying lengths as
>> follows:
>>
>> Policyid:
>>  745689
>> 2346789
>>
>>
>> so i need to transform the above policyid to:
>> 000745689
>> 002346789
>>
>>
>> --
>>
>> --
>> 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 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
>>
>
>
>
> --
> *Best Regards,*
> *Venkat*
>
>
> --
>
> --
> 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 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
>



-- 
Rakesh Joshi

-- 
--
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 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

Re: $$Excel-Macros$$ excel query

2011-06-17 Thread sunny k

hi azeema

can you tell us in which format you want  the  output

On Wed, Jun 15, 2011 at 11:03 PM, Azeema Faizunnisa wrote:

> thanks everyone for offer of help. Here is the sample data.
>
> On Wed, Jun 15, 2011 at 1:31 AM, Venkatesan c 
> wrote:
> > Hi Azeema,
> > Send the sample data and some one will assist the query..
> > Best Regards,
> > Venkat..
> >
> >
> > On Wed, Jun 15, 2011 at 2:38 PM, Azeema Faizunnisa 
> wrote:
> >>
> >> I have a table in excel of # of employees by age, sex and category of
> >> employment. The ROWs have three diff categories by sex and the COLUMNS
> >> have age (5 10-year age groups). Each cell provides the number
> >> (frequency) of employee for a particular age group and job category
> >> and sex!! I would like to convert the this TABLE to a data format, ie,
> >> I want to have age categories, sex, employment category all in columns
> >> and also break down the frequency to a single case, ie each row for
> >> each employee...  Is there any way to do it in excel?
> >>
> >> thanks.
> >>
> >> azeema
> >>
> >> --
> >>
> >>
> --
> >> 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 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
> >
> >
> >
> > --
> > Best Regards,
> > Venkat
> > ) 91 99414 31925
> >
> > --
> >
> --
> > 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 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 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 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 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 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

RE: $$Excel-Macros$$ Formula to Calculate Hours Between Dates

2011-06-17 Thread Anil Bhange

Hi John,

Noorain reply is awesome but to give you other solution,

Format > Format cells > custom > instead of "hh:mm" put "hh.mm"
i.e. instead of  ":"  use "."

Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of NOORAIN ANSARI
Sent: Thursday, June 16, 2011 11:06 PM
To: excel-macros@googlegroups.com
Cc: John A. Smith
Subject: Re: $$Excel-Macros$$ Formula to Calculate Hours Between Dates

Dear John,

Please try it..

=IFERROR(ROUND(VALUE(HOUR(D18)+(MINUTE(D18)/60)),1),"")

--
Thanks & regards,
Noorain Ansari

On Thu, Jun 16, 2011 at 8:05 PM, John A. Smith 
mailto:johnasmit...@gmail.com>> wrote:
Dear Excel Teachers,

I need a formula to give me the decimal hours between two dates.  I have 
attached a sample.

Thanking you in advance for your on-going help and wisdom.

John
--
--
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 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 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 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 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 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

$$Excel-Macros$$ Recover delete file.

2011-06-17 Thread Bhushan Sabbani

Dear Excel Expert,

I was using the below code to delete the temp data file by mistake my 
personal which contain all the macro and the senstive data got delete i have 
serach in the recycle bin and whereever pls help me to find the file the 
file name was "personal.xls"

Sub Killed()
Application.DisplayAlerts=False
ThisWorkbook.ChangeFileAccess xlReadOnly
Kill ThisWorkbook.FullName
ThisWorkbook.Close False
End Sub

Thanks in advance.

Bhushan Sabbani.

-- 
--
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 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

$$Excel-Macros$$ Re: need help in soting

2011-06-17 Thread airen

let there is a table and i want to sort the records of this table
using some attribute say pin code. the above algo sort only pin
codes.. i want to sort records using coding only..

i don't want to use range().sort

-- 
--
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 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

$$Excel-Macros$$ 2003 to 2007 : VBA Code

2011-06-17 Thread Chandra Shekar

Hi,

How to convert 2003 VBA code to 2007, because some of codes what I am
running in 2003 is not running in 2007. Is there any way to convert this to
any office to get the same result.

I am getting following error... Run-time error '-2147467259 (84005'):
The specified dimension is not valid for the current chart type.
Thanks,

Chandra Shekar B

-- 
--
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 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

$$Excel-Macros$$ querry 3

2011-06-17 Thread Nemi Gandhi

attached once again for some correction and explanation for my knowledge.

-- 
Nemi Gandhi
98204 92963

-- 
--
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 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


QUERRY-3.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Re: Formula to Calculate Hours Between Dates

2011-06-17 Thread rpal

I suspect the following formula won't accomplish if what you need is
no of hrs between 2 dates (incl exact time)... it can only handle if
it is on the same date (day).

The formula for getting time difference between 2 days is rather
simple: (End date-begin date)*24

Just format the cell as 'numbers' (and not date format).

Let me know if this ws what you wanted or you need any other
clarification.
Regards
Rajesh Pal


On Jun 16, 10:35 am, "John A. Smith"  wrote:
> Dear Excel Teachers,
>
> I need a formula to give me the decimal hours between two dates.  I have
> attached a sample.
>
> Thanking you in advance for your on-going help and wisdom.
>
> John
>
>  Decimal Hours Between Two Dates.xlsx
> 12KViewDownload

-- 
--
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 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

Re: $$Excel-Macros$$ Beginer to Excel-VBA

2011-06-17 Thread Venkatesan c

On Fri, Jun 17, 2011 at 6:00 AM, Venkatesan c  wrote:

> Dear Hari,
>
> Just watch the below link video's you may get Some of basics in Excel  VBA
>
> http://www.teachmsoffice.com/list-of-tutorials.php?src=tegb
>
> Best Regards,
>
> Venkat
>
>
> On Thu, Jun 16, 2011 at 8:35 PM, Hari  wrote:
>
>>
>>  Dear Friends,
>>Can any one please help me in *"how to learn Excel-VBA"* through some
>> tutorial materials as i am CA Final student.
>>
>>
>> -
>> Yours,
>>
>> Hari.
>>
>> --
>>
>> --
>> 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 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
>>
>
>
>
> --
> *Best Regards,*
> *Venkat*
>
>
>


-- 
*Best Regards,*
*Venkat*

-- 
--
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 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

Re: $$Excel-Macros$$ Pad zeros

2011-06-17 Thread Venkatesan c

Hi Skanda,

Please use Below formula for our query.
 =REPT(0,(9-LEN(B4)))&B4

*Best Regards,*
*Venkat*

On Fri, Jun 17, 2011 at 3:46 AM, Skanda  wrote:

> Hi,
>   How to add zeros in front of a value with varying lengths so that the
> length of the column is 9?
> for instance a column policy id has values with varying lengths as follows:
>
>  Policyid:
>  745689
> 2346789
>
>
> so i need to transform the above policyid to:
> 000745689
> 002346789
>
>
> --
>
> --
> 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 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
>



-- 
*Best Regards,*
*Venkat*

-- 
--
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 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

$$Excel-Macros$$ Re: need help in soting

$$Excel-Macros$$ Protect (lock) cells or cell ranges based on time elapsed

Re: $$Excel-Macros$$ Pad zeros

Re: $$Excel-Macros$$ Recover delete file.

RE: $$Excel-Macros$$ 2003 to 2007 : VBA Code

RE: $$Excel-Macros$$ querry 3

$$Excel-Macros$$ Time running out on FREE Index/Match, Vlookup downloads

$$Excel-Macros$$ Sorting option in Filter Disable-Shortcut Key.Excel 2007

RE: $$Excel-Macros$$ querry 3

RE: $$Excel-Macros$$ querry 3

Re: $$Excel-Macros$$ querry-3

Re: $$Excel-Macros$$ Pad zeros

Re: $$Excel-Macros$$ excel query

RE: $$Excel-Macros$$ Formula to Calculate Hours Between Dates

$$Excel-Macros$$ Recover delete file.

$$Excel-Macros$$ Re: need help in soting

$$Excel-Macros$$ 2003 to 2007 : VBA Code

$$Excel-Macros$$ querry 3

$$Excel-Macros$$ Re: Formula to Calculate Hours Between Dates

Re: $$Excel-Macros$$ Beginer to Excel-VBA

Re: $$Excel-Macros$$ Pad zeros

21 matches

Site Navigation

Mail list logo

Footer information