$$Excel-Macros$$ Re: How to use a drop down list to select data from another sheet
H Steve, No attachment found,,.. Please send your attachment and then we will try to answer. Thanks Regards, BS (sharma@gmail.com) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ HAPPY NEW YEAR 2011
Dear All Experts, I would like to wishing you A VERY VERY HAPPY NEW YEAR 2011, YOU WILL BE MORE EXPERT IN VBA THROUGH THIS GROUP Thanking you Sajid Memon -- -- 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$$ HAPPY NEW YEAR 2011
Wish u the same dudue does any one has excel greetings for new year if yes den plz do forward it to me Regards, Lucky On Fri, Dec 31, 2010 at 12:20 PM, SAJID MEMON sajidwi...@hotmail.comwrote: Dear All Experts, I would like to wishing you A VERY VERY HAPPY NEW YEAR 2011, YOU WILL BE MORE EXPERT IN VBA THROUGH THIS GROUP Thanking you Sajid Memon -- -- 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
$$Excel-Macros$$ Re: Help for starter
Hi Manish, Thx a lot for your quick reply. I searched for file you mentioned but couldnt get it.May be I will try again.Mean while if you can send me that file in email then it is good. I will check your file and let the group know whether all my queries are resolved or not. Thx a lot for your reply. Wish you all very happy new year. Regards, Premal On Dec 30, 11:43 am, Manish pansari.man...@gmail.com wrote: Hi Premal, Today, i uploaded one new file on our group Excel_tutor.xls Try this, it will help you... Regds, Manish On Dec 30, 9:32 am, Premal premalpanc...@gmail.com wrote: Hi, I am very new to VBA. I know C++.I have few questions related to Excel programming. 1) I have two xls files Rate.xls and Bill.xls. Rate.xls file contains two columns which has heading ItemNo and ItemRate.Now I want that in bill.xls when I enter ItemNo and quantity then final price should be calculated. For this I need that when I enter ItemNo it takes its rate from Rate.xls (I mean program should search itemNo and take row number so same number can be used to find rate from second column by giving proper cell ref) and multiply with quantity and put final price in next column.So how to do this?I dont need to make rate.xls visible to user(if possible). 2)Where shound I find complete documentation of All APIs.I didnt find good book which covers some functionalities like finding particular value in xls file and return row or column or cell ref for that, find first empty row and column. 3)How to use C# for excel programming. What should be installed for this. I have visual studio 2008 and Office 2003. Apart from that what I need to install.I heard about Office Tools,but I dont know how to install. If these questions are already answered then pls send me link to that post so I can read and understand it. I hope some expert will reply asap. One can also send reply to premalpanc...@gmail.com Thak you very much in advance.- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Re: Help for starter
Hi Manish, Tx a lot for quick reply. I couldnt get file posted by you. I checked in Files section but i couldnt find. I will try to find it again. If you can send me that file thru email then it is very helpful. Tx a lot again and wish you all happy new year. Regards, Premal Panchal On Dec 30, 11:43 am, Manish pansari.man...@gmail.com wrote: Hi Premal, Today, i uploaded one new file on our group Excel_tutor.xls Try this, it will help you... Regds, Manish On Dec 30, 9:32 am, Premal premalpanc...@gmail.com wrote: Hi, I am very new to VBA. I know C++.I have few questions related to Excel programming. 1) I have two xls files Rate.xls and Bill.xls. Rate.xls file contains two columns which has heading ItemNo and ItemRate.Now I want that in bill.xls when I enter ItemNo and quantity then final price should be calculated. For this I need that when I enter ItemNo it takes its rate from Rate.xls (I mean program should search itemNo and take row number so same number can be used to find rate from second column by giving proper cell ref) and multiply with quantity and put final price in next column.So how to do this?I dont need to make rate.xls visible to user(if possible). 2)Where shound I find complete documentation of All APIs.I didnt find good book which covers some functionalities like finding particular value in xls file and return row or column or cell ref for that, find first empty row and column. 3)How to use C# for excel programming. What should be installed for this. I have visual studio 2008 and Office 2003. Apart from that what I need to install.I heard about Office Tools,but I dont know how to install. If these questions are already answered then pls send me link to that post so I can read and understand it. I hope some expert will reply asap. One can also send reply to premalpanc...@gmail.com Thak you very much in advance.- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Hyperlink Funcitonality
select the cell where your hyper link then use it (Ctrl+[) to reach hyperlink On Thu, Dec 30, 2010 at 11:05 PM, busboy10 andrew.var...@gmail.com wrote: HI All, Trying to figure out how to get the reference cell that I am hyperlinking to within a sheet, to be aligned to the top left of the window. I have tried this with no luck Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) Application.Goto reference:=ActiveCell, scroll:=True End Sub Any thoughts? Thanks! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/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
$$Excel-Macros$$ Excel Daily Tip : Hide Cell error while printing
Ayush Jain has sent you a link to a blog: Last excel tip of 2010...must read How to hide a cell error while printing a spreadsheet share with your friends and colleagues Blog: Excel Daily Tip Post: Hide Cell error while printing Link: http://exceldailytip.blogspot.com/2010/12/hide-cell-error-while-printing.html -- Powered by Blogger http://www.blogger.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Re: Change / Arrange no. of order of Sheets - Help
Hi Rohan, Thanks for wishes and same to you ! I did a quick finding on how to print from back to front. You can give it a try. Follow the below steps 1) Go to page setup 2) In Page tab, there is an options button at the bottom 3) Click to open a properties window 4) On Advanced tab, There is layout options 5) Select Back to Front in Page order: field. 6) Click ok and print the page. I have enclosed a snapshot of the same for your reference. Do give a try and let me know if it helps you. Feel free to write back to us if you have further questions. Best Regards, Ayush Jain Microsoft MVP https://lh3.googleusercontent.com/_wa671SC3JRE/TR3_DHnhkcI/AR0/-Eb1SVQo8wg/back%20to%20front.JPG -- -- 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$$ How to use a drop down list to select data from another sheet
Dear Steve, If you want to get a drop down list for data that is in Other sheet, First set the cursor or ur position where u want the list to appear then go to the sheet which you have the data then select all the Data and give a name to the range of cells you have selected or in other words create a named range.After that go to Data Validation in the DATA menu and in the Options available select List and in the Cell reference give the name of of the Named range that you have named before. then you can have you list in you required cell.even though you data is in other sheet. Regards, Vijaykumar On Thu, Dec 30, 2010 at 7:20 PM, Steve stevebwea...@comcast.net wrote: Each month I must compare monthly expenses to the budget (forecast). To do this I have created a spreadsheet with a drop down list where the user selects the appropriate month to analyze. I would then like the data to be pulled in from another tab using the appropriate column based on the month selected. However, I am having trouble doing this via the lookup function and ask for your help. I have uploaded the spreadsheet Copy of Actual vs Forecast FY11.xls. Any help or advice offered will be appreciated. Thank you! Steve Weaver -- -- 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 -- P.VIJAY KUMAR -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Change / Arrange no. of order of Sheets - Help
Dear Rohan, You can download and install an add-in called Ultimate Add-in which contains many useful features along with a feature to sort work sheets. Regards, VijayKumar On Fri, Dec 31, 2010 at 11:31 AM, Rohan Young rohan.j...@gmail.com wrote: Hi Experts, Gud morng wishing u all a very HAPPY NEW YEAR 2011 I hv a question, can we change / arrange the order of Sheets in excel. e.g. : i hv a file which has many of sheets i want to take print of all sheets with the page nos. but the problem is all the sheets are arranged in descending order (from left to right : Sheet 10, Sheet 9, Sheet 8...) but i want printouts from the sheet 1 with the page no. 1 on sheet 1, if i give page nos. on these sheets excel will count the page no. 1 on sheet 10, how can i arrange or change the order of sheets (if there is so many sheets)? any ideas/thought/function/command on this please share thanks ROHAN 9818247278, 8860567680 -- -- 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 -- P.VIJAY KUMAR -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Re: Change / Arrange no. of order of Sheets - Help
Hi Ayush Ji, Gud Morng with new year wishes, Thanks for the feedback, but the situation is same, neither my printer KYOCERA KM3060 is showing any option like that nor XeroxCentre, and the other question is can that commands or setting count the page nos. automatically on pages please help Thanks ROHAN 9818247278, 8860567680 On Fri, Dec 31, 2010 at 9:38 PM, Ayush jainayus...@gmail.com wrote: Hi Rohan, Thanks for wishes and same to you ! I did a quick finding on how to print from back to front. You can give it a try. Follow the below steps 1) Go to page setup 2) In Page tab, there is an options button at the bottom 3) Click to open a properties window 4) On Advanced tab, There is layout options 5) Select Back to Front in Page order: field. 6) Click ok and print the page. I have enclosed a snapshot of the same for your reference. Do give a try and let me know if it helps you. Feel free to write back to us if you have further questions. Best Regards, Ayush Jain Microsoft MVP https://lh3.googleusercontent.com/_wa671SC3JRE/TR3_DHnhkcI/AR0/-Eb1SVQo8wg/back%20to%20front.JPG -- -- 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
$$Excel-Macros$$ hAPPY nEW yEAR....2011
*Hi All,* ** * I wish you all a very happy, prosperous and joyful new year 2011!!* *May the dawning of this New Year, fill your heart with new hopes, open up new horizons and bring for you promises of brighter tomorrows. May the journey of your life be fragrant with new opportunities, your days be bright with new hopes and your heart be happy with love! * *When you're lonely, I wish you Love! * *When you're down, I wish you Joy! * *When you're troubled, I wish you Peace! * *When things seem empty, I wish you Hope! * *Have a Happy New Year! * *Regards* *Umesh Sharma! * *:) wish u lozz of love * Thanks, Prabhakar Thakur New Delhi +919953736776 ** *“Be the change that you want to see in the world” * -- -- 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
$$Excel-Macros$$ Re: Change / Arrange no. of order of Sheets - Help
Hi Rohan, If your printer does not allow to print from back to front, you can use macros to reverse the order of the sheet. Please run the below macro to reverse the order sheet and then give print command. After printing the sheets, Run the macro again to make the original sheet order. * Sub reverse_sheet_order() Dim TotalSheets As Integer TotalSheets = ActiveWorkbook.Sheets.Count For i = 1 To TotalSheets Sheets(TotalSheets).Move before:=Sheets(i) Next End Sub* Please give it a try and let me know if it helps you. Best Regards, Ayush Jain 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/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ VBA Macros Code examples : Reverse order of the sheets
Ayush Jain has sent you a link to a blog: The VBA code to reverse the order of sheets in Active workbook. Blog: VBA Macros Code examples Post: Reverse order of the sheets Link: http://quickvba.blogspot.com/2010/12/reverse-order-of-sheets.html -- Powered by Blogger http://www.blogger.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts