date:20110517

Re: $$Excel-Macros$$ Copy & paste data for dynamic data_need Excel Macro Solution

2011-05-17 Thread sagar aher

Hi,

Thanks ashish & Mahesh.

I need solution in different form.Please find new wxcel file with input data
& result required.

Kindly give me solution.

Thanks in adavnce

Regards

Sagar Aher
On Tue, May 17, 2011 at 6:04 PM, Mahesh parab  wrote:

> Hi Sagar
>
> find attach, check whether its as per u r requirement.
> Thanks
> Mahesh
>  On Tue, May 17, 2011 at 1:57 PM, sagar aher  wrote:
>
>>   Hi Ashish,
>>
>> Please find file & expected result...olz help..its urgent
>>
>> I have got following data in excel. I need to copy 1st number in given
>> row for e.g. 122532 should be copied against 100 for 4 times & similar
>> way 321654 should be get copied against 200 for 3 time like way.
>> ( Problem is that I'm not sure how many times 100 or 200 nos. comes )
>> kindly suggest me macro to run the same for very large data
>> plz find file where input & result is shown..kindly suggest me macro
>> solution
>>
>> thanks...
>> --
>> Cheers
>> Sagar Aher :)
>>
>>
>>
>> On Tue, May 17, 2011 at 1:43 PM, ashish koul wrote:
>>
>>>
>>> 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
 >
 >
 >
 >
 >
 > On Thu, May 12, 2011 at 3:47 PM, sagaraher 
 wrote:
 > > I have got following data in excel. I need to copy 1st number in
 given
 > > row for e.g. 122532 should be copied against 100 for 4 times &
 similar
 > > way 321654 should be get copied against 200 for 3 time like way.
 > > ( Problem is that I'm not sure how many times 100 or 200 nos. comes
 )
 >
 > > kindly suggest me macro to run the same for very large data
 >
 > > 122532
 > > 100
 > > 100
 > > 100
 > > 100
 >
 > > 321654
 > > 200
 > > 200
 > > 200
 >
 > > 654987
 > > 300
 > > 300
 > > 300
 > > 300
 > > 300
 > > 300
 >
 > > 987654
 > > 100
 > > 100
 >
 > > 789654
 > > 300
 > > 300
 > > 300
 > > 300
 > > 300
 > > 300
 > > 300
 > > 300
 >
 > > --
 >
 > >
 ------
 > > 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/discussexcel
 >
 > --
 > *Regards*
 > * *
 > *Ashish Koul*
 > *akoul*.*blogspot*.com 
 > *akoul*.wordpress.com 
 > My Linkedin Profile <
 http://in.linkedin.com/pub/ashish-koul/10/400/830>
 >
 > P Before printing, think about the environment.- 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/discussexcel

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

Re: $$Excel-Macros$$ Freeze/Unalterable Cells

2011-05-17 Thread Vinod Narayanan

Hi Ashish,


Thanks for your help... As i have explained in my previous mail, its a
questionnaire and the cell should freeze the moment the answers is chosen /
writtten

The macro freezes the moment an answer for a single question is answered...
but what i require is

when a person answers a question(b3) the answer in C3 should only freeze...
then when he answers a question (B4), the answer in C4 should only freeze..
so 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
>
> '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) Then
> Target.Locked = True
> End If
> ActiveSheet.Protect Password:="ashish"
> Else: End If
>
> End Sub
>
>
>
> On Mon, May 16, 2011 at 1:04 AM, Vinod Narayanan wrote:
>
>> Hi Team,
>>
>> Request you to help me creating an assessment sheet wherein the person
>> taking the test, once chooses the  option given in column C, the particular
>> cell should freeze...
>>
>> If the question is given B3 cell and the corresponding answers in C3
>> (either drop down or need to key in ... depending upon the question)
>> Sample sheet is attached... the movement the option is chosen by the
>> person, the cell c3 should freeze and make it unalterable
>>
>> --
>> Thanks and Regards
>>
>> Vinod Narayanan
>>
>>  --
>>
>> --
>> 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
>>
>
>
>
> --
> *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/discussexcel
>



-- 
Thanks and Regards

Vinod Narayanan

-- 
--
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$$ Delete columns A thru D if blank

2011-05-17 Thread Bob

I'm having a problem with, when the code runs, once I type something
in cell A3 the formula is automatically copied down. Thats fine but it
copies down each time I selcet a cell. I do not want any blanks. I can
not just delete blank rows because there is something in columns F
thru M. One blank row is fine. I just don't want it to keep inserting
a formula each time a select change is made. Maybe.. something like
A3:D if blank delete that section instead of entire row. Any help
please. Here is what I have...

 Sub auto_open()
' Auto_Open Macro
' Macro recorded 05/17/11 by R.L.S.
ThisWorkbook.Sheets("Worksheet2").OnEntry = "ValidateCells"
End Sub

Sub ValidateCells()
Worksheets("Worksheet2").Range("D3").Formula =
"=if(C3=,,C3*B3)"
Worksheets("Worksheet2").Range("D3",
Range("D65536").End(xlUp).Offset(1, 1)).FillDown
Worksheets("Worksheet2").Range("E3").Formula = "=if(B3=,,
(B3*144*C3))"
Worksheets("Worksheet2").Range("E3",
Range("D65536").End(xlUp).Offset(1, 1)).FillDown
End Sub

-- 
--
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$$ How to remove space in excel cell

2011-05-17 Thread STDEV(i)

sometimes what we thought as the space (as prefix or suffix) turns out to be
 *Char (160)*so we need formula like this
=SUBSTITUTE(A1,CHAR(160),"")

On Sun, May 15, 2011 at 12:48 PM, Prabhu  wrote:

> Hi friends,
> How to remove spaces(bugs) in a particular cell either will be as
> prefix or suffix before or after  number or text.
> Regards,
> Prabhu

-- 
--
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$$ database concept - Reg

2011-05-17 Thread STDEV(i)

it looks like you need a textbook /  excel standard manual
Go to a bookstore and buy one

you can also visit to this sites:

http://blog.contextures.com/archives/2010/03/10/sort-it-your-way-with-excel-custom-lists/
http://www.ehow.com/how_5905455_create-custom-list-excel-2007.html
http://spreadsheets.about.com/od/excel101/ss/enter_data.htm
 
http://oit.utk.edu/scc/HowToUseExcelForDataEntry.pdf
 
http://www.timeatlas.com/5_minute_tips/general/excel_data_form_makes_input_easier

http://www.internet4classrooms.com/excel_enter_edit.htm
 
http://www.homeandlearn.co.uk/me/mes10p1.html



On Tue, May 17, 2011 at 9:36 PM, jmothilal  wrote:

> how to create custom list , pls help me
>
>
>
>

-- 
--
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$$ Special Cursor Movement After the Enter Key is Pressed

2011-05-17 Thread STDEV(i)

Put this code into  *Sheet1 Module*

Private Sub Worksheet_Change(ByVal Target As Range)
   With Target
   If .Count = 1 Then
  If .Column = 8 Then Target(1, 2).Activate
  If .Column = 9 Then Target(2, 0).Activate
   End If
   End With
End Sub

' this macro run in column H and column I of Sheet1 only




On Tue, May 17, 2011 at 5:58 PM, John A. Smith wrote:

> I need a macro that will move the curser in a specific pattern of; Right
> one cell the first time, and down one and left one the second time and then
> repeat.
>
> It would save a lot of time entering the data in two side by side columns
> so I need it to not be column specific (so I could use it in any two side by
> side columns).
>
> Thank you for your continueing dedication to helping others with Excel.
>
> 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


ctv_Special Cursor Movement Upon Hitting Enter on H or I columns ONLY.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Re: Arbitrage Formula

2011-05-17 Thread RON SMITH

Please refer to attachment. I wasn't aware you could only upload within
Gmail.

Thanks.

On Tue, May 17, 2011 at 9:03 AM, DILIPandey  wrote:

> Hi Qcan,
>
> For the better understanding of the group, can you transfer the
> details in an excel spreadsheet and send the same as an attachment.
>
> Thanks,
> DILIPandey
>
>
> On May 15, 10:45 pm, qcan  wrote:
> > Hi,
> >
> > I am looking for a couple of formulas that can be used to calculate an
> > arbitrage in sports wagering.
> >
> > Example 1.
> >
> > An even split based on a 1000 dollar total wager divded between both
> > sides.
> >
> > - Side 1 odds = +110
> > - Side 2 odds = +150
> >
> > I know that one would have to wager $ 543.48 on side 1, in order to
> > get a return $ 1141.31
> > I also know that a wager of $ 456.52 on side two in order to get a
> > retrun of $ 1141.30
> >
> > In other words a 14.13 % profit would be generated evenly no matter
> > which side won.
> >
> > Example 2.
> >
> > The same as example 1 except I want to maximize side 1 while breaking
> > even on side 2. To clarify - this would mean that all the profit would
> > go to side 1 should side 1 win. If side 2 wins - I would break even.
> >
> > Using 1000 dollars again (actually 1140 dollars so that it's even),
> > with the same odds as the first exmaple - I know that
> >
> > -  $ 684.00 would have to be wagered on side 1 and $ 456.00 would have
> > to be wagered on side 2.
> >
> > If side 1 wins - I would get back a total of  $1436.40 (meaning a  $
> > 296.40 profit)
> > If side 2 wins - I would get back exactly the total money wagered on
> > both sides (1140 dollars) and break even.
> >
> > I have no idea how to express these two examples into a formula.
> > Further, the formula(s) might be different when the favorite is
> > actually below -100.
> >
> > I hope I made some sense. I will try and clarify should there be any
> > questions.
> >
> > Anyone ?
> >
> > 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/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


Arbitrage Project.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Arbitrage Formula

2011-05-17 Thread qcan

Hi,

I couldn't figure out how to upload or attach the spreadsheet file.
However, just copy & paste what I have pasted below into excel and it
will work and will properly format properly (I tried it - no issues).
Take note that there are no formulas. I essentially transcribed the
results using another program that I know is correct. I hope this
helps. I have included two examples below.

Thanks.

Example 1A

OddsWager   Return If Win   Profit  Pct Profit
Side 1  110 $543.48 $1,141.31   $141.31 14.13%
Side 2  150 $456.52 $1,141.30   $141.30 14.13%
Total   $1,000.00




Example 1B

OddsWager   Return If Win   Profit  Pct Profit
Side 1  -120$576.93 $1,057.69   $57.69  5.77%
Side 2  150 $423.07 $1,057.67   $67.67  5.77%
Total   $1,000.00




Example 2A

OddsWager   Return If Win   Profit  Pct Profit
Side 1  110 $684.00 $1,436.40   $296.40 26.00%
Side 2  150 $456.00 $1,140.00   $0.00   0.00%   BREAKEVEN
Total   $1,140.00


Example 2B

OddsWager   Return If Win   Profit  Pct Profit
Side 1  -120$636.00 $1,165.98   $105.98 10.00%
Side 2  150 $424.00 $1,060.00   $0.00   0.00%   BREAKEVEN
Total   $1,060.00



On May 17, 9:03 am, DILIPandey  wrote:
> Hi Qcan,
>
> For the better understanding of the group, can you transfer the
> details in an excel spreadsheet and send the same as an attachment.
>
> Thanks,
> DILIPandey
>
> On May 15, 10:45 pm, qcan  wrote:
>
>
>
> > Hi,
>
> > I am looking for a couple of formulas that can be used to calculate an
> > arbitrage in sports wagering.
>
> > Example 1.
>
> > An even split based on a 1000 dollar total wager divded between both
> > sides.
>
> > - Side 1 odds = +110
> > - Side 2 odds = +150
>
> > I know that one would have to wager $ 543.48 on side 1, in order to
> > get a return $ 1141.31
> > I also know that a wager of $ 456.52 on side two in order to get a
> > retrun of $ 1141.30
>
> > In other words a 14.13 % profit would be generated evenly no matter
> > which side won.
>
> > Example 2.
>
> > The same as example 1 except I want to maximize side 1 while breaking
> > even on side 2. To clarify - this would mean that all the profit would
> > go to side 1 should side 1 win. If side 2 wins - I would break even.
>
> > Using 1000 dollars again (actually 1140 dollars so that it's even),
> > with the same odds as the first exmaple - I know that
>
> > -  $ 684.00 would have to be wagered on side 1 and $ 456.00 would have
> > to be wagered on side 2.
>
> > If side 1 wins - I would get back a total of  $1436.40 (meaning a  $
> > 296.40 profit)
> > If side 2 wins - I would get back exactly the total money wagered on
> > both sides (1140 dollars) and break even.
>
> > I have no idea how to express these two examples into a formula.
> > Further, the formula(s) might be different when the favorite is
> > actually below -100.
>
> > I hope I made some sense. I will try and clarify should there be any
> > questions.
>
> > Anyone ?
>
> > Thanks !!- 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/discussexcel

Re: $$Excel-Macros$$ database concept - Reg

2011-05-17 Thread jmothilal

how to create custom list , pls help me


On Tue, May 17, 2011 at 5:15 PM, Rajan_Verma wrote:

>  Make a Custom List for all names
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *jmothilal
> *Sent:* Tuesday, May 17, 2011 3:03 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ database concept - Reg
>
>
>
> Dear Excel Experts
>
> I am typing name and place name different worksheets.
>
>
> like
>
> anand
> babu
> kumar
> anand
> kumar
> babu
>
> same worksheet it'  shows previous typing names ,  i want to store all the
> names in worksheets . when ever i need type get this name for any worksheets
> just like database
>
>
>
>
> --
> J.Mohilal
> Universal Computer Systems
> # 16, Brindavan Complex
> Otteri, Vellore-2
>
> --
>
> --
> 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
>



-- 
J.Mohilal
Universal Computer Systems
# 16, Brindavan Complex
Otteri, Vellore-2

-- 
--
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$$ MinMaxAverage : Using Sumproduct

2011-05-17 Thread Chandra Shekar

Hi Ashish,

Please find attached file.

Thanks,

Chanra Shekar B

On Tue, May 17, 2011 at 6:09 PM, ashish koul  wrote:

> i have made changes in the data may be because of that can you attach the
> sample file back
>
>
> On Tue, May 17, 2011 at 12:06 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi Asish,
>>
>> Thanks for your reply, but I did'nt get the desired result i.e. in MAX,
>> MIN & 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:
>>
>>> try this
>>>
>>>
>>> On Mon, May 16, 2011 at 12:12 PM, Chandra Shekar <
>>> chandrashekarb@gmail.com> wrote:
>>>
 Hi,

 I want Min Max and Average by using Sumproduct. My problem is I want a
 formula which should be based on Date and Title as shown on Column D, E & F
 and based on Column C I need Average, Min & Max Values. If I confusing pls
 let me know.

 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

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

$$Excel-Macros$$ Special Cursor Movement After the Enter Key is Pressed

2011-05-17 Thread John A. Smith

I need a macro that will move the curser in a specific pattern of; Right one
cell the first time, and down one and left one the second time and then
repeat.

It would save a lot of time entering the data in two side by side columns so
I need it to not be column specific (so I could use it in any two side by
side columns).

Thank you for your continueing dedication to helping others with Excel.

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


Special Curser Movement Upon Hitting Enter.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Freeze/Unalterable Cells

2011-05-17 Thread ashish koul

http://akoul.blogspot.com/search?q=protect


Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column = 3 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) Then
Target.Locked = True
End If
ActiveSheet.Protect Password:="ashish"
Else: End If

End Sub


On Mon, May 16, 2011 at 1:04 AM, Vinod Narayanan  wrote:

> Hi Team,
>
> Request you to help me creating an assessment sheet wherein the person
> taking the test, once chooses the  option given in column C, the particular
> cell should freeze...
>
> If the question is given B3 cell and the corresponding answers in C3
> (either drop down or need to key in ... depending upon the question)
> Sample sheet is attached... the movement the option is chosen by the
> person, the cell c3 should freeze and make it unalterable
>
> --
> Thanks and Regards
>
> Vinod Narayanan
>
>  --
>
> --
> 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
>



-- 
*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/discussexcel


Copy of Freeze Cells.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Arbitrage Formula

2011-05-17 Thread DILIPandey

Hi Qcan,

For the better understanding of the group, can you transfer the
details in an excel spreadsheet and send the same as an attachment.

Thanks,
DILIPandey


On May 15, 10:45 pm, qcan  wrote:
> Hi,
>
> I am looking for a couple of formulas that can be used to calculate an
> arbitrage in sports wagering.
>
> Example 1.
>
> An even split based on a 1000 dollar total wager divded between both
> sides.
>
> - Side 1 odds = +110
> - Side 2 odds = +150
>
> I know that one would have to wager $ 543.48 on side 1, in order to
> get a return $ 1141.31
> I also know that a wager of $ 456.52 on side two in order to get a
> retrun of $ 1141.30
>
> In other words a 14.13 % profit would be generated evenly no matter
> which side won.
>
> Example 2.
>
> The same as example 1 except I want to maximize side 1 while breaking
> even on side 2. To clarify - this would mean that all the profit would
> go to side 1 should side 1 win. If side 2 wins - I would break even.
>
> Using 1000 dollars again (actually 1140 dollars so that it's even),
> with the same odds as the first exmaple - I know that
>
> -  $ 684.00 would have to be wagered on side 1 and $ 456.00 would have
> to be wagered on side 2.
>
> If side 1 wins - I would get back a total of  $1436.40 (meaning a  $
> 296.40 profit)
> If side 2 wins - I would get back exactly the total money wagered on
> both sides (1140 dollars) and break even.
>
> I have no idea how to express these two examples into a formula.
> Further, the formula(s) might be different when the favorite is
> actually below -100.
>
> I hope I made some sense. I will try and clarify should there be any
> questions.
>
> Anyone ?
>
> 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/discussexcel

Re: $$Excel-Macros$$ Help Needed - Copy & paste data for dynamic data_need Excel Macro Solution

2011-05-17 Thread ashish koul

Sub ests()
Dim i As Long
Dim j, s As Long
For i = 1 To Sheets(1).Range("a65356").End(xlUp).Row
If Sheets(1).Cells(i, 1).Value = "" Then
j = i + 1
i = i + 2
End If
If Sheets(1).Cells(i, 1).Value <> "" Then

Sheets(2).Range("b65356").End(xlUp).Offset(1, 0).Value = Sheets(1).Cells(j,
1).Value

End If
Next i
End Sub


On Mon, May 16, 2011 at 1:48 PM, sagar aher  wrote:

> I have got following data in excel. I need to copy 1st number in given
> row for e.g. 122532 should be copied against 100 for 4 times & similar
> way 321654 should be get copied against 200 for 3 time like way.
> ( Problem is that I'm not sure how many times 100 or 200 nos. comes )
> kindly suggest me macro to run the same for very large data
> plz find file where input & result is shown..kindly suggest me macro
> solution
>
> thanks...
>
> --
> Cheers
>
> Sagar Aher :)
>
> --
>
> --
> 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
>



-- 
*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/discussexcel

Re: $$Excel-Macros$$ database concept - Reg

2011-05-17 Thread rf1234 rf1234

Dear Ravi,
Please have a view on attached Sheet.







On Tue, May 17, 2011 at 5:15 PM, Rajan_Verma wrote:

>  Make a Custom List for all names
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *jmothilal
> *Sent:* Tuesday, May 17, 2011 3:03 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ database concept - Reg
>
>
>
> Dear Excel Experts
>
> I am typing name and place name different worksheets.
>
>
> like
>
> anand
> babu
> kumar
> anand
> kumar
> babu
>
> same worksheet it'  shows previous typing names ,  i want to store all the
> names in worksheets . when ever i need type get this name for any worksheets
> just like database
>
>
>
>
> --
> J.Mohilal
> Universal Computer Systems
> # 16, Brindavan Complex
> Otteri, Vellore-2
>
> --
>
> --
> 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
>



-- 
Regards,
Prashant Tripathi
Engineer-SW
Mobile: 0017202597567
Please consider the environment before printing.

Immer zielen auf die vollkommene Harmonie des
 Denkens & Wort & deed.Always zielen darauf ab,
 reinigen Sie Ihre Meinung und alles wird gut.
 
Always aim at complete harmony of thought &
 word & deed.Always aim at purifying your
thoughts & everything will be well.

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


Select_Input_Value_From_List.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct

2011-05-17 Thread ashish koul

i have made changes in the data may be because of that can you attach the
sample file back

On Tue, May 17, 2011 at 12:06 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hi Asish,
>
> Thanks for your reply, but I did'nt get the desired result i.e. in MAX, MIN
> & 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:
>
>> try this
>>
>>
>> On Mon, May 16, 2011 at 12:12 PM, Chandra Shekar <
>> chandrashekarb@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> I want Min Max and Average by using Sumproduct. My problem is I want a
>>> formula which should be based on Date and Title as shown on Column D, E & F
>>> and based on Column C I need Average, Min & Max Values. If I confusing pls
>>> let me know.
>>>
>>> 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
>>>
>>
>>
>>
>> --
>> *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/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
>



-- 
*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/discussexcel

RE: $$Excel-Macros$$ database concept - Reg

2011-05-17 Thread Rajan_Verma

Make a Custom List for all names

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of jmothilal
Sent: Tuesday, May 17, 2011 3:03 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ database concept - Reg

 

Dear Excel Experts

I am typing name and place name different worksheets.


like

anand
babu
kumar
anand
kumar
babu

same worksheet it'  shows previous typing names ,  i want to store all the
names in worksheets . when ever i need type get this name for any worksheets
just like database




-- 
J.Mohilal
Universal Computer Systems
# 16, Brindavan Complex
Otteri, Vellore-2

-- 

--
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$$ database concept - Reg

2011-05-17 Thread jmothilal

Dear Excel Experts

I am typing name and place name different worksheets.


like

anand
babu
kumar
anand
kumar
babu

same worksheet it'  shows previous typing names ,  i want to store all the
names in worksheets . when ever i need type get this name for any worksheets
just like database




-- 
J.Mohilal
Universal Computer Systems
# 16, Brindavan Complex
Otteri, Vellore-2

-- 
--
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$$ Copy & paste data for dynamic data_need Excel Macro Solution

2011-05-17 Thread sagar aher

Hi Ashish,

Please find file & expected result...olz help..its urgent

I have got following data in excel. I need to copy 1st number in given
row for e.g. 122532 should be copied against 100 for 4 times & similar
way 321654 should be get copied against 200 for 3 time like way.
( Problem is that I'm not sure how many times 100 or 200 nos. comes )
kindly suggest me macro to run the same for very large data
plz find file where input & result is shown..kindly suggest me macro
solution

thanks...
-- 
Cheers
Sagar Aher :)



On Tue, May 17, 2011 at 1:43 PM, ashish koul  wrote:

>
> 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
>> >
>> >
>> >
>> >
>> >
>> > On Thu, May 12, 2011 at 3:47 PM, sagaraher  wrote:
>> > > I have got following data in excel. I need to copy 1st number in given
>> > > row for e.g. 122532 should be copied against 100 for 4 times & similar
>> > > way 321654 should be get copied against 200 for 3 time like way.
>> > > ( Problem is that I'm not sure how many times 100 or 200 nos. comes )
>> >
>> > > kindly suggest me macro to run the same for very large data
>> >
>> > > 122532
>> > > 100
>> > > 100
>> > > 100
>> > > 100
>> >
>> > > 321654
>> > > 200
>> > > 200
>> > > 200
>> >
>> > > 654987
>> > > 300
>> > > 300
>> > > 300
>> > > 300
>> > > 300
>> > > 300
>> >
>> > > 987654
>> > > 100
>> > > 100
>> >
>> > > 789654
>> > > 300
>> > > 300
>> > > 300
>> > > 300
>> > > 300
>> > > 300
>> > > 300
>> > > 300
>> >
>> > > --
>> >
>> > >
>> ------
>> > > 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/discussexcel
>> >
>> > --
>> > *Regards*
>> > * *
>> > *Ashish Koul*
>> > *akoul*.*blogspot*.com 
>> > *akoul*.wordpress.com 
>> > My Linkedin Profile 
>> >
>> > P Before printing, think about the environment.- 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/discussexcel
>>
>
>
>
> --
>  *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/discussexcel
>



-- 
Cheers

Sagar Aher :)

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

Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct

2011-05-17 Thread Chandra Shekar

Hi Asish,

Thanks for your reply, but I did'nt get the desired result i.e. in MAX, MIN
& 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:

> try this
>
>
> On Mon, May 16, 2011 at 12:12 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi,
>>
>> I want Min Max and Average by using Sumproduct. My problem is I want a
>> formula which should be based on Date and Title as shown on Column D, E & F
>> and based on Column C I need Average, Min & Max Values. If I confusing pls
>> let me know.
>>
>> 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
>>
>
>
>
> --
> *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/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$$ help me

2011-05-17 Thread §»VIPER«§

Hi

=ROUNDUP(5284/12,1) = 440.4
=ROUNDDOWN(440.4*12,0) = 5284

-- 
*Thanks & Regards

Thamu
*

On Mon, May 16, 2011 at 11:57 AM, memonkavi  wrote:

> Dear sir
>
> thanks 1nz again wat i requst that result i got from ur formula.,i
> want to reverse for example i multiple 440.04 by 12 then i got the
> result on excel itz (5280.48) bt i wnt the answer as 5284 how can i
> get it?
> regards kavi
>
> On May 15, 9:32 pm, Rajesh Naharwal  wrote:
> > Hi Dear,
> >
> > Use this formula,
> >
> > =roundup(5284/12,1)
> >
> > *Rajesh Naharwal
> >
> > On 15 May 2011 19:27, memonkavi  wrote:
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > > Dear Sir
> >
> > > This is my problem
> >
> > > one cartoon 12  boxes
> > > I have 440 cartoon 4 boxes
> > >cartoon  440x12=5280
> > >boxes4
> >
> > >   5284/12=440.33   this is excel result
> >
> > >I need result-440.4
> >
> > >pls help me
> > >how can i?
> > >regards
> > >kavi
> >
> > > --
> >
> > >
> ---
> ---
> > > 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/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$$ Copy & paste data for dynamic data_need Excel Macro Solution

2011-05-17 Thread ashish koul

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
> >
> >
> >
> >
> >
> > On Thu, May 12, 2011 at 3:47 PM, sagaraher  wrote:
> > > I have got following data in excel. I need to copy 1st number in given
> > > row for e.g. 122532 should be copied against 100 for 4 times & similar
> > > way 321654 should be get copied against 200 for 3 time like way.
> > > ( Problem is that I'm not sure how many times 100 or 200 nos. comes )
> >
> > > kindly suggest me macro to run the same for very large data
> >
> > > 122532
> > > 100
> > > 100
> > > 100
> > > 100
> >
> > > 321654
> > > 200
> > > 200
> > > 200
> >
> > > 654987
> > > 300
> > > 300
> > > 300
> > > 300
> > > 300
> > > 300
> >
> > > 987654
> > > 100
> > > 100
> >
> > > 789654
> > > 300
> > > 300
> > > 300
> > > 300
> > > 300
> > > 300
> > > 300
> > > 300
> >
> > > --
> >
> > >
> ------
> > > 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/discussexcel
> >
> > --
> > *Regards*
> > * *
> > *Ashish Koul*
> > *akoul*.*blogspot*.com 
> > *akoul*.wordpress.com 
> > My Linkedin Profile 
> >
> > P Before printing, think about the environment.- 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/discussexcel
>



-- 
*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/discussexcel

Re: $$Excel-Macros$$ Copy & paste data for dynamic data_need Excel Macro Solution

Re: $$Excel-Macros$$ Freeze/Unalterable Cells

$$Excel-Macros$$ Delete columns A thru D if blank

Re: $$Excel-Macros$$ How to remove space in excel cell

Re: $$Excel-Macros$$ database concept - Reg

Re: $$Excel-Macros$$ Special Cursor Movement After the Enter Key is Pressed

Re: $$Excel-Macros$$ Re: Arbitrage Formula

$$Excel-Macros$$ Re: Arbitrage Formula

Re: $$Excel-Macros$$ database concept - Reg

Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct

$$Excel-Macros$$ Special Cursor Movement After the Enter Key is Pressed

Re: $$Excel-Macros$$ Freeze/Unalterable Cells

$$Excel-Macros$$ Re: Arbitrage Formula

Re: $$Excel-Macros$$ Help Needed - Copy & paste data for dynamic data_need Excel Macro Solution

Re: $$Excel-Macros$$ database concept - Reg

Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct

RE: $$Excel-Macros$$ database concept - Reg

$$Excel-Macros$$ database concept - Reg

Re: $$Excel-Macros$$ Copy & paste data for dynamic data_need Excel Macro Solution

Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct

Re: $$Excel-Macros$$ help me

Re: $$Excel-Macros$$ Copy & paste data for dynamic data_need Excel Macro Solution

22 matches

Site Navigation

Mail list logo

Footer information