date:20101230

Re: $$Excel-Macros$$ Re: How to lock cell based on condition

2010-12-30 Thread ashish koul

b is column no 2
g is column no 7

target.row will select the row



On Thu, Dec 30, 2010 at 1:39 PM, ashish koul  wrote:

>  **Private Sub Worksheet_Change(ByVal Target As Range)
> If Target.Column = 1 Then
>
> 'target.column =3 because column c is no 3 column
>
> 'you can change password ashish and choose your own
>
>
>
> ActiveSheet.Unprotect Password:="ashish"
> If Not IsEmpty(Target.Value) And Target.Value = "Yes" Then
>
> Cells(Target.Row, 2).Locked = True
>
>Cells(Target.Row, 7).Locked = True
>
> End If
> ActiveSheet.Protect Password:="ashish"
> Else: End If
> End Sub
>
>
>   On Thu, Dec 30, 2010 at 12:42 PM, Manish wrote:
>
>> Thanks Ashish,
>>
>> This is perfect as i want.
>> I need some more help, If i want to lock only column B to G (not want
>> to lock entire row) than what will the code.
>> I want to understand the diff in codes. :)
>>
>> Thanks once again for your help.
>>
>> Regds,
>> Manish
>>
>> On Dec 30, 10:31 am, ashish koul  wrote:
>> > Private Sub Worksheet_Change(ByVal Target As Range)
>> > If Target.Column = 1 Then
>> >
>> > 'target.column =3 because column c is no 3 column
>> >
>> > 'you can change password ashish and choose your own
>> >
>> > ActiveSheet.Unprotect Password:="ashish"
>> > If Not IsEmpty(Target.Value) And Target.Value = "Yes" Then
>> >
>> > Rows(Target.Row & ":" & Target.Row).Select
>> > Selection.Locked = True
>> > End If
>> > ActiveSheet.Protect Password:="ashish"
>> > Else: End If
>> > End Sub
>> >
>> > check this
>> >
>> > http://akoul.blogspot.com/2010/06/lock-cell-after-data-entry-from-edi.
>> ..
>> >
>> >
>> >
>> >
>> >
>> > On Thu, Dec 30, 2010 at 10:38 AM, Manish 
>> wrote:
>> > > Any help/suggestion ???
>> >
>> > > Thanks,
>> > > Manish
>> >
>> > > On Dec 29, 3:03 pm, Manish Pansari  wrote:
>> > > > Dear EE,
>> >
>> > > > Is it possible to lock the entire row/selected cell based on
>> condition
>> > > > in particular Cell.
>> > > > for example, I want to lock the row based on value in column A. If
>> > > > macro found value "yes" in cell A1 & A5, Macro will lock the row 1 &
>> > > > row 5.
>> >
>> > > > I hope its possible in macro. Pls suggest me the code.
>> >
>> > > > Thnxs,
>> > > > Manish
>> >
>> > > --
>> >
>> > >
>> ------
>> > > 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 link
>> > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;.
>> ..
>> >
>> > --
>> > *Regards*
>> > * *
>> > *Ashish Koul*
>> > *akoul*.*blogspot*.com 
>> > *akoul*.wordpress.com 
>> > My Linkedin Profile 
>> >
>> > P Before printing, think about the environment.
>> >
>> >  testlock.xls
>> > 45KViewDownload- Hide quoted text -
>> >
>> > - Show quoted text -
>>
>> --
>>
>> --
>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>
> --
>  *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
>  *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
>


-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

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

Re: $$Excel-Macros$$ Re: How to lock cell based on condition

2010-12-30 Thread ashish koul

**Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then

'target.column =3 because column c is no 3 column

'you can change password ashish and choose your own



ActiveSheet.Unprotect Password:="ashish"
If Not IsEmpty(Target.Value) And Target.Value = "Yes" Then

Cells(Target.Row, 2).Locked = True

   Cells(Target.Row, 7).Locked = True

End If
ActiveSheet.Protect Password:="ashish"
Else: End If
End Sub


On Thu, Dec 30, 2010 at 12:42 PM, Manish  wrote:

> Thanks Ashish,
>
> This is perfect as i want.
> I need some more help, If i want to lock only column B to G (not want
> to lock entire row) than what will the code.
> I want to understand the diff in codes. :)
>
> Thanks once again for your help.
>
> Regds,
> Manish
>
> On Dec 30, 10:31 am, ashish koul  wrote:
> > Private Sub Worksheet_Change(ByVal Target As Range)
> > If Target.Column = 1 Then
> >
> > 'target.column =3 because column c is no 3 column
> >
> > 'you can change password ashish and choose your own
> >
> > ActiveSheet.Unprotect Password:="ashish"
> > If Not IsEmpty(Target.Value) And Target.Value = "Yes" Then
> >
> > Rows(Target.Row & ":" & Target.Row).Select
> > Selection.Locked = True
> > End If
> > ActiveSheet.Protect Password:="ashish"
> > Else: End If
> > End Sub
> >
> > check this
> >
> > http://akoul.blogspot.com/2010/06/lock-cell-after-data-entry-from-edi...
> >
> >
> >
> >
> >
> > On Thu, Dec 30, 2010 at 10:38 AM, Manish 
> wrote:
> > > Any help/suggestion ???
> >
> > > Thanks,
> > > Manish
> >
> > > On Dec 29, 3:03 pm, Manish Pansari  wrote:
> > > > Dear EE,
> >
> > > > Is it possible to lock the entire row/selected cell based on
> condition
> > > > in particular Cell.
> > > > for example, I want to lock the row based on value in column A. If
> > > > macro found value "yes" in cell A1 & A5, Macro will lock the row 1 &
> > > > row 5.
> >
> > > > I hope its possible in macro. Pls suggest me the code.
> >
> > > > Thnxs,
> > > > Manish
> >
> > > --
> >
> > >
> ------
> > > 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 link
> > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;.
> ..
> >
> > --
> > *Regards*
> > * *
> > *Ashish Koul*
> > *akoul*.*blogspot*.com 
> > *akoul*.wordpress.com 
> > My Linkedin Profile 
> >
> > P Before printing, think about the environment.
> >
> >  testlock.xls
> > 45KViewDownload- Hide quoted text -
> >
> > - Show quoted text -
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ How to hide/filter rows?

2010-12-30 Thread Walter Moser

Hello Daniel,

right now I'm using Excel 2003.
An example or a detailed explanation would be highly appreciated. (So
far, I used excel only as a spreadsheet viewer - so please be very
detailed).
Thank you.

On Dec 29, 8:31 pm, "Daniel"  wrote:
> Hello,
> Consider pivot table. I may post a sample file. Just tell what your Excel
> version is.
> Regards.
> Daniel
>
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
> la part de Walter Moser
> Envoyé : mardi 28 décembre 2010 17:04
> À : MS EXCEL AND VBA MACROS
> Objet : $$Excel-Macros$$ How to hide/filter rows?
>
> Hello,
>
> so i have this 1+ rows excel sheet. Each row containins a name and a
> price - each in its own column. A name may appear various times.
>
> How can i filter the rows in order to display only one row for a given name.
> The one row i'd like to display is the one with the highest price.
> How can this be done in excel?
>
> Thanks,
> W.
>
> --
> 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip2. 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.com5. 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/pages/discussexcelcom/160307843985936?v=wall&;...

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Re: How to lock cell based on condition

2010-12-30 Thread Manish

Thanks once again.. :) concept clear..
Again need more value addition...

this code is working fine. I am not be able to insert the row,
once macro protect the sheet. I want only insert the row, even after
the protection of the worksheet

Pls suggest

Thanks boss

Regds,
Manish

On Dec 30, 1:10 pm, ashish koul  wrote:
> b is column no 2
> g is column no 7
>
> target.row will select the row
>
>
>
>
>
> On Thu, Dec 30, 2010 at 1:39 PM, ashish koul  wrote:
> >  **Private Sub Worksheet_Change(ByVal Target As Range)
> > If Target.Column = 1 Then
>
> > 'target.column =3 because column c is no 3 column
>
> > 'you can change password ashish and choose your own
>
> > ActiveSheet.Unprotect Password:="ashish"
> > If Not IsEmpty(Target.Value) And Target.Value = "Yes" Then
>
> > Cells(Target.Row, 2).Locked = True
>
> >    Cells(Target.Row, 7).Locked = True
>
> > End If
> > ActiveSheet.Protect Password:="ashish"
> > Else: End If
> > End Sub
>
> >   On Thu, Dec 30, 2010 at 12:42 PM, Manish wrote:
>
> >> Thanks Ashish,
>
> >> This is perfect as i want.
> >> I need some more help, If i want to lock only column B to G (not want
> >> to lock entire row) than what will the code.
> >> I want to understand the diff in codes. :)
>
> >> Thanks once again for your help.
>
> >> Regds,
> >> Manish
>
> >> On Dec 30, 10:31 am, ashish koul  wrote:
> >> > Private Sub Worksheet_Change(ByVal Target As Range)
> >> > If Target.Column = 1 Then
>
> >> > 'target.column =3 because column c is no 3 column
>
> >> > 'you can change password ashish and choose your own
>
> >> > ActiveSheet.Unprotect Password:="ashish"
> >> > If Not IsEmpty(Target.Value) And Target.Value = "Yes" Then
>
> >> > Rows(Target.Row & ":" & Target.Row).Select
> >> >     Selection.Locked = True
> >> > End If
> >> > ActiveSheet.Protect Password:="ashish"
> >> > Else: End If
> >> > End Sub
>
> >> > check this
>
> >> >http://akoul.blogspot.com/2010/06/lock-cell-after-data-entry-from-edi.
> >> ..
>
> >> > On Thu, Dec 30, 2010 at 10:38 AM, Manish 
> >> wrote:
> >> > > Any help/suggestion ???
>
> >> > > Thanks,
> >> > > Manish
>
> >> > > On Dec 29, 3:03 pm, Manish Pansari  wrote:
> >> > > > Dear EE,
>
> >> > > > Is it possible to lock the entire row/selected cell based on
> >> condition
> >> > > > in particular Cell.
> >> > > > for example, I want to lock the row based on value in column A. If
> >> > > > macro found value "yes" in cell A1 & A5, Macro will lock the row 1 &
> >> > > > row 5.
>
> >> > > > I hope its possible in macro. Pls suggest me the code.
>
> >> > > > Thnxs,
> >> > > > Manish
>
> >> > > --
>
> >> ------
> >> > > 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 link
> >> > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;.
> >> ..
>
> >> > --
> >> > *Regards*
> >> > * *
> >> > *Ashish Koul*
> >> > *akoul*.*blogspot*.com 
> >> > *akoul*.wordpress.com 
> >> > My Linkedin Profile 
>
> >> > P Before printing, think about the environment.
>
> >> >  testlock.xls
> >> > 45KViewDownload- Hide quoted text -
>
> >> > - Show quoted text -
>
> >> --
>
> >> ------
> >> 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 link
>
> >>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;...
>
> > --
> >  *Regards*
> > * *
> > *Ashish Koul*
> > *akoul*.*blogspot*.com 
> >  *akoul*.wordpress.com 
> > My Linkedin Profile 
>
> > P Before printing, think about the environment.
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com

Re: $$Excel-Macros$$ Re: How to lock cell based on condition

2010-12-30 Thread Manish

Again, unless i will not enable the macro, i can change in the locked
cell :(  :(

How can I enable the macro automatically, if the user open the xl
file. I hope my requirement is clear and hope such option is available
in VBA.

Regds,
Manish

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ How to learn VBA Languages and Macros

2010-12-30 Thread B Sharma

Dear Friends,
Firstly I want to thank you all for making and using this wonderful
educational site. Its really superb.

I am somewhat good in excel inbuilt formulas & functions and able to
complete most of my work through that.

But I need your help as I want to learn VBA programming & Macros and
want to automate my working.

Please suggest me the way, I want to know how to write programs
starting with some small programs in a easy language along with the
meaning /definition of objects, array, classes, etc.
How to write programmes.

Along with this I will appreciate if peoples send me their working
files, learning books, etc. through which I can learn programmes, etc.

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Description while using Macro Functions in Excel

2010-12-30 Thread Raj Mahapatra

hi Group,

i want to show description of the Function while using the same in Excel
like below screen shot.


e.g while using if function in excel it displays like

=if(logical_test, value_if_true, value_if_false)

thanks

Rajesh Mahapatra

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Nested IF functions?

2010-12-30 Thread prabhakar thakur

Dear Group,

May I know how much time use nested if in loop of function??

Thanks,
Prabhakar Thakur
New Delhi
+919953736776



On Thu, Dec 30, 2010 at 8:24 AM, J D  wrote:

> Thanks, got it to work finally.
>
> On Dec 29, 3:51 am, Dave Bonallack  wrote:
> > Hi,
> > To just do the 3 levels you asked about, try:
> > =IF(B16<500,3.5,IF(B16<1000,2.75,2.25))
> > Regards - Dave.
> >
> > Date: Tue, 28 Dec 2010 20:18:30 +0530
> > Subject: Re: $$Excel-Macros$$ Nested IF functions?
> > From: dilipan...@gmail.com
> > To: excel-macros@googlegroups.com
> >
> > Hi J D,
> > á
> > It would be really appreciable if you can share a test file on this.á
> Help us to help you :)
> > á
> > Best Regards,
> > DILIPandey
> >
>  > On Tue, Dec 28, 2010 at 7:36 AM, J D  wrote:
> >
> > I am a concrete estimator who is trying to create some cut and paste
> > Estimate line items I can just grab from one spread sheet and paste in
> > to my estimate.
> >
> > I was refining one and tried to use the IF function to pick the number
> > of labor hours based on sq footage. áMore s.f. and we are more
> > productive therefore less hours per s.f.
> >
> > I was trying to say if less that 500 s.f. then .035 hrs/s.f. á500 to
> > 1,000 then .0275 hrs/s.f. >1,000 s.f. then .0225 hours/s.f.
> >
> > I could get one working but wanted to know how to get more going
> > choises out of one formula. áAttached is the assembly and the formula
> > below it.
> >
> > Form, place and finish ~ (__) s.f. of 4" broom swept finish concrete
> > sidewalk. áConcrete to be 3,500 psi and reinforced with 6 x 6 , w1.4/
> > w1.4 wwf. á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á
> á á á $4,410.00
> > á á á áArea á á990 á á s.f. á áPerimeter á á á 114 á á l.f.
> > Concrete á á á á990 á á 0.33 á á1.03 á á336.501 12.463 á13 á á á145 á á
> 1885
> > Labor á 13 á á á0.4 á á 5.2 á á á á á á á á á á 5.2 á á 40 á á á208
> > wwf á á 990 á á 40 á á á24.75 á á á á á á á á á 25 á á á7 á á á 175
> > 2" SB á 990 á á 0.26 á á257.4 á á á á á á á á á 260 á á 0.49 á á127.4
> > Labor á 990 á á 0.003 á 2.97 á á á á á á á á á á3 á á á 40 á á á120
> > Poly á á990 á á 1800 á á0.55 á á á á á á á á á á0.6 á á 85 á á á51
> > Labor á 990 á á 0.002 á 1.98 á á á á á á á á á á2 á á á 40 á á á80
> > Expansion á á á 990 á á 0.25 á á247.5 á 100 á á 2.475 á 2.5 á á 31.64 á
> 79.1
> > Labor á 250 á á 0.01 á á2.5 á á á á á á á á á á 2.5 á á 40 á á á100
> > Curing á640 á á 350 á á 1.828571429 á á 5 á á á 0.365714286 á á 0.4 á á
> 55 á á á22
> > Labor á 990 á á 0.003 á 2.97 á á á á á á á á á á3 á á á 40 á á á120
> > 2 x 4 á 114 á á 16 á á á7.125 á á á á á á á á á 8 á á á 5.81 á á46.48
> > Labor á 114 á á 0.33 á á37.62 á 0.2 á á 7.524 á 7.6 á á 40 á á á304
> > Finish á990 á á 100 á á 9.9 á á 2.75 á á27.225 á27.3 á á40 á á á1092
> >
> > á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á4409.98
> > =IF(B16<500,3.5,2.75)
> >
> > --
> >
> ------
> > 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/pages/discussexcelcom/160307843985936?v=wall&...
> >
> > --
> > Thanks & Regards,
> >
> > DILIP KUMAR PANDEYá
> > á MBA-HR,B.Com(Hons),BCA
> > Mobile: +91 9810929744
> > dilipan...@gmail.com
> > dilipan...@yahoo.com
> > New Delhi - 62, India
> >
> > --
> >
> ------
> > 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/pages/discussexcelcom/160307843985936?v=wall&...
>
> --
>
> --
> 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.blogsp

$$Excel-Macros$$ Trying to calculate Number of Days to Deplete Inventory Stock for a Number of Stores

2010-12-30 Thread Ronald Cayne

I am performing a descending balance in column B,C,D. up to 100
Stores.  that incorporates number of days to arrive at that point
based on some calculation. If the outstanding balance is less than 1
then I require the number of days to arrive at that point. in Column C
to so indicated in Row 5 of that column.


The calculation is quite complicated but their must be some
suggestions as to the statement I should include that will give me the
number of days

Here are more details

I huave a series of stores with different Inventory Levels on hand.
I know the average daily sales for each store. If I assume that I can
meet the daily sales or a multiple thereof. How many days will it take
to run through the Inventory for each store.


Hope this is not as clear as MUD!

Help would be greatly appreciated

Regards

Ronald Cayne
r...@ronca.ca or ronca...@gmail.com

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Trying to calculate Number of Days to Deplete Inventory Stock for a Number of Stores

2010-12-30 Thread Ronald Cayne

There is more to the story. I apply discounts accross the board to all
the stores. I may have no discount for 5 days. Then I might run the
program at 40% off for 10 days, 50% off for x days
^0 % off for X days etc.

On 12/30/10, Ronald Cayne  wrote:
> I am performing a descending balance in column B,C,D. up to 100
> Stores.  that incorporates number of days to arrive at that point
> based on some calculation. If the outstanding balance is less than 1
> then I require the number of days to arrive at that point. in Column C
> to so indicated in Row 5 of that column.
>
>
> The calculation is quite complicated but their must be some
> suggestions as to the statement I should include that will give me the
> number of days
>
> Here are more details
>
> I huave a series of stores with different Inventory Levels on hand.
> I know the average daily sales for each store. If I assume that I can
> meet the daily sales or a multiple thereof. How many days will it take
> to run through the Inventory for each store.
>
>
> Hope this is not as clear as MUD!
>
> Help would be greatly appreciated
>
> Regards
>
> Ronald Cayne
> r...@ronca.ca or ronca...@gmail.com
>
> --
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ How to use a drop down list to select data from another sheet

2010-12-30 Thread Steve

Each month I must compare monthly expenses to the budget (forecast).
To do this I have created a spreadsheet with a drop down list where
the user selects the appropriate month to analyze. I would then like
the data to be pulled in from another tab using the appropriate column
based on the month selected. However, I am having trouble doing this
via the lookup function and ask for your help. I have uploaded the
spreadsheet "Copy of Actual vs Forecast FY11.xls".

Any help or advice offered will be appreciated.

Thank you!

Steve Weaver

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

RE: $$Excel-Macros$$ How to learn VBA Languages and Macros

2010-12-30 Thread Susan

I use Excel 2007 Visual Basic for Applications, Step by Step.  This book was
extremely helpful to me as I am a new in learning VB and wanted to write
more extensive macros. 

Susan

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of B Sharma
Sent: Thursday, December 30, 2010 3:13 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ How to learn VBA Languages and Macros

Dear Friends,
Firstly I want to thank you all for making and using this wonderful
educational site. Its really superb.

I am somewhat good in excel inbuilt formulas & functions and able to
complete most of my work through that.

But I need your help as I want to learn VBA programming & Macros and
want to automate my working.

Please suggest me the way, I want to know how to write programs
starting with some small programs in a easy language along with the
meaning /definition of objects, array, classes, etc.
How to write programmes.

Along with this I will appreciate if peoples send me their working
files, learning books, etc. through which I can learn programmes, etc.

-- 

--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Hyperlink Funcitonality

2010-12-30 Thread busboy10

HI All,

Trying to figure out how to get the reference cell that I am
hyperlinking to within a sheet, to be aligned to the top left of the
window.

I have tried this with no luck
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Application.Goto reference:=ActiveCell, scroll:=True
End Sub

Any thoughts?

Thanks!

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Re: How to lock cell based on condition

2010-12-30 Thread ashish koul

hi manish


check this link you can hide all the sheets and make user to click on
 enable macro to make that sheet visible.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=379


to insert row write in code to to unprotect sheet and then protect it again.




On Thu, Dec 30, 2010 at 4:25 PM, Manish  wrote:

> Again, unless i will not enable the macro, i can change in the locked
> cell :(  :(
>
> How can I enable the macro automatically, if the user open the xl
> file. I hope my requirement is clear and hope such option is available
> in VBA.
>
> Regds,
> Manish
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Wishing you all Very happy and prosperous New Year

2010-12-30 Thread ashish koul

*Wishing you all Very happy and prosperous New Year*


-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$

2010-12-30 Thread Jai

*Wishing you all Very happy and prosperous New Year*

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Wishing you all Very happy and prosperous New Year

2010-12-30 Thread rathi rupenzala

Hi All,


I am new macros and VBA , I have test session on VBA , Macros , excel ,
access and sql.

Could you please advice me on the links to which I can refer and learn
basics.


With Regards
Rathi

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Change / Arrange no. of order of Sheets - Help

2010-12-30 Thread Rohan Young

Hi Experts,

Gud morng & wishing u all a very HAPPY NEW YEAR 2011

I hv a question, can we change / arrange the order of Sheets in excel.

e.g. : i hv a file which has many of sheets & i want to take print of all
sheets with the page nos. but the problem is all the sheets are arranged in
descending order (from left to right : Sheet 10, Sheet 9, Sheet
8...) but i want printouts from the sheet 1 with the page no. 1
on sheet 1, if i give page nos. on these sheets excel will count the page
no. 1 on sheet 10, how can i arrange or change the order of sheets (if there
is so many sheets)?

any ideas/thought/function/command on this please share

thanks

ROHAN
9818247278, 8860567680

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Wishing you all Very happy and prosperous New Year

2010-12-30 Thread ashish koul

 Excel tutorials at http://www.excel-macros.blogspot.com
 Learn VBA Macros at http://www.quickvba.blogspot.com
 Excel Tips and Tricks at http://exceldailytip.blogspot.com
 www.mrexcel.com
www.contextures.com
http://msdn.microsoft.com/en-us/library/bb149081(v=office.12).aspx
www.techonthenet.com/excel/formulas/index.php
www.cpearson.com
http://www.functionx.com/vbaexcel/Lesson02.htm
http://www.functionx.com/vbaexcel/Lesson02.htm
www.*w3schools*.com/sql/default.asp

On Fri, Dec 31, 2010 at 10:54 AM, rathi rupenzala  wrote:

>
> Hi All,
>
>
> I am new macros and VBA , I have test session on VBA , Macros , excel ,
> access and sql.
>
> Could you please advice me on the links to which I can refer and learn
> basics.
>
>
> With Regards
> Rathi
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Re: How to lock cell based on condition

Re: $$Excel-Macros$$ Re: How to lock cell based on condition

Re: $$Excel-Macros$$ How to hide/filter rows?

Re: $$Excel-Macros$$ Re: How to lock cell based on condition

Re: $$Excel-Macros$$ Re: How to lock cell based on condition

$$Excel-Macros$$ How to learn VBA Languages and Macros

$$Excel-Macros$$ Description while using Macro Functions in Excel

Re: $$Excel-Macros$$ Nested IF functions?

$$Excel-Macros$$ Trying to calculate Number of Days to Deplete Inventory Stock for a Number of Stores

Re: $$Excel-Macros$$ Trying to calculate Number of Days to Deplete Inventory Stock for a Number of Stores

$$Excel-Macros$$ How to use a drop down list to select data from another sheet

RE: $$Excel-Macros$$ How to learn VBA Languages and Macros

$$Excel-Macros$$ Hyperlink Funcitonality

Re: $$Excel-Macros$$ Re: How to lock cell based on condition

$$Excel-Macros$$ Wishing you all Very happy and prosperous New Year

$$Excel-Macros$$

Re: $$Excel-Macros$$ Wishing you all Very happy and prosperous New Year

$$Excel-Macros$$ Change / Arrange no. of order of Sheets - Help

Re: $$Excel-Macros$$ Wishing you all Very happy and prosperous New Year

19 matches

Site Navigation

Mail list logo

Footer information