Re: $$Excel-Macros$$ help
HI Ganesh, I observed in the sheet that you have written the concatenate spelling wrong for the function. I hope that was the reason for #Name error. You can correct and check once. Regards, Praveen On Wed, Jan 20, 2010 at 12:27 PM, ganesh gw ganesh200...@gmail.com wrote: hi guys, i want to concatenate date with week but am not able to do that. so pl assist me. he showing some value after concatenation. am attaching a file. Pl assist me. -- Ganesh Gawde -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ help
Hi Ganesh, Please find attached file. I made some changes.Please refer. I think it will help to you. Thanks Regards, Santhosh,Bangalore On Wed, Jan 20, 2010 at 12:27 PM, ganesh gw ganesh200...@gmail.com wrote: hi guys, i want to concatenate date with week but am not able to do that. so pl assist me. he showing some value after concatenation. am attaching a file. Pl assist me. -- Ganesh Gawde -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe date function made by Santhosh.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ help
hi Ganesh Plz use this formula check attached file +TEXT(H7,dd-mm-) Whose Week is I7 On 20/01/2010, ganesh gw ganesh200...@gmail.com wrote: hi guys, i want to concatenate date with week but am not able to do that. so pl assist me. he showing some value after concatenation. am attaching a file. Pl assist me. -- Ganesh Gawde -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe date function Solved By Ankur.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: Concatenation based on criteria in other columns?
Hi Myke, find the enclosed file On 20/01/2010, nayag...@gmail.com nayag...@gmail.com wrote: Hi Myke, This can done by the following formula. =IF(C1=Inadequate,A1 B1 C1CHAR(10),) Hope this is will help you. Cheers, Valli On Jan 20, 2:30 am, Myke mykal.sm...@gmail.com wrote: Hello All, While this may sound silly, I'm trying to concatenate values in 3 columns into a single cell to essentially create a list using a formula. A B C 1 Area1 Value1 Inadequate 2 Area2 Value2 Adequate 3 Area3 Value3 Inadequate The manual way for me to do this is: Concatenate(A1, ,B1, ,C1,Char(10)) As you can see I want space between each value and a new line at the end. I want all rows where column C has Inadequate and for this concatenation to happen in one cell. The reason for this is so that I can refer to that cell using a text box in another sheet. I'm probably taking the wrong approach to accomplish this. Any help or suggestions are greatly appreciated! Thank you, Myke -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Solution By Ankur2.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ help
*Hi santosh, *thanks for quick reply.* * *1/20/2010 * *17-Jan to 23-Jan* * * *40198 whose week is 17-Jan to 23-Jan* * on 40198 i want to show my DATE that is 1/20/2010 whose week is 17-Jan to 23-Jan i want to concatenate the value which i calculate in B2 coloumn* On Wed, Jan 20, 2010 at 12:57 PM, Santhosh Kumar M K mks@gmail.comwrote: Hi Ganesh, Please find attached file. I made some changes.Please refer. I think it will help to you. Thanks Regards, Santhosh,Bangalore On Wed, Jan 20, 2010 at 12:27 PM, ganesh gw ganesh200...@gmail.comwrote: hi guys, i want to concatenate date with week but am not able to do that. so pl assist me. he showing some value after concatenation. am attaching a file. Pl assist me. -- Ganesh Gawde -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Ganesh Gawde -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: help
Hi Ganesh, =CONCATENATE(TEXT(A21,dd/mm/), whose week is ,B21) would work, as you need to set the format of the date when you concatenate it. Regards, Anil On Jan 20, 11:57 am, ganesh gw ganesh200...@gmail.com wrote: hi guys, i want to concatenate date with week but am not able to do that. so pl assist me. he showing some value after concatenation. am attaching a file. Pl assist me. -- Ganesh Gawde date function.xls 34KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: help
or also you can use this! =CONCATENATE(TEXT(A21,dd-mmm), whose week is ,B21) if you want to display the data in dd-mmm format. On Jan 20, 11:57 am, ganesh gw ganesh200...@gmail.com wrote: hi guys, i want to concatenate date with week but am not able to do that. so pl assist me. he showing some value after concatenation. am attaching a file. Pl assist me. -- Ganesh Gawde date function.xls 34KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: how to looping setting a time limit in excel 2007?
Hi, Please give me the reason why and what and I could give you How ! Regards, Anil On Jan 20, 10:58 am, memonkavi memonk...@gmail.com wrote: sir ex code do calculate loop until --- here i want set a time limit pls help me -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Sum Based on date criteria
Hello Mahesh, Attached is the shhet with your requirement. I used =SUMPRODUCT(COUNTIFS(INDIRECT('D8'!E:E),$E$7,INDIRECT('D8'!C:C),C8)) to implement your reqmnt. Let me know if you have any issues. Regards, Praveen On Wed, Jan 20, 2010 at 10:59 AM, mahesh parab mahes...@gmail.com wrote: Dear All In attach sheet i need a formula to sum status of each sheet based on date criteria. i dont want to use pivot for it. i will appreciate any help on this. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Sample_file.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Sum Based on date criteria
hi mahesh use of sumproduct will solve your problem check the attached file On 20/01/2010, mahesh parab mahes...@gmail.com wrote: Dear All In attach sheet i need a formula to sum status of each sheet based on date criteria. i dont want to use pivot for it. i will appreciate any help on this. -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Sample file solved by ankur.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ help
Dear Ganesh, Use this - *=CONCATENATE(TEXT(A21,dd-mmm), whose week is ,B21)* Change the format dd-mmm as whichever you like. Best regards, AJ On Wed, Jan 20, 2010 at 12:27 PM, ganesh gw ganesh200...@gmail.com wrote: hi guys, i want to concatenate date with week but am not able to do that. so pl assist me. he showing some value after concatenation. am attaching a file. Pl assist me. -- Ganesh Gawde -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ help
thanks abhishek, is done . thank you to all . On Wed, Jan 20, 2010 at 2:20 PM, Abhishek Jain abhishek@gmail.comwrote: Dear Ganesh, Use this - *=CONCATENATE(TEXT(A21,dd-mmm), whose week is ,B21)* Change the format dd-mmm as whichever you like. Best regards, AJ On Wed, Jan 20, 2010 at 12:27 PM, ganesh gw ganesh200...@gmail.comwrote: hi guys, i want to concatenate date with week but am not able to do that. so pl assist me. he showing some value after concatenation. am attaching a file. Pl assist me. -- Ganesh Gawde -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Ganesh Gawde -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ help
hi thanks. i did it. it exactly to mine requirement. thank you to all guys u tooo On Wed, Jan 20, 2010 at 3:00 PM, Santhosh Kumar M K mks@gmail.comwrote: Hi Ganesh, Please find attachment.Let me know any further..Thanks Regards, Santhosh Bangalore On Wed, Jan 20, 2010 at 12:27 PM, ganesh gw ganesh200...@gmail.comwrote: hi guys, i want to concatenate date with week but am not able to do that. so pl assist me. he showing some value after concatenation. am attaching a file. Pl assist me. -- Ganesh Gawde -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Ganesh Gawde -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Macro Pivotable
Hi I just start to learn about macro and need expert to advise. Now I have pivotable and I record macro that will select 2 pivotItems from pivotfields but some time pivotfields will container different number of pivotItem then when i run macro it's not work , I don't know why ? May some one help me ? Sorry for my english not good. Thanks WKH8919 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ how to looping setting a time limit in excel 2007?
try this: Sub test() Dim stoptime, cnt As Long stoptime = Now + TimeValue(00:00:05) ' 5 seconds from Now While Now stoptime cnt = cnt + 1 Application.StatusBar = Cnt: cnt Wend MsgBox done Application.StatusBar = False End Sub Paul From: memonkavi memonk...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Wed, January 20, 2010 12:58:07 AM Subject: $$Excel-Macros$$ how to looping setting a time limit in excel 2007? sir ex code do calculate loop until --- here i want set a time limit pls help me -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
RE: $$Excel-Macros$$ Sum Based on date criteria
Hi, Have a look at the attached. Let me know if it's what you need. Regards - Dave. Date: Wed, 20 Jan 2010 10:59:47 +0530 Subject: $$Excel-Macros$$ Sum Based on date criteria From: mahes...@gmail.com To: excel-macros@googlegroups.com Dear All In attach sheet i need a formula to sum status of each sheet based on date criteria. i dont want to use pivot for it. i will appreciate any help on this. _ Search for properties that match your lifestyle! Start searching NOW! http://clk.atdmt.com/NMN/go/157631292/direct/01/-- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Sample file.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: help
hi anil nice formula On 20/01/2010, Anil anilkuma...@target.com wrote: or also you can use this! =CONCATENATE(TEXT(A21,dd-mmm), whose week is ,B21) if you want to display the data in dd-mmm format. On Jan 20, 11:57 am, ganesh gw ganesh200...@gmail.com wrote: hi guys, i want to concatenate date with week but am not able to do that. so pl assist me. he showing some value after concatenation. am attaching a file. Pl assist me. -- Ganesh Gawde date function.xls 34KViewDownload -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ help
hi ganesh u r welcome On 20/01/2010, ganesh gw ganesh200...@gmail.com wrote: hi thanks. i did it. it exactly to mine requirement. thank you to all guys u tooo On Wed, Jan 20, 2010 at 3:00 PM, Santhosh Kumar M K mks@gmail.comwrote: Hi Ganesh, Please find attachment.Let me know any further..Thanks Regards, Santhosh Bangalore On Wed, Jan 20, 2010 at 12:27 PM, ganesh gw ganesh200...@gmail.comwrote: hi guys, i want to concatenate date with week but am not able to do that. so pl assist me. he showing some value after concatenation. am attaching a file. Pl assist me. -- Ganesh Gawde -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Ganesh Gawde -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Macro Pivotable
Hi WKH8919, I would like to see the recorded macro code. Regars, Anil On Jan 20, 2:52 pm, WKH8919 worawat...@gmail.com wrote: Hi I just start to learn about macro and need expert to advise. Now I have pivotable and I record macro that will select 2 pivotItems from pivotfields but some time pivotfields will container different number of pivotItem then when i run macro it's not work , I don't know why ? May some one help me ? Sorry for my english not good. Thanks WKH8919 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ how to looping setting a time limit in excel 2007?
hi memonkavi this a extract from a website http://www.cpearson.com/excel/OnTime.aspx perhaps this can help you As parameters, the OnTime method takes a specific data and time at which it should run the procedure and the name of the procedure to run. It is important to remember that you provide the date and time to run the procedure, not an offset from the current time. If you need to cancel an OnTime, you must provide the exact time that the event was schedule to take place. There is no way to tell Excel to cancel the next OnTime event or to cancel all the pending OnTime events. Therefore, you need to store the time at which the procedure is to run in a Public variable and use that variable's value in calls to OnTime. For example, declare Public variables in a standard code module, outside of and before any procedure (Sub or Function) declaration: Public RunWhen As Double Public Const cRunIntervalSeconds = 120 ' two minutes Public Const cRunWhat = TheSub ' the name of the procedure to run SectionBreak Starting A Timer To start a repeatable timer, create a procedure named StartTimer as shown below: Sub StartTimer() RunWhen = Now + TimeSerial(0,0,cRunIntervalSeconds) Application.OnTime EarliestTime:=RunWhen, Procedure:=cRunWhat, _ Schedule:=True End Sub This stores the time to run the procedure in the variable RunWhen, two minutes after the current time. Next, you need to write the procedure that will be called by OnTime. For example, Sub TheSub() ' Your code here StartTimer ' Reschedule the procedure End Sub This procedure executes whatever code you include in it, and then at the end calls the StartTimer procedure to schedule another OnTime event. This is how the periodic calls are implemented. Note that if you close the workbook while an OnTime event is pending, Excel will re-open that workbook to execute the procedure and will not close the workbook after the OnTime event is finished. SectionBreak Stopping A Timer At some point, you or your code will need to terminate the OnTime schedule loop. To cancel a pending OnTime event, you must provide the exact time that it is scheduled to run. That is the reason we stored the time in the Public variable RunWhen. You can think of the RunWhen value as a unique key into the OnTime settings. (It is certainly possible to have multiple OnTime events pending. In this, you should store each procedure's scheduled time in a separate variable. Each OnTime event needs its own RunWhen value.) The code below illustrates how to stop a pending OnTime event. Sub StopTimer() On Error Resume Next Application.OnTime EarliestTime:=RunWhen,Procedure:=cRunWhat, _ Schedule:=False End Sub SectionBreak Using Windows Timers In addition to Excel's OnTime method, you can use the Windows Timer functions provided via Window API. Windows Timers are automatically rescheduled and will continue to pop until you terminate the timer with the KillTimer API function. With a Windows Timer, you provide the interval, in milliseconds, that the timer will pop. The timer will pop at that interval until terminated with KillTimer. These procedures require Excel 2000 or later, since we use the AddressOf operator. The code will not work in Excel 97 or earlier versions. caution A NOTE OF CAUTION: If the code executed by the timer changes a cell value, and you are presently in edit mode in Excel (e.g., entering data in a cell), Excel will likely crash completely and you will lose all unsaved work. Use Windows timers with caution. To use Windows timers, paste the following code into a standard code module: Public Declare Function SetTimer Lib user32 ( _ ByVal HWnd As Long, _ ByVal nIDEvent As Long, _ ByVal uElapse As Long, _ ByVal lpTimerFunc As Long) As Long Public Declare Function KillTimer Lib user32 ( _ ByVal HWnd As Long, _ ByVal nIDEvent As Long) As Long Public TimerID As Long Public TimerSeconds As Single Sub StartTimer() TimerSeconds = 1 ' how often to pop the timer. TimerID = SetTimer(0, 0, TimerSeconds * 1000, AddressOf TimerProc) End Sub Sub EndTimer() On Error Resume Next KillTimer 0, TimerID End Sub Sub TimerProc(ByVal HWnd As Long, ByVal uMsg As Long, _ ByVal nIDEvent As Long, ByVal dwTimer As Long) '' ' This procedure is called by Windows. Put your ' code here. '' End Sub Run the procedure StartTimer to begin the periodic timer. The variable TimerSeconds indicates how often, in seconds, the timer is to pop. The SetTimer function takes a value in milliseconds, so the code multiplies TimerSeconds by 1000.When the timer pops Windows will call the procedrue TimerProc. You may name this procedure anything you want, but it must be declared with the parameters exactly as shown above. If the parameters differ from what is shown above, Excel will crash. When Windows calls TimerProc, it passes the
Re: $$Excel-Macros$$ Macro Pivotable
Dear All, I need a quick advise , I have created an excel file and saved the same in the intranet of my company, this excel file would be accessed and updated by 2 employees on a daily basis , Can any one please advise me what are the precautions I should take when 2 employees have access to the file It may be too basic, but I need this urgently ! Best regards Rajesh -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ open multiple web pages in IE 7 from excel
do not forget to add this line at the starting Dim oBrowser As New SHDocVw.InternetExplorer On Jan 18, 11:08 pm, Sandeep Kadam sand...@gmail.com wrote: Hi, I want open multiple web pages in IE 7 using excel macros. Can i use Arrays to store weblinks for loop to move the loop to the next link. I tried but its not working. Regards, Sandeep -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: Concatenation based on criteria in other columns?
Sorry, I probably wasn't clear enough. I'm looking for a solution that will put those strings (on separate lines) in ONE cell with word wrap. Basically it needs to find each instance where a row has inadequate and print those three values on a new line in a single cell. It seems more like an array type of solution that I am unaware of. On Jan 20, 2:36 am, ankur ankurpande...@gmail.com wrote: Hi Myke, find the enclosed file On 20/01/2010, nayag...@gmail.com nayag...@gmail.com wrote: Hi Myke, This can done by the following formula. =IF(C1=Inadequate,A1 B1 C1CHAR(10),) Hope this is will help you. Cheers, Valli On Jan 20, 2:30 am, Myke mykal.sm...@gmail.com wrote: Hello All, While this may sound silly, I'm trying to concatenate values in 3 columns into a single cell to essentially create a list using a formula. A B C 1 Area1 Value1 Inadequate 2 Area2 Value2 Adequate 3 Area3 Value3 Inadequate The manual way for me to do this is: Concatenate(A1, ,B1, ,C1,Char(10)) As you can see I want space between each value and a new line at the end. I want all rows where column C has Inadequate and for this concatenation to happen in one cell. The reason for this is so that I can refer to that cell using a text box in another sheet. I'm probably taking the wrong approach to accomplish this. Any help or suggestions are greatly appreciated! Thank you, Myke -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ Solution By Ankur2.xls 30KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Help Required - Gantt Chart
Hi Maniyan, Please check the file. I think this might help you. Regards Rakesh On Jan 20, 10:18 am, Maniyan pmni...@gmail.com wrote: Hi am working scheduling problem in excel. i would like to know...is there any way i can get the chart for the datas in Gantt Chart format. It will be greatful if somebody helps me out with this problem. sample excel file is attached for reference... Thanks, waiting for the reply... Regards Maniyan Help required.xls 29KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Workbooks.Open with http and password problem
Hi! I'm am opening an Excel workbook like - Workbook.Open(http://server/application/getbook?;) A login box pops up, I fill in username and password and the book opens all fine. The second time the login box does NOT pop up. The book opens ok anyway. So something (=windows) stores the login information somewhere. Now it just happend that the wrong login info got stored and I'm given no chance to change or reset it. I have reset EVERYTHING in Internet Explorer - does not help. I have rebooted - does not help. I guess it would have helped if the web server returned login failed correctly to the client. Then I guess the login pop up would show again. But the server just returns another web page with a text saying that I couldn't login. The web application I can't do anything about. So is there a way to reset the password list in Excel or wherever it is stored. Using Windows XP, IE7 and Office 2007 Thanks in advance! /Lasse -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: Macro Pivotable
?Hi Anill , Sorry for late reply , below is macro code record. Range(C8).Select With ActiveSheet.PivotTables(PivotTable1).PivotFields(Transaction Type) .PivotItems(Accept).Visible = False .PivotItems(Return to Receiving).Visible = False .PivotItems(Return to Supplier).Visible = False .PivotItems((blank)).Visible = False End With I have pivotitem 6 item are accept , return to receiving , return to supplier , blank , receive , delivery when I refresh data macor was not work coz pivotitem had less than 6 items. some time will no blank item or no return item actually I need data only 2 pivotitem are receive and delivery.I don't know how to set only receive and delivery item. Thanks, WKH8919 2010/1/20 Anil anilkuma...@target.com Hi WKH8919, I would like to see the recorded macro code. Regars, Anil On Jan 20, 2:52 pm, WKH8919 worawat...@gmail.com wrote: Hi I just start to learn about macro and need expert to advise. Now I have pivotable and I record macro that will select 2 pivotItems from pivotfields but some time pivotfields will container different number of pivotItem then when i run macro it's not work , I don't know why ? May some one help me ? Sorry for my english not good. Thanks WKH8919 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Reset Ignored Errors Excel Error Checking Options
The button in the dialogue box you get when you go down the path of Tools Options Error Checking tab On Jan 20, 6:37 am, OE bruce.tay...@downerediengineering.com.au wrote: Using Excel 2003 How do I programatically toggle this button. I can't find any documentation and the macro recorder doesn't log the action. thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Exporting data using Pulldown List
Hi Friends, I am developing a portfolio tracker excel file. I am having some difficulty in implementing one function, which I think I cannot create using macro. As you can see in the attached file, in the sheet Data, I am downloading various parameters using the SMF Add-In. Which is working fine. After downloading these data I want to export them into the other sheet Pull Down Option. I tried to use OFFSET and VLOOKUP function. But it is not working. In the Pull Down Option sheet, I have created a droop down list, so when I change the droop down list, the data associated (Sheet Data) with it should change. Regards, Sandip -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Portfolion Motior.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Sum Based on date criteria
Hi Praveen,Ankur,Dave thank you all of you ! On 1/20/10, Dave Bonallack davebonall...@hotmail.com wrote: Hi, Have a look at the attached. Let me know if it's what you need. Regards - Dave. -- Date: Wed, 20 Jan 2010 10:59:47 +0530 Subject: $$Excel-Macros$$ Sum Based on date criteria From: mahes...@gmail.com To: excel-macros@googlegroups.com Dear All In attach sheet i need a formula to sum status of each sheet based on date criteria. i dont want to use pivot for it. i will appreciate any help on this. -- Start searching NOW! Search for properties that match your lifestyle!http://clk.atdmt.com/NMN/go/157631292/direct/01/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Sum Based on date criteria
hi mahesh. u r welcome On 21/01/2010, mahesh parab mahes...@gmail.com wrote: Hi Praveen,Ankur,Dave thank you all of you ! On 1/20/10, Dave Bonallack davebonall...@hotmail.com wrote: Hi, Have a look at the attached. Let me know if it's what you need. Regards - Dave. -- Date: Wed, 20 Jan 2010 10:59:47 +0530 Subject: $$Excel-Macros$$ Sum Based on date criteria From: mahes...@gmail.com To: excel-macros@googlegroups.com Dear All In attach sheet i need a formula to sum status of each sheet based on date criteria. i dont want to use pivot for it. i will appreciate any help on this. -- Start searching NOW! Search for properties that match your lifestyle!http://clk.atdmt.com/NMN/go/157631292/direct/01/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Exporting data using Pulldown List
hi sandip plz check the attached file i think this is what you want On 21/01/2010, Sandip Patel myitems2...@gmail.com wrote: Hi Friends, I am developing a portfolio tracker excel file. I am having some difficulty in implementing one function, which I think I cannot create using macro. As you can see in the attached file, in the sheet Data, I am downloading various parameters using the SMF Add-In. Which is working fine. After downloading these data I want to export them into the other sheet Pull Down Option. I tried to use OFFSET and VLOOKUP function. But it is not working. In the Pull Down Option sheet, I have created a droop down list, so when I change the droop down list, the data associated (Sheet Data) with it should change. Regards, Sandip -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Portfolion Motior solved by ankur.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Help Required - Gantt Chart
hi rakesh very great approach for the solution i also needed this solution thanks buddy On 20/01/2010, Rakesh Sharma rak_sha...@yahoo.co.in wrote: Hi Maniyan, Here is the solution which I think my help you. Regards Rakesh The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/ -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ How to convert file PDF to Excel
Sir how to convert PDF to Excel ? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ how to looping setting a time limit in excel 2007?
Dear sir u done good help me.. lot of thanks.u gave code its work corretly. what need i done with u code withsome changes. anyhow u r my teacher in this matter. once again i want say thanks with sorry for my english. Regards: kavi On Jan 20, 5:18 pm, Paul Schreiner schreiner_p...@att.net wrote: try this: Sub test() Dim stoptime, cnt As Long stoptime = Now + TimeValue(00:00:05) ' 5 seconds from Now While Now stoptime cnt = cnt + 1 Application.StatusBar = Cnt: cnt Wend MsgBox done Application.StatusBar = False End Sub Paul From: memonkavi memonk...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Wed, January 20, 2010 12:58:07 AM Subject: $$Excel-Macros$$ how to looping setting a time limit in excel 2007? sir ex code do calculate loop until --- here i want set a time limit pls help me -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads athttp://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ how to looping setting a time limit in excel 2007?
Ankur Pandey! sir lot of thanks. u waste ur time. and gave some ideas with code for my problem. i will try it. and inform u. once again thanks with sorry for my english regards kavi On Jan 20, 4:19 pm, ankur ankurpande...@gmail.com wrote: hi memonkavi this a extract from a website http://www.cpearson.com/excel/OnTime.aspx perhaps this can help you As parameters, the OnTime method takes a specific data and time at which it should run the procedure and the name of the procedure to run. It is important to remember that you provide the date and time to run the procedure, not an offset from the current time. If you need to cancel an OnTime, you must provide the exact time that the event was schedule to take place. There is no way to tell Excel to cancel the next OnTime event or to cancel all the pending OnTime events. Therefore, you need to store the time at which the procedure is to run in a Public variable and use that variable's value in calls to OnTime. For example, declare Public variables in a standard code module, outside of and before any procedure (Sub or Function) declaration: Public RunWhen As Double Public Const cRunIntervalSeconds = 120 ' two minutes Public Const cRunWhat = TheSub ' the name of the procedure to run SectionBreak Starting A Timer To start a repeatable timer, create a procedure named StartTimer as shown below: Sub StartTimer() RunWhen = Now + TimeSerial(0,0,cRunIntervalSeconds) Application.OnTime EarliestTime:=RunWhen, Procedure:=cRunWhat, _ Schedule:=True End Sub This stores the time to run the procedure in the variable RunWhen, two minutes after the current time. Next, you need to write the procedure that will be called by OnTime. For example, Sub TheSub() ' Your code here StartTimer ' Reschedule the procedure End Sub This procedure executes whatever code you include in it, and then at the end calls the StartTimer procedure to schedule another OnTime event. This is how the periodic calls are implemented. Note that if you close the workbook while an OnTime event is pending, Excel will re-open that workbook to execute the procedure and will not close the workbook after the OnTime event is finished. SectionBreak Stopping A Timer At some point, you or your code will need to terminate the OnTime schedule loop. To cancel a pending OnTime event, you must provide the exact time that it is scheduled to run. That is the reason we stored the time in the Public variable RunWhen. You can think of the RunWhen value as a unique key into the OnTime settings. (It is certainly possible to have multiple OnTime events pending. In this, you should store each procedure's scheduled time in a separate variable. Each OnTime event needs its own RunWhen value.) The code below illustrates how to stop a pending OnTime event. Sub StopTimer() On Error Resume Next Application.OnTime EarliestTime:=RunWhen,Procedure:=cRunWhat, _ Schedule:=False End Sub SectionBreak Using Windows Timers In addition to Excel's OnTime method, you can use the Windows Timer functions provided via Window API. Windows Timers are automatically rescheduled and will continue to pop until you terminate the timer with the KillTimer API function. With a Windows Timer, you provide the interval, in milliseconds, that the timer will pop. The timer will pop at that interval until terminated with KillTimer. These procedures require Excel 2000 or later, since we use the AddressOf operator. The code will not work in Excel 97 or earlier versions. caution A NOTE OF CAUTION: If the code executed by the timer changes a cell value, and you are presently in edit mode in Excel (e.g., entering data in a cell), Excel will likely crash completely and you will lose all unsaved work. Use Windows timers with caution. To use Windows timers, paste the following code into a standard code module: Public Declare Function SetTimer Lib user32 ( _ ByVal HWnd As Long, _ ByVal nIDEvent As Long, _ ByVal uElapse As Long, _ ByVal lpTimerFunc As Long) As Long Public Declare Function KillTimer Lib user32 ( _ ByVal HWnd As Long, _ ByVal nIDEvent As Long) As Long Public TimerID As Long Public TimerSeconds As Single Sub StartTimer() TimerSeconds = 1 ' how often to pop the timer. TimerID = SetTimer(0, 0, TimerSeconds * 1000, AddressOf TimerProc) End Sub Sub EndTimer() On Error Resume Next KillTimer 0, TimerID End Sub Sub TimerProc(ByVal HWnd As Long, ByVal uMsg As Long, _ ByVal nIDEvent As Long, ByVal dwTimer As Long) '' ' This procedure is called by Windows. Put your ' code here. '' End Sub Run the procedure StartTimer to begin the periodic timer. The variable TimerSeconds indicates how often, in seconds, the timer is to pop. The SetTimer function takes a value in