date:20101208

$$Excel-Macros$$ Reqd : Add in to convert Number to text in Excel 2007

2010-12-08 Thread OpenExcel.com

Hi Manjunath,


Try this:http://openexcel.googlecode.com/files/OPEN_XL.zip








Thanks & Regards
Ashish Jain
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.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

$$Excel-Macros$$ insert a blank row

2010-12-08 Thread L.K. Modi

Dear all

can any one help me in inserting black rows after line no.5


like 5 then blank row then 6 and then again blank row and again


regards
LKModi

-- 
--
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$$ Hi - Number need to fill randomly

2010-12-08 Thread Manoj kumar

Pls find the attached...


Regards,
Manoj Kumar

On Wed, Dec 8, 2010 at 12:34 PM, Manjunath C wrote:

> Hi Team,
>
> I need to fill the highlighted(brown) coloumn with numbers 1 to 90 randomly
> by clicking the button "Press" each time.
> Finally we need the data as highlighted in yellow.
>
> Thanks
> Manjunath
>
> --
>
> --
> 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


Random filling-Manoj.xlsm
Description: Binary data

Re: $$Excel-Macros$$ Fwd: insert a blank row

2010-12-08 Thread ashish koul

try this see if it helps

Sub rowinsertcola()


Dim i, j, k, z, h As Long
j = 1
z = 1


Range("a65356").Select
Selection.End(xlUp).Select

k = ActiveCell.Row




   For i = 5 To k + z Step 1



   If (i Mod j = 0) Then

   ActiveSheet.Cells(i + z, 1).Select

   Selection.EntireRow.Insert


z = z + 1


End If

Next i

End Sub


On Wed, Dec 8, 2010 at 1:34 PM, L.K. Modi  wrote:

>
>
> Dear all
>
> can any one help me in inserting black rows after line no.5
>
>
> like 5 then blank row then 6 and then again blank row and again
>
>
> regards
> LKModi
>
> --
>
> --
> 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$$ Error in Macro Code

2010-12-08 Thread vebhav jain

I want the highlighed code to be in a standard format. The data which i get
daily it keep varies and i  get struck at range(A1:B334). when i recorded
this macro at that time it was A1 :B334
and next day it changed to A1:B321, Next day i ran the macro...not able to
execute.i hope you understood my query.

On Wed, Dec 8, 2010 at 9:45 AM, Dave Bonallack wrote:

>   Hi Vebhav,
> You say you need to change the highlighted code daily, but you don't say
> what you change it to, or on what basis it is changed. We need to know this
> if we have any chance of helping you automate the process.
> Regards - Dave.
>
>
> --
> Date: Wed, 8 Dec 2010 06:51:01 +0530
> Subject: Re: $$Excel-Macros$$ Error in Macro Code
>
> From: vebhav.j...@gmail.com
> To: excel-macros@googlegroups.com
>
>  Can someone look into this and suggest me.
>
> On Tue, Dec 7, 2010 at 10:33 PM, vebhav jain wrote:
>
> Hello,
>
> Can you please help me in making this code in a standard format, instead of
> changing the code daily manually of the highlighted text. Thanks in Advance.
>
> Sub macro1()
> '
> ' Macro1 Macro
> '
>
> '
> Dim Z As Long
> Range("H2").Select
> ActiveCell.FormulaR1C1 = "=CONCATENATE(RC[-6],RC[-5],RC[-1])"
> Range("H2").Select
>   *  Selection.AutoFill Destination:=Range("H2:H341")*
> Columns("H:H").Select
> Selection.Copy
> Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
> SkipBlanks _
> :=False, Transpose:=False
> Columns("B:G").Select
> Application.CutCopyMode = False
> Selection.Delete Shift:=xlToLeft
> Range("A1:B1").Select
> Range(Selection, Selection.End(xlDown)).Select
> ActiveWorkbook.Worksheets("kmhpmebck1").Sort.SortFields.Clear
> ActiveWorkbook.Worksheets("kmhpmebck1").Sort.SortFields.Add
> Key:=Columns( _
> "B:B"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
>
> xlSortNormal
> With ActiveWorkbook.Worksheets("kmhpmebck1").Sort
>   *  .SetRange Range("A1:B334")*
> .Header = xlYes
> .MatchCase = False
> .Orientation = xlTopToBottom
> .SortMethod = xlPinYin
> .Apply
> End With
> Selection.Subtotal GroupBy:=2, Function:=xlSum, TotalList:=Array(1), _
>
> Replace:=True, PageBreaks:=False, SummaryBelowData:=True
> ActiveSheet.Outline.ShowLevels RowLevels:=2
> Range("B3").Select
> Range(Selection, Selection.End(xlDown)).Select
> Selection.Font.Bold = False
> Selection.Replace What:="total", Replacement:="", LookAt:=xlPart, _
> SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
> ReplaceFormat:=False
> Columns("B:B").Select
> Selection.TextToColumns Destination:=Range("B1"),
> DataType:=xlFixedWidth, _
> FieldInfo:=Array(Array(0, 1), Array(5, 1), Array(8, 1)),
> TrailingMinusNumbers:= _
> True
> Range("A1").Select
> ActiveCell.FormulaR1C1 = "Balance"
> Range("B1").Select
> ActiveCell.FormulaR1C1 = "Portfolio"
> Range("C1").Select
> ActiveCell.FormulaR1C1 = "CCY"
> Range("D1").Select
> ActiveCell.FormulaR1C1 = "Date"
> Range("A1:D1").Select
> Range(Selection, Selection.End(xlDown)).Select
> Selection.SpecialCells(xlCellTypeVisible).Select
> Selection.Copy
> Sheets.Add After:=Sheets(Sheets.Count)
> ActiveSheet.Paste
> ActiveWindow.SmallScroll Down:=-21
> Application.CutCopyMode = False
> Selection.Cut
> Range("E1").Select
> ActiveSheet.Paste
> Range("H1").Select
> Range(Selection, Selection.End(xlDown)).Select
> Selection.Cut
> Selection.End(xlToLeft).Select
> Selection.End(xlToLeft).Select
> Selection.End(xlToLeft).Select
> ActiveSheet.Paste
> Range("F1").Select
> Range(Selection, Selection.End(xlDown)).Select
> Columns("F:G").Select
> Selection.Cut
> Range("B1").Select
> ActiveSheet.Paste
> Range("E1").Select
> Range(Selection, Selection.End(xlDown)).Select
> Selection.Cut
> Range("D1").Select
> ActiveSheet.Paste
> Selection.NumberFormat = "#,##0.00"
> Range("D25").Select
> Selection.End(xlDown).Select
> Range("B2").Select
> Selection.End(xlDown).Select
> Z = ActiveCell.Row + 0
> Range("B" & Z).Value = "Grand Total"
> ActiveCell.Select
> Selection.Font.Bold = True
> Selection.End(xlUp).Select
> Range("A1:D1").Select
> Selection.Font.Bold = True
> Range("D2").Select
> Range(Selection, Selection.End(xlDown)).Select
> Selection.NumberFormat = "#,##0.00_ ;[Red]-#,##0.00 "
> Range("D2").Select
> Range(Selection, Selection.End(xlDown)).Select
> End Sub
>
> Thanks,
> Vebhav Jain
>
> --
>
> --
> 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

Re: $$Excel-Macros$$ Fwd: insert a blank row

2010-12-08 Thread L.K. Modi

Dear Sir


I dont know much about macros hence pls send in the given file

On Wed, Dec 8, 2010 at 1:58 PM, ashish koul  wrote:

> try this see if it helps
>
> Sub rowinsertcola()
>
>
> Dim i, j, k, z, h As Long
> j = 1
> z = 1
>
>
> Range("a65356").Select
> Selection.End(xlUp).Select
>
> k = ActiveCell.Row
>
>
>
>
>For i = 5 To k + z Step 1
>
>
>
>If (i Mod j = 0) Then
>
>ActiveSheet.Cells(i + z, 1).Select
>
>Selection.EntireRow.Insert
>
>
> z = z + 1
>
>
> End If
>
> Next i
>
> End Sub
>
>
>   On Wed, Dec 8, 2010 at 1:34 PM, L.K. Modi  wrote:
>
>>
>>
>> Dear all
>>
>> can any one help me in inserting black rows after line no.5
>>
>>
>> like 5 then blank row then 6 and then again blank row and again
>>
>>
>> regards
>> LKModi
>>
>> --
>>
>> --
>> 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
>

-- 
--
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$$ if formula help

2010-12-08 Thread Abhidha Dixit

Thanks CG,Andril & ashish

On Wed, Dec 8, 2010 at 2:13 PM, ashish koul  wrote:

> try this you can avoid using multiple ifs with this
>
>
>
>
> On Wed, Dec 8, 2010 at 11:48 AM, C.G.Kumar wrote:
>
>> Solved & file Attached. Hope it serves the purpose.
>>
>> Regards,
>>
>> C.G.Kumar
>>
>>
>>
>>  On Wed, Dec 8, 2010 at 10:10 AM, Abhidha Dixit 
>> wrote:
>>
>>> Dear All,
>>>
>>> please help me with  the formula where in I should get the result
>>>
>>> 1 IF left 3 strings is ABH then B2 -200, IF DIX then B2 -400 , IF DEL
>>> then B2-300, subsequelntly I hve tried but somehow i am not getting the
>>> desired result
>>>
>>> Regards
>>> Abhidha
>>>
>>> --
>>>
>>> --
>>> 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,
>>
>> C.G.Kumar
>>
>>   --
>>
>> --
>> 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$$ URGENTHelp Required

2010-12-08 Thread girish kumar

Hi Ashish,

Any updates??

On Mon, Dec 6, 2010 at 3:04 PM, girish kumar wrote:

> Hi Ashish,
>
> i want one small info again in provided macro
>
> if i hide the Master sheet macro is not running, is there any way to hide
> the Master sheet and run the macro successfully?
>
> thanks in advance
>
> Regards
>
> Girish.
>
>
> On Tue, Nov 30, 2010 at 7:05 PM, ashish koul wrote:
>
>> its ok bro
>>
>>
>> On Tue, Nov 30, 2010 at 3:08 PM, girish kumar <
>> girishkumar832...@gmail.com> wrote:
>>
>>> Hi Ashish,
>>>
>>> i opened that website. but how to follow? or just need to open once?
>>>
>>>
>>> On Mon, Nov 29, 2010 at 8:52 PM, ashish koul wrote:
>>>
 welcome

 can you follow my blog  http://akoul.blogspot.com/
  thanks in advance


 On Mon, Nov 29, 2010 at 8:51 PM, girish kumar <
 girishkumar832...@gmail.com> wrote:

> Hi Ashish,
>
> Thanks for your wonderful efforts!!, its working fine.
>
> Thanks a lot.
>
> Regards
>
> Girish
>
>
> On Mon, Nov 29, 2010 at 6:29 PM, ashish koul wrote:
>
>> run crete val macro to add data in validation everytime u add a new
>> data to file
>>
>>
>> On Mon, Nov 29, 2010 at 11:52 AM, girish kumar <
>> girishkumar832...@gmail.com> wrote:
>>
>>> Dear Ashish / Experts
>>>
>>> Its wonderfull, its solved what i need.
>>>
>>> But i need VBA code for this because i need to send this file to my
>>> higher officials if formulas are there it wont be look good.
>>>
>>> and for drop box (Column XFD) u put only those destinations which are
>>> in Master sheet, if i need to add more destination what i have to do.
>>>
>>> Thanx in Advance.
>>>
>>> Regards
>>>
>>> Girish
>>>
>>> On Sat, Nov 27, 2010 at 7:14 PM, ashish koul 
>>> wrote:
>>>

 check the attachment see if it helps .

 On Sat, Nov 27, 2010 at 6:46 PM, girish kumar <
 girishkumar832...@gmail.com> wrote:

>  Dear Experts,
>>>
>>
> I need your help to sort this problem
>
> i have attached one file, i have mentioned my problem in file
> itself.
>
> thanks in advance
>
> regards
>
> Girish
>
>
>
>
>
>> --
>>> 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
>



 --
 *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.e

$$Excel-Macros$$ Need help on dynamic list

2010-12-08 Thread sharath sambrani

Hi,

I have two columns A and B.

column A contains list of tasks and column B contains sub-tasks
against each primary task.

i would like to have two drop down cells in column C and D.

whenever i select an option in the dropdown in cell C1, the list in D1
should show only the sub-tasks that belong to the respective primary
task.

eg: in the attached spreadsheet, if i select "Admin / Reporting" in
the list, in the other cell only the following sub-tasks should
reflect:

follow-up and reminder mails for Onhold/Offline/PCR records
Metrics reports (for SKAs and above)
Workplan preparation (for SKAs and above)
Logistics for training (for Training SKA)
Updating time entry reports
Updating project tracker (for SKAs and above)
Monitoring Service Desk (for SKAs and above)
query resolution time b/w QA and KA
query resolution time b/w KA and SKA
Monitoring quals mailbox
Updating KL tracker (for docs KL team)

i hope this request is clear.

let me know if you have any questions.

your help is much appreciated.

sharath

-- 
--
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$$ Need help on Excel Dynamic List

2010-12-08 Thread Sharath Sambrani

Hi,

I have two columns A and B.

column A contains list of tasks and column B contains sub-tasks
against each primary task.

i would like to have two drop down cells in column C and D.

whenever i select an option in the dropdown in cell C1, the list in D1
should show only the sub-tasks that belong to the respective primary
task.

eg: in the attached spreadsheet, if i select "Admin / Reporting" in
the list, in the other cell only the following sub-tasks should
reflect:

follow-up and reminder mails for Onhold/Offline/PCR records
Metrics reports (for SKAs and above)
Workplan preparation (for SKAs and above)
Logistics for training (for Training SKA)
Updating time entry reports
Updating project tracker (for SKAs and above)
Monitoring Service Desk (for SKAs and above)
query resolution time b/w QA and KA
query resolution time b/w KA and SKA
Monitoring quals mailbox
Updating KL tracker (for docs KL team)

i hope this request is clear.

let me know if you have any questions.

your help is much appreciated.

sharath

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


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

Re: $$Excel-Macros$$ Need help on Excel Dynamic List

2010-12-08 Thread Dilip Pandey

Hi Sharath,

Please check the attached file which has the resolution as per your
requirements. :)

Best Regards,
DILIPandey

On Wed, Dec 8, 2010 at 7:38 PM, Sharath Sambrani <
sharath.c.sambr...@gmail.com> wrote:

> Hi,
>
> I have two columns A and B.
>
> column A contains list of tasks and column B contains sub-tasks
> against each primary task.
>
> i would like to have two drop down cells in column C and D.
>
> whenever i select an option in the dropdown in cell C1, the list in D1
> should show only the sub-tasks that belong to the respective primary
> task.
>
> eg: in the attached spreadsheet, if i select "Admin / Reporting" in
> the list, in the other cell only the following sub-tasks should
> reflect:
>
> follow-up and reminder mails for Onhold/Offline/PCR records
> Metrics reports (for SKAs and above)
> Workplan preparation (for SKAs and above)
> Logistics for training (for Training SKA)
> Updating time entry reports
> Updating project tracker (for SKAs and above)
> Monitoring Service Desk (for SKAs and above)
> query resolution time b/w QA and KA
> query resolution time b/w KA and SKA
> Monitoring quals mailbox
> Updating KL tracker (for docs KL team)
>
> i hope this request is clear.
>
> let me know if you have any questions.
>
> your help is much appreciated.
>
> sharath
>
> --
>
> --
> 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
>



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


Dynamic Validataion by DILIPandey.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Need help on Excel Dynamic List

2010-12-08 Thread Dilip Pandey

You are welcome Sharat.

Best Regards,
DILIPandey

On 12/8/10, Sharath Sambrani  wrote:
> Fantastic!!!
>
> Thanks a ton Dilip!
>
> Sharath
>
> -- Forwarded message --
> From: Dilip Pandey 
> Date: Wed, Dec 8, 2010 at 8:43 PM
> Subject: Re: $$Excel-Macros$$ Need help on Excel Dynamic List
> To: excel-macros@googlegroups.com
> Cc: sharath.c.sambr...@gmail.com
>
>
> Hi Sharath,
>
> Please check the attached file which has the resolution as per your
> requirements. :)
>
> Best Regards,
> DILIPandey
>
>   On Wed, Dec 8, 2010 at 7:38 PM, Sharath Sambrani <
> sharath.c.sambr...@gmail.com> wrote:
>
>> Hi,
>>
>> I have two columns A and B.
>>
>> column A contains list of tasks and column B contains sub-tasks
>> against each primary task.
>>
>> i would like to have two drop down cells in column C and D.
>>
>> whenever i select an option in the dropdown in cell C1, the list in D1
>> should show only the sub-tasks that belong to the respective primary
>> task.
>>
>> eg: in the attached spreadsheet, if i select "Admin / Reporting" in
>> the list, in the other cell only the following sub-tasks should
>> reflect:
>>
>> follow-up and reminder mails for Onhold/Offline/PCR records
>> Metrics reports (for SKAs and above)
>> Workplan preparation (for SKAs and above)
>> Logistics for training (for Training SKA)
>> Updating time entry reports
>> Updating project tracker (for SKAs and above)
>> Monitoring Service Desk (for SKAs and above)
>> query resolution time b/w QA and KA
>> query resolution time b/w KA and SKA
>> Monitoring quals mailbox
>> Updating KL tracker (for docs KL team)
>>
>> i hope this request is clear.
>>
>> let me know if you have any questions.
>>
>> your help is much appreciated.
>>
>> sharath
>>
>> --
>>
>> --
>> 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
>>
>
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY
>   MBA-HR,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>

-- 
Sent from my mobile device

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 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$$ Select the next cell when the page open

2010-12-08 Thread Daniel

Hello,
Here is an example if the setting can be done using row 1 :

Private Sub Worksheet_Activate()
Dim lastcolumn
lastcolumn = Cells(1, Columns.Count).End(xlToLeft).Offset(, 1).Column
Cells(1, lastcolumn).Select
End Sub

Regards.
Daniel

-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Rajesh K R
Envoyé : mardi 7 décembre 2010 16:18
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ Select the next cell when the page open

Hi
i got a mistake in my code here is the correct one

Private Sub Worksheet_Activate()
Dim lastrow
lastrow = Cells(Rows.Count, 12).End(xlUp).Offset(1, 0).Row Cells(lastrow,
12).Select End Sub Regards Rajesh kainikkara

On 12/7/10, Rajesh K R  wrote:
> HI Daniel
> here is the code what i am using the last raw in a work sheet when it 
> activate i want a code like this instead of row here i want to find 
> the next column.
>
> Private Sub Worksheet_Activate()
> Dim lastcolumn
> lastcolumn = Cells(Columns.Count, 12).End(xlUp).Offset(1, 0).Row 
> Cells(lastcolumn, 12).Select End Sub
>
> Thanks & Regards
> Rajesh Kainikkara
>
> On 12/6/10, Daniel  wrote:
>> Hello.
>> Maybe :
>> Columns(Day(Date)).Select
>> Regards.
>> Daniel
>>
>> -Message d'origine-
>> De : excel-macros@googlegroups.com 
>> [mailto:excel-mac...@googlegroups.com]
>> De
>> la part de Rajesh K R
>> Envoyé : lundi 6 décembre 2010 17:26
>> À : excel-macros
>> Objet : $$Excel-Macros$$ Select the next cell when the page open
>>
>> Hi Experts
>>
>> I am using an excel sheet for attendance marking sheet have 31 
>> columns for each day.
>> if i mark the attendance up to 5th , i want to get select the column 
>> for 6th day automatically when i open the page.how can write the code
>>  1 a b c d e f
>>  2 1 2 3 4 5 6
>>  3 x x x x x
>>  4 x x x x x
>>
>> Thanks in advance
>> Ragards
>>
>> Rajesh kainikkara
>>
>> --
>> -
>> ---
>> --
>> 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
>>
>

--

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

RE: $$Excel-Macros$$ Error in Macro Code

2010-12-08 Thread Dave Bonallack


Hi Vebhav,
Is there any data after the range you mention? For example, if today's data is 
Range A1:B330, is there any data in cells A331:B65000? If the cells below the 
data is blank, then we should be able to help you. Also, the other highlighted 
range, H2:H341; how does that relate to the first range, since it contains a 
different number of cells? Is it always 11 cells more than the range of data in 
Columns A & B?
Regards - Dave.

 


Date: Wed, 8 Dec 2010 13:47:33 +0530
Subject: Re: $$Excel-Macros$$ Error in Macro Code
From: vebhav.j...@gmail.com
To: excel-macros@googlegroups.com

I want the highlighed code to be in a standard format. The data which i get 
daily it keep varies and i  get struck at range(A1:B334). when i recorded this 
macro at that time it was A1 :B334

and next day it changed to A1:B321, Next day i ran the macro...not able to 
execute.i hope you understood my query.
 
On Wed, Dec 8, 2010 at 9:45 AM, Dave Bonallack  
wrote:






Hi Vebhav,
You say you need to change the highlighted code daily, but you don't say what 
you change it to, or on what basis it is changed. We need to know this if we 
have any chance of helping you automate the process.
Regards - Dave.

 


Date: Wed, 8 Dec 2010 06:51:01 +0530
Subject: Re: $$Excel-Macros$$ Error in Macro Code 

From: vebhav.j...@gmail.com
To: excel-macros@googlegroups.com




Can someone look into this and suggest me.


On Tue, Dec 7, 2010 at 10:33 PM, vebhav jain  wrote:

Hello, 


Can you please help me in making this code in a standard format, instead of 
changing the code daily manually of the highlighted text. Thanks in Advance.


Sub macro1() 
' 
' Macro1 Macro 
' 

' 
Dim Z As Long 
Range("H2").Select 
ActiveCell.FormulaR1C1 = "=CONCATENATE(RC[-6],RC[-5],RC[-1])" 
Range("H2").Select 
Selection.AutoFill Destination:=Range("H2:H341") 
Columns("H:H").Select 
Selection.Copy 
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks 
_ 
:=False, Transpose:=False 
Columns("B:G").Select 
Application.CutCopyMode = False 
Selection.Delete Shift:=xlToLeft 
Range("A1:B1").Select 
Range(Selection, Selection.End(xlDown)).Select 
ActiveWorkbook.Worksheets("kmhpmebck1").Sort.SortFields.Clear 
ActiveWorkbook.Worksheets("kmhpmebck1").Sort.SortFields.Add Key:=Columns( _ 
"B:B"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _ 
xlSortNormal 
With ActiveWorkbook.Worksheets("kmhpmebck1").Sort 
.SetRange Range("A1:B334") 
.Header = xlYes 
.MatchCase = False 
.Orientation = xlTopToBottom 
.SortMethod = xlPinYin 
.Apply 
End With 
Selection.Subtotal GroupBy:=2, Function:=xlSum, TotalList:=Array(1), _ 
Replace:=True, PageBreaks:=False, SummaryBelowData:=True 
ActiveSheet.Outline.ShowLevels RowLevels:=2 
Range("B3").Select 
Range(Selection, Selection.End(xlDown)).Select 
Selection.Font.Bold = False 
Selection.Replace What:="total", Replacement:="", LookAt:=xlPart, _ 
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ 
ReplaceFormat:=False 
Columns("B:B").Select 
Selection.TextToColumns Destination:=Range("B1"), DataType:=xlFixedWidth, _ 
FieldInfo:=Array(Array(0, 1), Array(5, 1), Array(8, 1)), 
TrailingMinusNumbers:= _ 
True 
Range("A1").Select 
ActiveCell.FormulaR1C1 = "Balance" 
Range("B1").Select 
ActiveCell.FormulaR1C1 = "Portfolio" 
Range("C1").Select 
ActiveCell.FormulaR1C1 = "CCY" 
Range("D1").Select 
ActiveCell.FormulaR1C1 = "Date" 
Range("A1:D1").Select 
Range(Selection, Selection.End(xlDown)).Select 
Selection.SpecialCells(xlCellTypeVisible).Select 
Selection.Copy 
Sheets.Add After:=Sheets(Sheets.Count) 
ActiveSheet.Paste 
ActiveWindow.SmallScroll Down:=-21 
Application.CutCopyMode = False 
Selection.Cut 
Range("E1").Select 
ActiveSheet.Paste 
Range("H1").Select 
Range(Selection, Selection.End(xlDown)).Select 
Selection.Cut 
Selection.End(xlToLeft).Select 
Selection.End(xlToLeft).Select 
Selection.End(xlToLeft).Select 
ActiveSheet.Paste 
Range("F1").Select 
Range(Selection, Selection.End(xlDown)).Select 
Columns("F:G").Select 
Selection.Cut 
Range("B1").Select 
ActiveSheet.Paste 
Range("E1").Select 
Range(Selection, Selection.End(xlDown)).Select 
Selection.Cut 
Range("D1").Select 
ActiveSheet.Paste 
Selection.NumberFormat = "#,##0.00" 
Range("D25").Select 
Selection.End(xlDown).Select 
Range("B2").Select 
Selection.End(xlDown).Select 
Z = ActiveCell.Row + 0 
Range("B" & Z).Value = "Grand Total" 
ActiveCell.Select 
Selection.Font.Bold = True 
Selection.End(xlUp).Select 
Range("A1:D1").Select 
Selection.Font.Bold = True 
Range("D2").Select 
Range(Selection, Selection.End(xlDown)).Select 
Selection.Num

$$Excel-Macros$$ how to protect & unprotect the sheet with same button

2010-12-08 Thread Rajesh K R

Hi Experts

i am want to give an edit button in my worksheet, for protecting &
unprotecting the sheet how can i use it. I try this code but not
working,pls correct it

Sub Macro6()
If ActiveSheet.Protect = True Then
ActiveSheet.Unprotect
Else
If ActiveSheet.Protect = False Then
ActiveSheet.Protect
End If
End If
End Sub

Regards
Rajesh Kainikkara

-- 
--
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$$ Need help on dynamic list

2010-12-08 Thread Deepak Rai

Hi,

 Please find the attached solution. In sheet one I have two validation
lists, which is taking data from Sheet2. Sheet2 has named ranges.
 Hope this will help you. With the help of Named Range and Indirect formula
you can do this very easily.

Regards,
Deepak Rai

On Wed, Dec 8, 2010 at 7:33 PM, sharath sambrani <
sharath.c.sambr...@gmail.com> wrote:

> Hi,
>
> I have two columns A and B.
>
> column A contains list of tasks and column B contains sub-tasks
> against each primary task.
>
> i would like to have two drop down cells in column C and D.
>
> whenever i select an option in the dropdown in cell C1, the list in D1
> should show only the sub-tasks that belong to the respective primary
> task.
>
> eg: in the attached spreadsheet, if i select "Admin / Reporting" in
> the list, in the other cell only the following sub-tasks should
> reflect:
>
> follow-up and reminder mails for Onhold/Offline/PCR records
> Metrics reports (for SKAs and above)
> Workplan preparation (for SKAs and above)
> Logistics for training (for Training SKA)
> Updating time entry reports
> Updating project tracker (for SKAs and above)
> Monitoring Service Desk (for SKAs and above)
> query resolution time b/w QA and KA
> query resolution time b/w KA and SKA
> Monitoring quals mailbox
> Updating KL tracker (for docs KL team)
>
> i hope this request is clear.
>
> let me know if you have any questions.
>
> your help is much appreciated.
>
> sharath
>
> --
>
> --
> 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,
Deepak Rai

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


Indirect Formula Explaination.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ cumulative sum in pivot table

2010-12-08 Thread Deepak Rai

Hi Alisha,

It would be really helpful if you can share a dump file.

Regards,
Deepak Rai

On Tue, Dec 7, 2010 at 4:06 PM, alisha malhotra  wrote:

> Hi Group,
>
> I have one pivot table. In that  I want to show the cumulative sum.
> e.g.
> Qtr1 sale:- 10 units
> Qtr2 sale:- 20 units
> Qtr3 sale:- 10 units
> Qtr4 sale:- 30 units
> now i want to show the sale of qtr1 and qtr2 i.e. 30 units after  qtr2 and
> similarly after qtr3 cumulative sum of qtr1,2 and 3 i.e. 40 units  and so
> on.
>
> How can I do this? Can anyone help me please?
>
> Thanks & Regards,
> Alisha malhotra
>
> --
>
> --
> 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,
Deepak Rai

-- 
--
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$$ Need to separate/parse directory path and filename using Excel 2007 ...

2010-12-08 Thread Greg

Hi,

I needed to override the Data Import Wizard so I have created a macro
which functions perfectly. However, the filename is hard coded in the
macro and I need to run the macro on different files and select each
file individually. After searching through the Mr Excel Forum
archives, I learned about the following instructions which prompts me
for the filename:

filename = Application.GetOpenFilename("Text Files (*.txt), *.txt")
If filename <> False Then
MsgBox "Open " & filename
End If

http://www.mrexcel.com/archive/VBA/7026.html

This is great! However, I need to substitute the captured filename in
two places. Once containing the full path and filename and again with
just the filename.Thanks in advance for any assistance you can
provide.

Kind regards,
Greg

-- 
--
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$$ cumulative sum in pivot table

2010-12-08 Thread Kantilal Badale

check the attachment see if it helps .

Kantilal  Badale




On Tue, Dec 7, 2010 at 4:06 PM, alisha malhotra  wrote:

> Hi Group,
>
> I have one pivot table. In that  I want to show the cumulative sum.
> e.g.
> Qtr1 sale:- 10 units
> Qtr2 sale:- 20 units
> Qtr3 sale:- 10 units
> Qtr4 sale:- 30 units
> now i want to show the sale of qtr1 and qtr2 i.e. 30 units after  qtr2 and
> similarly after qtr3 cumulative sum of qtr1,2 and 3 i.e. 40 units  and so
> on.
>
> How can I do this? Can anyone help me please?
>
> Thanks & Regards,
> Alisha malhotra
>
> --
>
> --
> 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


Cumulative sum in pivot.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Learning Macro

2010-12-08 Thread balbirkumar .

Dear Friends,


I dont know how create macros in excel and how and what codes are used for
its creation. But, I am interested in Knowing them. Please suggest me from
where i could learn.



With
Thanks & Regards

-- 
Balbir Kumar

-- 
--
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$$ Re: Learning Macro

2010-12-08 Thread anandydr

Hi,

If you do a google search for the term MS Excel VBA tutorials you will
find a lot of websites for that. The best way would be to take a task
that you do repeatedly and start creating a macro for it. Learning
from one project you will eventually learn how to automate a lot of
tasks.

In case you need ebooks or further help on problems you encounter feel
free to post on the group or mail me at anand...@gmail.com

Hope that helps,
Anand Kumar

On Dec 9, 10:31 am, "balbirkumar ."  wrote:
> Dear Friends,
>
> I dont know how create macros in excel and how and what codes are used for
> its creation. But, I am interested in Knowing them. Please suggest me from
> where i could learn.
>
> With
> Thanks & Regards
>
> --
> Balbir Kumar

-- 
--
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$$ Learning Macro

2010-12-08 Thread danial mansoor




U CAN JOIN THIS ONLINE COURSE FOR LEARNING MACROS IN DETAIL, ITS AWESOME GO AND 
HAVE A LOOK...

http://www.masterofmacros.com/



Date: Thu, 9 Dec 2010 11:01:47 +0530
Subject: $$Excel-Macros$$ Learning Macro
From: balbirku...@sify.com
To: excel-macros@googlegroups.com

Dear Friends,
 
 
I dont know how create macros in excel and how and what codes are used for its 
creation. But, I am interested in Knowing them. Please suggest me from where i 
could learn.
 
 
 
With
Thanks & Regards
-- 
Balbir Kumar




-- 

--

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$$ Reqd : Add in to convert Number to text in Excel 2007

$$Excel-Macros$$ insert a blank row

Re: $$Excel-Macros$$ Hi - Number need to fill randomly

Re: $$Excel-Macros$$ Fwd: insert a blank row

Re: $$Excel-Macros$$ Error in Macro Code

Re: $$Excel-Macros$$ Fwd: insert a blank row

Re: $$Excel-Macros$$ if formula help

Re: $$Excel-Macros$$ URGENTHelp Required

$$Excel-Macros$$ Need help on dynamic list

$$Excel-Macros$$ Need help on Excel Dynamic List

Re: $$Excel-Macros$$ Need help on Excel Dynamic List

Re: $$Excel-Macros$$ Need help on Excel Dynamic List

RE: $$Excel-Macros$$ Select the next cell when the page open

RE: $$Excel-Macros$$ Error in Macro Code

$$Excel-Macros$$ how to protect & unprotect the sheet with same button

Re: $$Excel-Macros$$ Need help on dynamic list

Re: $$Excel-Macros$$ cumulative sum in pivot table

$$Excel-Macros$$ Need to separate/parse directory path and filename using Excel 2007 ...

Re: $$Excel-Macros$$ cumulative sum in pivot table

$$Excel-Macros$$ Learning Macro

$$Excel-Macros$$ Re: Learning Macro

RE: $$Excel-Macros$$ Learning Macro

22 matches

Site Navigation

Mail list logo

Footer information