Re: $$Excel-Macros$$ Re: pdf converter software code needed (able2extract)
Share With Exe File Please Regards Anil Kumar On Fri, Feb 26, 2010 at 12:02 PM, ankur ankurpande...@gmail.com wrote: ya sure this is the code 127418901528 Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Feb 26, 2010 at 11:43 AM, Harshad K harshadpl...@gmail.com wrote: can you share with me regards harshad On Fri, Feb 26, 2010 at 12:21 PM, ankur ankurpande...@gmail.com wrote: i got the code thnks Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Tue, Feb 23, 2010 at 4:02 PM, ankur ankurpande...@gmail.com wrote: hi experts, i had one pdf file converter pdf to different type of file like word, excel etc, i got that software from this group software name is able2extract somebody had mail the code also i lost that mail and code can anybody send me code again it will be very helpful to me 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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 select unique values from a list and copy each unique value to another location of another worksheet
How to select unique values from a list and copy each to another location of another worksheet? Not using auto-filter or advance filter? Thanks. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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$$ Inventory
Thanks Man...That works. Regards...Abhishek On Fri, Feb 26, 2010 at 12:33 PM, ankur ankurpande...@gmail.com wrote: hi abhishek luckily i got Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Feb 26, 2010 at 12:28 PM, ankur ankurpande...@gmail.com wrote: hi abhishek thanks for nice words... this is downloaded software..i dont have code of thislet me try to unlock ..if i get i will mail it you... Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Feb 26, 2010 at 12:25 PM, Abhishek Jain abhishek@gmail.com wrote: Dear Ankur, Thanks a lot ! Seems really interesting. Can I have the vba password of this file or can you send the unlocked version so that the code can be modified as per my requirements. Best regards, Abhishek On Fri, Feb 26, 2010 at 12:14 PM, ankur ankurpande...@gmail.com wrote: hi abhishek check this file it may help you Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Feb 26, 2010 at 10:21 AM, ankur ankurpande...@gmail.com wrote: check the file Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Tue, Feb 23, 2010 at 6:10 PM, Rajesh D rajesh...@gmail.com wrote: I am from Bangalore On 18 February 2010 07:18, Azmath Shariff azmath2...@gmail.com wrote: May i know where you from On Sat, Feb 13, 2010 at 11:52 AM, Rajesh D rajesh...@gmail.com wrote: if any body is having inventory control / pay roll in excel please forward me Thanks in advance 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 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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 -- Thanks Rajesh -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com
$$Excel-Macros$$ Need either excel formula or Macro
Hi Team I need help either in excel formula or macro for the product code need to splits in different sheets. 1. Data Sheet contains All product codes 2. Goods No.1 2 contain selected goods code item. 3. Other Goods sheet blank I need what ever the product available in Data Sheet it should highlight as YES in Goods No. 1 and 2 Sheets. Goods No. 1 2 Sheet NA product don't want to change YES becaseu they are no more available. It should retain as NA only Remaining all other goods should which are not listed in Goods No.1 2 Sheet should go to Other Goods Tab sheet with Goods Code. It would be great help if any help out on this. Thanks Puttu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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: pdf converter software code needed (able2extract)
hi anil this is not a excel file its a software to convert files able2extract professional version u can download that on from internet Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Feb 26, 2010 at 12:04 PM, anil panchal anil.kan...@gmail.com wrote: Share With Exe File Please Regards Anil Kumar On Fri, Feb 26, 2010 at 12:02 PM, ankur ankurpande...@gmail.com wrote: ya sure this is the code 127418901528 Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Feb 26, 2010 at 11:43 AM, Harshad K harshadpl...@gmail.com wrote: can you share with me regards harshad On Fri, Feb 26, 2010 at 12:21 PM, ankur ankurpande...@gmail.com wrote: i got the code thnks Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Tue, Feb 23, 2010 at 4:02 PM, ankur ankurpande...@gmail.com wrote: hi experts, i had one pdf file converter pdf to different type of file like word, excel etc, i got that software from this group software name is able2extract somebody had mail the code also i lost that mail and code can anybody send me code again it will be very helpful to me 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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
Re: $$Excel-Macros$$ Need help for macro- changing cell value
See attached. On Thu, Feb 25, 2010 at 7:06 AM, Mahesh parab mahes...@gmail.com wrote: Dear All I need macro for when i open workbook, A1 cell value, will display 1 to 4 numbers one by one, time interval should be 15sec. i want this to create animation effects in pie chart, cell A1 is link with data by Hlookup, so when value in A1 change it will change pie chart also. 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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 DelayedUpdateOnOpen.xlsm Description: Binary data
Re: $$Excel-Macros$$ pls help - Vertical to Horizontal
You might also look up 'loan amortization' in online templates in Microsoft Office. The formulas are all built in so you can study them. On Thu, Feb 25, 2010 at 9:59 PM, ankur ankurpande...@gmail.com wrote: hi umesh for learning vba , u can download books from our file section Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Tue, Feb 16, 2010 at 4:45 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: Please find attached solution. Regards, C.G.Kumar *From:* excel-macros@googlegroups.com [mailto: excel-mac...@googlegroups.com] *On Behalf Of *Umesh Matkar *Sent:* 12/February/2010 10:01 AM *To:* excel-macros@googlegroups.com *Cc:* dilipan...@gmail.com *Subject:* $$Excel-Macros$$ pls help - Vertical to Horizontal *Importance:* High I have given here example file and contents . We want interest calculation on Avg Monthly Balance Interest Rate 8.50% P.A Eg First Step (Opeining Balance + April)+ May)+Jun)….. Till Mar Then (Total of interest /12*8.50% pls help…suggest any formula or macro for this work I have 25000 Rows in my original file Pls help…..excel guru’s Thanx Umesh matkar -- -- 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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: remove empty cells (rows) between two cells
See attached for example. On Thu, Feb 25, 2010 at 9:44 PM, Ayush jainayus...@gmail.com wrote: Hi Markkim, Would you please send the sample file containing this data? Best regards, Ayush Jain On Feb 26, 6:18 am, Markkim mark@gmail.com wrote: Hi I have been trying to make these but have failed. ^ ^;; I’d like to create a macro A21 has a word called ‘Date’ And somewhere down in column A has a cell with a word ‘FBT Details’. The location of FBT details depends on the amount of data between these two headings. I’d like to remove any blank rows between A21 and location of FBT details – 7. What I mean is For example, location of FBT details is A1207. Then I’d like to remove any empty rows (cells) between A21 and A1200 (not A1207). so 7 rows above. I’d like to do this because the data between these cells are one row apart. Could you help me please? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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 ExcelMacros_DeleteBlanks.xlsm Description: Binary data
Re: $$Excel-Macros$$ Converting .xlsm to .xls
Click on start download After executing the following link http://www.microsoft.com/downloads/en/confirmation.aspx?familyId=941b3470-3ae9-4aee-8f43-c6bb74cd1466displayLang=en Microsoft by default have a problem to work from higher virson to lower version. such example is installing win 98 after win XP. Hope It will help. :) Immer zielen auf die vollkommene Harmonie des Denkens Wort deed.Always zielen darauf ab, reinigen Sie Ihre Meinung und alles wird gut. Always aim at complete harmony of thought word deed.Always aim at purifying your thoughts everything will be well. On Fri, Feb 26, 2010 at 11:50 AM, ankur ankurpande...@gmail.com wrote: yes, there is no problem with pirated software Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Tue, Feb 9, 2010 at 11:51 PM, Harpreet Singh Gujral harpreetguj...@gmail.com wrote: Hi, Will this work on pirated software Just need to check Before i install. Harpreet On Feb 7, 8:58 am, Yahya yahya...@gmail.com wrote: Dear Harpeet You can download Microsoft Office Compatibility Pack from the below link: http://office.microsoft.com/en-us/products/HA101686761033.aspx Regards Yahya On Sat, Feb 6, 2010 at 9:19 PM, Harpreet Singh Gujral harpreetguj...@gmail.com wrote: Hi Dilip, This is something which i am looking for. I am already known of the fact that we can save the workbook in excel 2003 format if we desire to, from office 2007. I am talking about a scenario where the user has office 2003 installed, and faces a problem to open a workbook recieved ina office 2007 format. This could be a scenario with nebdy. The question is where can i get the compatibility pack which you have written about? Is there any other free converter available, which a user can install on his/her system to have this problem resolved. Thanks in advance Harpreet Gujral On Feb 6, 3:02 pm, Dilip Pandey dilipan...@gmail.com wrote: Dear Harpreet, Alternatively, you can search and install Compatibility pack of Office 2007. After the installation, whenever you'll open Office 2007 file in Office 2003, the file would automatically convert and open in Office 2003. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 2/6/10, Harpreet Singh Gujral harpreetguj...@gmail.com wrote: Hi Group, I work on Office 2003, and it becomes a problem to work on a xls made in office 2007. Any ideas to convert into office 2003. Please suggest Harpreet Gujral -- ------ 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 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 at http://groups.google.com/group/excel-macros/subscribe -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India- Hide quoted text - - Show quoted text - -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://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
Re: $$Excel-Macros$$ How to select unique values from a list and copy each unique value to another location of another worksheet
hi OSAVentures Calamba check this link http://blogs.techrepublic.com.com/howdoi/?p=111 VBA, the automated way First, create two ranges: the list’s source data and a target range for the unique list. Select the source data; in this case, that’s cells A2:A18. From the Insert menu, choose Name and then select Define. Excel will automatically assume the content of A1, the string OrderID, as the name. Click OK. Next, select cell H1 and name it UniqueList using the same process. Next, you need a user form and a combo box. Press Alt+F11 to launch the Visual Basic Editor (VBE). From the Insert menu, choose UserForm. If necessary, click the Toolbox button to launch the Toolbox and drag a combo box control to the user form. Name the combo box control cboUniqueList. Save the user form as UserForm1. Now, you’re ready to enter the code that automates the list. Choose Module from the Insert menu. Then, enter the function in Listing A. This function creates a unique list from the data in the OrderID named range, populates cboUniqueList with that list, displays UserForm1, and then deletes the unique list from the sheet. Listing A Function UniqueList() 'Populate control with 'unique list. Range(OrderID).AdvancedFilter Action:=xlFilterCopy, _ CopyToRange:=Range(UniqueList), Unique:=True 'Set combo control's Row Source property. Range(UniqueList).Activate UserForm1.cboUniqueList.RowSource = Selection.CurrentRegion.Address 'Display user form. UserForm1.Show Selection.CurrentRegion.Clear End Function -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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$$ Cell Formating
format the cells of whole sheet in general format... if still problem check this link http://www.brighthub.com/computing/windows-platform/articles/27366.aspx Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Feb 26, 2010 at 2:20 PM, Sachin Shukla sachina...@gmail.com wrote: Dear All, If I put a data on sheet say in cell A1 I put 45 number, cell automatic convert in Date formate . How I remove this problem to my entire work book and sheet. I use Excel 2007 Thanks Sachin Shukla -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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$$ Cell Formating
Dear Mr. Pandey, It's happen even I open new sheet. I thiks somewhere problem in setting. What's your suggestion?. Thanks Sachin Shukla On Fri, Feb 26, 2010 at 2:53 PM, ankur ankurpande...@gmail.com wrote: format the cells of whole sheet in general format... if still problem check this link http://www.brighthub.com/computing/windows-platform/articles/27366.aspx Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Feb 26, 2010 at 2:20 PM, Sachin Shukla sachina...@gmail.com wrote: Dear All, If I put a data on sheet say in cell A1 I put 45 number, cell automatic convert in Date formate . How I remove this problem to my entire work book and sheet. I use Excel 2007 Thanks Sachin Shukla -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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$$ Cell Formating
hit CTRL + SHIFT + ~KEY... Regards, Viral Pandya On Fri, Feb 26, 2010 at 2:53 PM, ankur ankurpande...@gmail.com wrote: format the cells of whole sheet in general format... if still problem check this link http://www.brighthub.com/computing/windows-platform/articles/27366.aspx Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Feb 26, 2010 at 2:20 PM, Sachin Shukla sachina...@gmail.com wrote: Dear All, If I put a data on sheet say in cell A1 I put 45 number, cell automatic convert in Date formate . How I remove this problem to my entire work book and sheet. I use Excel 2007 Thanks Sachin Shukla -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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$$ PLEASE HELP
Hi Dear all, Please help me for below formula. 1. how to convert numbers in text. 2. Example 2000Two thousands when i m change the number the text changed automatically. -- Sudhir Verma Asstt. Mngr. A/c's 9211219649 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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$$ PLEASE HELP
hi sudhir check this addin and use formula =num2text(a1) a1 is cell having number Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Feb 26, 2010 at 4:11 PM, sudhir kumar bluecore...@gmail.com wrote: Hi Dear all, Please help me for below formula. 1. how to convert numbers in text. 2. Example 2000 Two thousands when i m change the number the text changed automatically. -- Sudhir Verma Asstt. Mngr. A/c's 9211219649 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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 num2text.xla Description: Binary data
$$Excel-Macros$$ Please guide me to save time.
Hello Frnds, I am using 2007 excel. My file size is 21 MB. I used *sumifs formulas*extensively in each sheet(total 25 sheets). My problem is whenever I open the file or close or calculate or save it takes much time say 20 min. Would like to make my workbook faster. Could you please guide me. I have some idea like: Shall I use sumproduct instead of sumifs - sumproduct is faster than sumifs?? shall I use Pivot table and get pivot formula to get data. or any other ways. Please guide me. Regards, Vinu. -- Regards Vinod Kumar Bangalore +91-9986423819 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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$$ CENTRAL EXCISE REGISTERS
I am looking for Central Excise Registers, like RG-23A Part-!, II, RG-1 Registers in excel .If anybody have please post Thanks in advance -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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$$ Need procedure to allow VBA code by users during runt-time?
For various reasons a user-defined function of mine needs to allow
user input that is interpreted as executable code (in this case any
excel expression).
The most straight forward approach would be for the function procedure
to input code into a module active in the same excel session and
subsequently run the code (ie call a sub to which the user-input code
was written); however, there are two problems with this:
A. Most importantly is a very weird problem with how excel access user-
defined functions in VBA modules. If a function procedure makes ANY
change to ANY module active in the same session, excel 'loses' the
relationship of all the other user-defined functions in the same
module.
The problem is best described by doing it:
0. Open a new session of excel
1. in VBA, add a module to Book1
2. In the new module, write a inoccuous function as the 'control' of
the experiment:
Function innocuous()
innocuous = innocuous
End Function
3. in excel, Input =innocuous() in cells A1 and B1 of Book1
(the function returns the string 'innocuous' in each cell; this is
just a control for later steps)
4. Now input the following code in module1:
Function MyCodeInput(InputUserCode)
Application.VBE.VBProjects(VBAProject).VBComponents(Module1).CodeModule.ReplaceLine
_
Application.VBE.VBProjects(VBAProject).VBComponents(Module1). _
CodeModule.ProcBodyLine(RunUserCode, vbext_pk_Proc) + 1,
_
RunUserCode = InputUserCode
MyCodeInput = RunUserCode()
End Function
Function RunUserCode()
RunUserCode = not input yet
End Function
NB: the inputs VBAProject and Module1 assume you have not changed
the default names for the new project and module you created in step 1
The Function MyCodeInput access the code object of VBA and overwrites
the first line of code in the procedure 'RunUserCode'
5. In excel, input =MyCodeInput(2) in cell A2
During returning input into cell A2, the function writes code in
RunUserCode to get it to return the user input
('2' in this case) and subsequently runs RunUserCode to get the
value it is to return to cell A2 (2)
!!You will see that the functions in cell A1 and B1 immediately
return #NAME?
(assuming you have calc set to automatic - otherwise you will have
to press {F9})
6. Still in excel, input =MyCodeInput(3) in cell A3
The function returns 3 in cell A3 BUT
!!You will see that the entry in cell A1, B1 and A2 immediately
return #NAME?
7. Go back to A2 and reinput =MyCodeInput(2)
The function returns 2 in cell A2 BUT
!!You will see that the entry in cell A1, B1 and A3 immediately
return #NAME?
My interpretation: whenever a procedure writes code to ANY active
module in an excell session, excel 'loses' its access to ALL modules
(the above example doesn't prove this for all modules but further test
you can think of for yourselves will bear this out).
The particular occurence of a function in a cell gets recalculated
upon input, but if the function writes code, then ALL other cells
containing user-defined functions will revert to returning #NAME? as
though the functions are not defined in any active modules.
As long as the other cells are returning #NAME?, excel does not even
bother to try to run the function they contain, so that subsequent
recalcs fail to renew excel's access to the functions. The only way to
get the function in such cells to calculate is to re-enter it in one
of the cells, but then all the other cells containing user-defined
functions once again rever to returning #NAME?
B. Problem A is a pretty major problem with coding any function to
write code during execution! However, if the user inputs text that is
not syntactically correct (say s/he enteres 2/ rather than 2), an
untrappable syntax error results and the user is suddenly confronted
with a line in the code pane of the VB window. This is a further
problem.
An alternative would be to input the text to be run as code as the
formula property of a cell reserved for vb use
and take the value of this cell as Func1's return value (giving
nonexecutable text for the formulat property of a cell would then
result in a trappable error from Excel). Of course, only code that can
be interpreted as excel expressions can be 'run' this way but this
fulfills my particular needs for the function in question; however,
during excel calculation cells are nonaccessable so this is no option
for a function.
Another alternative would be to have an separate instance of excel
running at all times, watching to see if a file with a certain name
gets written. MyCodeInput would then not write input code to a
procedure, but to a file of this name, and then wait until this file
ceases to exist.
The other session of excel would read the code immediately upon seeing
the file exists, input the code into the formula property of a cell
(this would be no problem in the other session as a function would not
be in the process of being input in this session),
Re: $$Excel-Macros$$ Excel Formulas
Hi Putta, Attached is updated sheet with formulas. As I have already helped you earlier on same formulas, Please give a try before you send request to group going forward. This group is not formed to get your work done but to get technical assistance only. I hope you understand. Best regards, Ayush Jain Group Owner. On Fri, Feb 26, 2010 at 7:59 PM, Putta Madaiah puttamada...@gmail.comwrote: Hi Ayush, I need another favour from you. Please check the attached sheet and provide me the formulas as required in the table. Rgds- Madaiah, Bangalore On Fri, Feb 5, 2010 at 8:47 PM, ayush jain jainayus...@gmail.com wrote: Hi Madajah, Attached is the updated solution with the new condition. Best regards, Ayush Jain Group Owner On Fri, Feb 5, 2010 at 5:43 PM, Putta Madaiah puttamada...@gmail.comwrote: Hi Ayush, Thanks for the formulas. It will be great also if you can consider only for N under column 'Doc Type'. Regards- Madaiah On Thu, Feb 4, 2010 at 8:19 PM, ayush jain jainayus...@gmail.comwrote: Hi Madaiah, Attached is the solution for you. I have used countifs formula for the solution. Let us know if any further assistance is required. Best regards, Ayush Jain On Thu, Feb 4, 2010 at 6:42 PM, Putta Madaiah puttamada...@gmail.comwrote: Hi Group, Can anyone help me with the excel formulas for the fields coloured in yellow in the attached file. With Best Regards, Madaiah- Bangalore -- -- 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 -- Best regards, Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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 Putta_Prob.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Re: Application.commandbars
Dear Harpreet, Try below link:- http://www.ozgrid.com/VBA/custom-menus.htm -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 2/26/10, Harpreet Gujral harpreetguj...@gmail.com wrote: Dilip, I tried searching on the net for the codes, but was not as successfull as I thought I would be. If you can help me, can you provide me a link or a source which clearly states: 1) How to use this code? 2) How to make use of its sub properties. Eg: position (this is where more information is reqd) 3) Can you give me a sample code where I can create a menu bar, with a menu item and sub menu item. I.E I am looking for 3 levels of menu on a single menu. I hope I was able to explain my need. Thanks mate Harpreet Sent on my BlackBerry® from Vodafone Essar -- *From: *Dilip Pandey dilipan...@gmail.com *Date: *Thu, 25 Feb 2010 23:30:20 +0530 *To: *excel-macros@googlegroups.com *Cc: *harpreetguj...@gmail.com *Subject: *Re: $$Excel-Macros$$ Re: Application.commandbars Dear Harpreet, I believe this is something related to menu creation using Excel-VBA. Try searching internet with changed string and you'll get many reasonable responses. :) Let me know if you need a sample code to create a menu button. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 2/24/10, Harpreet Singh Gujral harpreetguj...@gmail.com wrote: Does anybody have access to complete information on Commandbars, and all its properties. Please forward it to me Thanks Harpreet Gujral On Feb 21, 7:56 pm, Harpreet Singh Gujral harpreetguj...@gmail.com wrote: Hi, Can someboday help me with the commandbars? I am looking forward to create a custom commandbar with the help of VBA. Can you please suggest a source to understand what all sub properties that we need to specify to make the commandbar. Like position etc etc. Thanks Harpreet Gujral -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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$$ Please guide me to save time.
Hi, Not sure if sumproduct is faster than sumifs. But it may be that much of your data is historical (past months or years) and doesn't update any more. All non-updating cells that contain formulas, could be replaced with just their numerical data. Since your workbook is large, you could write VBA code to help you do this. The simplest would be: Sub FormulaToNumber ActiveCell = ActiveCell.Value End Sub Then give it a shortcut key like Ctrl+q, and just go through cell by cell pressing Ctrl+q But if there's thousands of these, you'd have to get a bit fancier. Regards - Dave. Date: Fri, 26 Feb 2010 18:20:50 +0530 Subject: $$Excel-Macros$$ Please guide me to save time. From: vinu1sm...@gmail.com To: excel-macros@googlegroups.com Hello Frnds, I am using 2007 excel. My file size is 21 MB. I used sumifs formulas extensively in each sheet(total 25 sheets). My problem is whenever I open the file or close or calculate or save it takes much time say 20 min. Would like to make my workbook faster. Could you please guide me. I have some idea like: Shall I use sumproduct instead of sumifs - sumproduct is faster than sumifs?? shall I use Pivot table and get pivot formula to get data. or any other ways. Please guide me. Regards, Vinu. -- Regards Vinod Kumar Bangalore +91-9986423819 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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 _ If it exists, you'll find it on SEEK. Australia's #1 job site http://clk.atdmt.com/NMN/go/157639755/direct/01/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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$$ Dependent drop down lists
hi hanum plz attach a sample file so it will more easy for us to help u Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Sat, Feb 27, 2010 at 5:01 AM, Hanum harsha...@gmail.com wrote: Both the solutions are not what I am looking for...what I am looking for is my exampleI think it is very clear. Unlike these solutions, mine are always one-to-one relationship. On Feb 24, 12:29 am, santosh bahuguna santoshbahug...@gmail.com wrote: Create Multiple Range of you data Let suppose we Have A C A D A E B F B G B H Give the Name A1:A6 MAIN SOURCE GIVE Name the B1:B3 as A GIVE Name the B4:B6 as B select the Column where you want to show main SOURCE and in sub menu Give Formula of =Indirect(Range of the data in bases of you want to display LIke A or B) Regards Santosh Bahuguna On Tue, Feb 23, 2010 at 10:12 PM, Vinod N nvino...@gmail.com wrote: Hi Hanum, Please find attached the Solution provided by one of the Gurus for a query similar to the one posted by you... Use the attached.. in the meantime, Gurus will provide you with exact solution if possible send us a sample file for exact query... Vinod On Tue, Feb 23, 2010 at 11:28 PM, Hanum harsha...@gmail.com wrote: I have a unique problem that I need your help. Here it is: There is a list of some numbers and names associated with each of the numbers. There are two drop down lists for a user to pick from - one drop down for the numbers and another for the names. When a user selects a particular number from the number drop down, I want the the name drop down to show the correspsonding name. That's not all - when the user selects a particular name from the name drop down, the number drop down to show the correspsonding number. Here's an example: 01,.,15 are in drop down A, and Arizona,,Virginia are in drop down B. When I select 05 from drop down A, the drop down B should update to New Mexico. Next, if I go to drop down B and change the current value 'New Mexico' to say 'Virginia', drop down A should change to 15. 01 Arizona 03 California 05 New Mexico 10 New York 15 Virginia Please help. -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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 -- Thanks and Regards Vinod N -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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 :
