Fw: $$Excel-Macros$$ Help required
Hi Guys can anyone help me on this please Thanks Prasad Sent from BlackBerry® on Airtel -Original Message- From: Mr Excellent suryaprasad...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 13 Oct 2011 04:52:12 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help required Hi Group, Need a small help, i have a code which runs on the data and seggregates the details as per the Country, but additional to that i require the Country name should come on the top of each rows which are divided by country in the first column and the heading should be applicable to all the seggregated rows as per the country and should be bold and underlined. The example data is given in the first TAB Tes My Code example data is given in the second TAB My Code Actual required data is given in third TAB Actual Required Please help Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Test.xlsm Description: Binary data
Re: $$Excel-Macros$$ Connect 2 sheets .....
Yes apart from this thanks a ton to Ayush for his continous support... U rock ayush Sent from BlackBerry® on Airtel -Original Message- From: shashank bhosle catchshashankbho...@yahoo.co.in Sender: excel-macros@googlegroups.com Date: Wed, 5 Oct 2011 11:17:30 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Connect 2 sheets . Hello Dguillett, Momin Siraj Ahmed, Thank you very very much for giving your valuable time to solve my querry.I can't express my self to thank to you. you guys are so talented, even i feel like solving the querries, but i dont have such a knowledge as you people have. One more request to you that i need to make a separate dossier for each student that is appx 125 students . I need to make a separate profile for each student so i have to make a one workbook for one student which willincluded 7-8 sheet showing their different performance record. And as i will have more than 100 sheets i have to give them a name which i can easy find their respective name. So i had named their sheets as ASE Dossier_RAM. Please help me guys and please tell me how you learned to write the macros?? please . From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Tuesday, 4 October 2011 7:20 PM Subject: Re: $$Excel-Macros$$ Connect 2 sheets . The attached will do as desired to make a sheet for each student. I see no reason to make a file for each. I also did a print setup. Option Explicit Sub makesheetforeachSAS() Dim c As Range Application.ScreenUpdating = False For Each c In Range(a2:a Cells(Rows.Count, 1).End(xlUp).Row) Sheets(Template).Copy after:=Sheets(Database) ActiveSheet.Name = c c.Offset(, 1).Resize(, 10).Copy Range(d3).PasteSpecial Paste:=xlPasteValues, _ Operation:=xlNone, SkipBlanks:=False, Transpose:=True Range(a1).Value = c Next c Application.CutCopyMode = False Application.ScreenUpdating = True End Sub From: shashank bhosle Sent: Tuesday, October 04, 2011 1:28 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Connect 2 sheets . Dear Friends, I have two files 1. ASE Dossier_RAM 2. ASE Dossier_SHAM 2. Database I want to extract the information of every student e.g Ram from database and make a separate sheet of Dossier of every Student. In Database the information is according to Columns. When pasting it into Dossier file I want it to be transposed. I have more than 100 student and needs to make their different spread sheet of and Name it accordingly as per their name. I am trying but I am not getting accurate results Please suggest some macros. can it be automated for rest of the students? Please help 2 manual spreadsheets are attached as example for your reference Regards Shank 9422927499 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3.
Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari
Hip Hip Hurry.. For sure you deserve that NOORAIN u rock dear ...keep rocking way to go in this group Thanks Surya Sent from BlackBerry® on Airtel -Original Message- From: Ayush Jain jainayus...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 2 Oct 2011 00:43:24 To: excel-macrosexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc: NOORAIN ANSARInoorain.ans...@gmail.com Subject: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari Hello Everyone, Noorain Ansari has been selected as 'Most Helpful Member' for the month of Sept'11 He has posted 140 posts in sept 2011 and helped many people through his expertise. He has been consistent contributor to this excel forum but has acheived this recognition for first time. *About Noorain Ansari :* [image: noorain.jpg] Noorain is a great poet and keep sharing his thoughts on different topics throgh cool poems. Professionally, he is a Excel aficionado and presently working as senior business analyst in One97 Communication Ltd. He is a MS excel - vba expert and keep sharing his thoughts with this forum. You can follow his blogs for Excel knowledge and cool poems : www.excel-macro.blogspot.com www.noorain-ansari.blogspot.com *Noorain, Many thanks for all your great support to group. Keep it up* *Thanks to Don Guillett, Bheema, Venkat, GoldenLance, Ashish Koul, XLS S , Paul and other folks for helping excel enthusiasts voluntarily !! Keep it up !! *Keep posting. Regards Ayush Jain Group Manager -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel noorain.jpg
Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes
Hi Noorain, Please help Thanks Prasad Sent from BlackBerry® on Airtel -Original Message- From: Mr Excellent suryaprasad...@gmail.com Date: Mon, 5 Sep 2011 17:10:47 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes Hi Noorain, This helped me a lot but there is a single case in the code, how to add many cases if the select any other country and opt for other check boxes, please refer to the attachment Please help Thanks Prasad. On Mon, Sep 5, 2011 at 8:34 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Surya, Please see attached sheet if it help.. On Mon, Sep 5, 2011 at 7:06 AM, Mr Excellent suryaprasad...@gmail.comwrote: Hi Group, Need a small help, i have a combo box in the form and when i click on particular name INDIA one of the list box which says Indian currency to be updated should be enabled and the other list box should be disabled and vice versa as well, please help. Thanks, Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Fw: $$Excel-Macros$$ Need a help in Combo and Check Boxes
Hi all, Can anyone help me on this?? Regards Prasad Sent from BlackBerry® on Airtel -Original Message- From: Mr Excellent suryaprasad...@gmail.com Date: Mon, 5 Sep 2011 17:10:47 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes Hi Noorain, This helped me a lot but there is a single case in the code, how to add many cases if the select any other country and opt for other check boxes, please refer to the attachment Please help Thanks Prasad. On Mon, Sep 5, 2011 at 8:34 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Surya, Please see attached sheet if it help.. On Mon, Sep 5, 2011 at 7:06 AM, Mr Excellent suryaprasad...@gmail.comwrote: Hi Group, Need a small help, i have a combo box in the form and when i click on particular name INDIA one of the list box which says Indian currency to be updated should be enabled and the other list box should be disabled and vice versa as well, please help. Thanks, Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Currency(1).xlsm Description: Binary data
Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11
Congratulations BRO u rock :-) Sent from BlackBerry® on Airtel -Original Message- From: Venkat CV venkat1@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 6 Sep 2011 10:43:07 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11 Congratulations Rajan Verma , Sunny, Noorain, Don Guillett, and Everyone... *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Mon, Sep 5, 2011 at 10:59 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of August'11 He has posted 152 posts in August 2011 and helped many people through his expertise. He has been consistent contributor to this excel forum and has acheived this recognition for second time consecutively. Thanks to Noorain, Venkat, Sunny(XLS S), Don Guillett, and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ **Pivot Table Doubt**
Can you post the pivoted file plz ? Thanks Prasad Sent from BlackBerry® on Airtel -Original Message- From: Prabhu prabhugate...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 31 Aug 2011 12:28:10 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ **Pivot Table Doubt** Hi Friends, When i double click my Pivot table value a new sheet is appearing with the details. But all the amount columns are showing in date format. Can anybody help how to rectify the same.(value should show in Number format and date should be in date format) Plz help. Regards, Prabhu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ User form
Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel New Microsoft Office Excel Worksheet (2).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ User form
Hi , Please see my excel spread sheet i need the userform as POP see the chail mail Thanks Prasad On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 dguille...@gmail.com wrote: What userform? Put this in the ThisWorkbook module Private Sub Workbook_Open() nameofyouruserformhere.Show End Sub *From:* Suryaprasad suryaprasad...@gmail.com *Sent:* Tuesday, August 30, 2011 7:42 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ User form Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ User form
Hi Venkat, Sorry for the wrong attachment, here is the updated one. What i need is when i open the spread sheet the form should POP automatically. Thanks Prasad. On Tue, Aug 30, 2011 at 7:36 PM, Venkat CV venkat1@gmail.com wrote: Hi Surya, Your excel sheet is empty..Please check.. *Best Regards,* *Venkat * *Chennai* * * * * On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad suryaprasad...@gmail.comwrote: Hi , Please see my excel spread sheet i need the userform as POP see the chail mail Thanks Prasad On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 dguille...@gmail.comwrote: What userform? Put this in the ThisWorkbook module Private Sub Workbook_Open() nameofyouruserformhere.Show End Sub *From:* Suryaprasad suryaprasad...@gmail.com *Sent:* Tuesday, August 30, 2011 7:42 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ User form Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel User.xlsm Description: Binary data
$$Excel-Macros$$ How to load data into Combo box in user form
Hi All, Attached is the sheet where i need the list of the countries to be added to the combo box Note : The Combo box should be enabled once the data is entered in Text Box given above of Combo box. Please do the needfull. Thanks Prasad -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Combo.xlsm Description: Binary data
Re: $$Excel-Macros$$ Need help in maro
Hi Ashish, I am getting an error while running the code which was given below could you please send me the worked attchment plz Thanks Prasad Sent from BlackBerry® on Airtel -Original Message- From: ashish koul koul.ash...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 23 Aug 2011 11:35:59 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help in maro add this macro to each box Sub test() Application.DisplayAlerts = False Application.ScreenUpdating = False ' method 1 in this u have to change the shape names as per the sheet names 'For i = 2 To Sheets.Count 'Sheets(i).Visible = True 'If Sheets(i).Name Application.Caller Then ' 'Sheets(i).Visible = False ' 'End If ' 'Next ' method 2 For i = 2 To Sheets.Count Sheets(i).Visible = True If Sheets(i).Name ActiveSheet.Shapes(Application.Caller).TextFrame.Characters.Text Then Sheets(i).Visible = False End If Next Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub On Tue, Aug 23, 2011 at 10:56 AM, Suryaprasad suryaprasad...@gmail.comwrote: Hi All, I was trying to write a macro which is not working well, attached is the sheet where is require a small code the below is the what i require: I have a main sheet which is assgined with controls and i have 5 TABS , what i want is when i click on the first control named with Sheet1 in the main TAB then the sheet1 should open automatically and the rest of the 4 TAB's should be hidden and the same logic should be applicable for all the other controls , please help Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Need a Help in Macro
Hi Rajan, Thanks for the Macro, but i need somethig like this : I have 5 TAB's in the first TAB named with Sheet1 i have Control as Sheet2 the point here is once i work on my sheet1 then i need to go to Sheet2 so i have placed a control as sheet2 (something like hyperlink)and once i click on sheet2 control the sheet1 should be automatically hidden and sheet2 should be active and it has the control of Sheet3, and again the if i click on sheet3 control then sheet2 should be hidden and sheet3 should be active , similalrly the same activity should happen till sheet5 which will again bring to sheet1 please refer to the attachment which i have sent. Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Design_1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Need help in maro
Hi All, I was trying to write a macro which is not working well, attached is the sheet where is require a small code the below is the what i require: I have a main sheet which is assgined with controls and i have 5 TABS , what i want is when i click on the first control named with Sheet1 in the main TAB then the sheet1 should open automatically and the rest of the 4 TAB's should be hidden and the same logic should be applicable for all the other controls , please help Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Design.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Valuable Info
Hi, Register on the below link (FETISE) and get a instant 500/- rs off on any purchase of the product ..its really good and once after registered please refer to your friends and get paid and own your gifts. http://www.fetise.com/men/register2.php?refcode=81TJ5KG0G3 Thank you Surya -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Fwd: $$Excel-Macros$$ Generate random numbers based on number given in a cell
Hi Ayush, Can you please help on the below Thanks prasad -- Forwarded message -- From: Suryaprasad suryaprasad...@gmail.com Date: Sun, May 29, 2011 at 7:59 AM Subject: $$Excel-Macros$$ Generate random numbers based on number given in a cell To: excel-macros@googlegroups.com Hi Experts, Need a formula or a code for the sample sheet Attached, this is about the generating a random based numbers given in spread sheet Thanks Prasad -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Test.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Generate random numbers based on number given in a cell
Hi Experts, Need a formula or a code for the sample sheet Attached, this is about the generating a random based numbers given in spread sheet Thanks Prasad -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Test.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Countif Problem
Hi Team / Ayush, Need a formula about a countif criteria See the attachment and please do the need full Regards prasad -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Example.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Problem in excel
Here you go with pivot..! On Sun, Jan 30, 2011 at 1:55 PM, Jitender kumar jk9779771...@gmail.comwrote: Dear Sir I have problem with excel file.Please provide the solution.(See attachment) Regards Jitender -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Pivot.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Our NEW Microsoft MVP - Dilip Kumar Pandey
Congrats Dilip On Tue, Jan 4, 2011 at 7:37 PM, sharad gupta sharadgupta2...@gmail.comwrote: Hi Dilip Sir, Congratulations to you . That is good news on new year 2011. sharad gupta On Mon, Jan 3, 2011 at 7:32 PM, Manoj kumar manoj.vishwakarma...@gmail.com wrote: Congrats Dilip... Best Regards, Manoj Kumar On Mon, Jan 3, 2011 at 8:50 AM, ashish koul koul.ash...@gmail.comwrote: congrats dilip On Mon, Jan 3, 2011 at 4:48 PM, vidyut more vidyutm...@gmail.comwrote: hi Dilip ji Congratulations to you and Hatsoff u On Mon, Jan 3, 2011 at 3:35 PM, bhavya khanna bhavya...@gmail.comwrote: Hi Dilip Sir, Congratulations to you . That is good news on new year 2011. and where is treat ? On Mon, Jan 3, 2011 at 3:31 PM, Ayush jainayus...@gmail.com wrote: Dear Group, I am very very very very happy to share a good news with you. One of our dearest group member Dilip Kumar Pandey is awarded Microsoft MVP award on 1st January for his exceptional Excel skills and voluntary contribution. He is well deserving for the award and I am very happy about his recognition. Dear Dilip, Many Many congratulations, Keep it up. I am very proud of you to be part of this group. I wish your long association with this group. Best Regards, Ayush Jain Microsoft MVP-2010 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts --
Re: $$Excel-Macros$$ Is it a Challenge!!!!!
As you are aware that lots of emails cannot be tracked and replied soon it doesnot mean that is a challenge..! On Fri, Dec 17, 2010 at 10:27 AM, Deepak Rawat deepakexce...@gmail.comwrote: Hi i have posted this problem two times but got no reply Is it a challenge!!! Dear All I am designing a user form but new to this, so i need help on prgramming. The logic i am mentioning here as under: Threre are 2 comboBoxes, one calender, and amount file. What i want 1. Which date i would select that should show in Label4 2. First i would select an Type from ComboBox1(cboType) 3. Then there should items should come in second ComboBox(cboItem) 4. Then user will fill the amount and then enter 5. Finally all the data should be entered in the excel sheet as i press Enter For Example I would select in first ComboBox(cboType) Milk then there should come automatically some items like Full Cream Milk, Poly Pack in the in second combobox(cboItem) and finally all the data should be entered in the excel sheet as the user press Enter File is attached!! Regards, Deepak Rawat -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Ctrl + space bar
When you are facing such a prblm then y cant u disable the VBA option? On Wed, Aug 4, 2010 at 10:43 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi, I never use Ctrl+Space. Didn't know about it. When the list of names appears, just select the one you want by double-clicking on it Regards - Dave. Date: Tue, 3 Aug 2010 15:49:18 -0700 Subject: $$Excel-Macros$$ Ctrl + space bar From: moor...@ldschurch.org To: excel-macros@googlegroups.com CC: moor...@ldschurch.org I am in the very infancy of learning VBA and a couple of sources that I am using to learn it both refer to the Visual Basic IDE which provides an auto-complete feature for all the names used in Excel VBA. I am told to type only the first few characters to get the name I want and then press Ctrl+Spacebar to activate the auto-complete list of all names that begin with those characters. However, I have a problem. When I try this and press Ctrl+Spacebar I get connected to Google. Some programer, somewhere in my large organization has apparently absconded Ctrl+Spacebar to directly connect with Google. That being the case how can I find a way to set up my one short-cut to connect with the VBA auto-complete feature? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 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$$ Congratulations : We are 7000 today
Hey, Thats wonderfull. Ayush, You are the best. Thanks Surya On Mon, May 24, 2010 at 9:00 AM, Ayush jainayus...@gmail.com wrote: Dear Group Members, Finally, after long time we have achieved a milestone of 7000 members. I would use this moment to thank each one of you for your contribution to the group. This group really helps people on all of their queries on excel and macros. Thanks to all query solvers.you really make a difference in group Keep posting !! Best regards, Ayush Jain Group Manager -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 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$$ Understanding Implementation
Hi All, To my observations from the past, we have been 99 % sucessfull in answering all the replies, but with some delays as some of us asking for a attachment few of us asking to clarify the question again, my understanding of correct procedure to help in one single short way would be below. 1. All of the group members should attach sample files of xls or xlxs for the correct output. 2. A Postage of Snap shot of the output required would be helpfull ( .Jpg file) 3. Questions should be step by step - In a Hirarachy Ayush, I request your advice in this. Cheers Surya -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com 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$$ Urgent Help
Hey Sudhir, No need of a Look upOnly thing u can do a formulae for Transpose is required..please find the attachement. Surya On Tue, Apr 6, 2010 at 7:44 PM, sudhir kumar bluecore...@gmail.com wrote: *Hi friends* ** *Please help me urgent* *problem of Hlookup formula in attached file. * -- 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 To unsubscribe, reply using remove me as the subject. Help.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Macro
Hi Sreejith, Can we have a Sample File for our reference. Thanks Surya On Tue, Mar 23, 2010 at 6:05 PM, sreejith k.s sreejith.ks1...@gmail.comwrote: Hi Guys, I need help from you guys, I have 18 files in which 9 files come in same category and the rest in another category say Set 1 and Set 2. Set 1 contains file'sin which naming is something like this ; *Period_Country Name* and Set 2 file naming is like *Info_Country* *Name*.Both files have only one sheet in them. I need a macro which will see the country name from Set1 and select the file from Set 2 with same country name and then copy the sheet from that file and paste the sheet as another sheet in the file in Set 1. please help guys, i am not great with macros. -- -- 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 To unsubscribe from this group, send email to excel-macros+ unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. -- -- 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 To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
$$Excel-Macros$$ Tip of the Day for 11th June 09
Hi All, Folks thanks for the wonderfull support for getting out with good postings and tips hope all will continue in the same fashion and keep this environment alive. *Question:* *If you have comments in a scrumbled all over the spread sheet ( Not in order) but you want to delete the comments .It might take a heavy time to select each cell and delete the comment but i have a solution here.* *Tip:* *Press Ctrl + Shift + Letter O then it will select all the scrumbled comments which are placed in the spread sheet then right click it delete, it may be a simple tip but very usefull to a person who might face this problem.* Cheers Surya --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Formula needed
Venkat, can you post us a sample file..so that it would be easier to us to help out...? On Wed, May 27, 2009 at 9:19 AM, venkat sudhakar sudhakar...@gmail.comwrote: Dear Friends, I need a formula for my work. There will be 2 Excel sheets. In First Sheet there will be 2 Columns In First column there will be code and in 2nd column there will be value and 'n' number of rows will be there. And the code may be repeated at several times in different rows. And in second sheet also, there will be 2 columns In first column there will be code. Now what i need is, against each item code in second sheet, the sum of values in first sheet representing corresponding code. Can any one do the needful. Regards, Venkat --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---