Re: $$Excel-Macros$$ Re: How to lock cell based on condition
b is column no 2 g is column no 7 target.row will select the row On Thu, Dec 30, 2010 at 1:39 PM, ashish koul koul.ash...@gmail.com wrote: **Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then 'target.column =3 because column c is no 3 column 'you can change password ashish and choose your own ActiveSheet.Unprotect Password:=ashish If Not IsEmpty(Target.Value) And Target.Value = Yes Then Cells(Target.Row, 2).Locked = True Cells(Target.Row, 7).Locked = True End If ActiveSheet.Protect Password:=ashish Else: End If End Sub On Thu, Dec 30, 2010 at 12:42 PM, Manish pansari.man...@gmail.comwrote: Thanks Ashish, This is perfect as i want. I need some more help, If i want to lock only column B to G (not want to lock entire row) than what will the code. I want to understand the diff in codes. :) Thanks once again for your help. Regds, Manish On Dec 30, 10:31 am, ashish koul koul.ash...@gmail.com wrote: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then 'target.column =3 because column c is no 3 column 'you can change password ashish and choose your own ActiveSheet.Unprotect Password:=ashish If Not IsEmpty(Target.Value) And Target.Value = Yes Then Rows(Target.Row : Target.Row).Select Selection.Locked = True End If ActiveSheet.Protect Password:=ashish Else: End If End Sub check this http://akoul.blogspot.com/2010/06/lock-cell-after-data-entry-from-edi. .. On Thu, Dec 30, 2010 at 10:38 AM, Manish pansari.man...@gmail.com wrote: Any help/suggestion ??? Thanks, Manish On Dec 29, 3:03 pm, Manish Pansari pansari.man...@gmail.com wrote: Dear EE, Is it possible to lock the entire row/selected cell based on condition in particular Cell. for example, I want to lock the row based on value in column A. If macro found value yes in cell A1 A5, Macro will lock the row 1 row 5. I hope its possible in macro. Pls suggest me the code. Thnxs, Manish -- ------ 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 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 Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall;. .. -- *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. testlock.xls 45KViewDownload- 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 -- *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. -- *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
Re: $$Excel-Macros$$ Re: How to lock cell based on condition
**Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then 'target.column =3 because column c is no 3 column 'you can change password ashish and choose your own ActiveSheet.Unprotect Password:=ashish If Not IsEmpty(Target.Value) And Target.Value = Yes Then Cells(Target.Row, 2).Locked = True Cells(Target.Row, 7).Locked = True End If ActiveSheet.Protect Password:=ashish Else: End If End Sub On Thu, Dec 30, 2010 at 12:42 PM, Manish pansari.man...@gmail.com wrote: Thanks Ashish, This is perfect as i want. I need some more help, If i want to lock only column B to G (not want to lock entire row) than what will the code. I want to understand the diff in codes. :) Thanks once again for your help. Regds, Manish On Dec 30, 10:31 am, ashish koul koul.ash...@gmail.com wrote: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then 'target.column =3 because column c is no 3 column 'you can change password ashish and choose your own ActiveSheet.Unprotect Password:=ashish If Not IsEmpty(Target.Value) And Target.Value = Yes Then Rows(Target.Row : Target.Row).Select Selection.Locked = True End If ActiveSheet.Protect Password:=ashish Else: End If End Sub check this http://akoul.blogspot.com/2010/06/lock-cell-after-data-entry-from-edi... On Thu, Dec 30, 2010 at 10:38 AM, Manish pansari.man...@gmail.com wrote: Any help/suggestion ??? Thanks, Manish On Dec 29, 3:03 pm, Manish Pansari pansari.man...@gmail.com wrote: Dear EE, Is it possible to lock the entire row/selected cell based on condition in particular Cell. for example, I want to lock the row based on value in column A. If macro found value yes in cell A1 A5, Macro will lock the row 1 row 5. I hope its possible in macro. Pls suggest me the code. Thnxs, Manish -- ------ 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 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 Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall;. .. -- *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. testlock.xls 45KViewDownload- 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 -- *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
Re: $$Excel-Macros$$ How to hide/filter rows?
Hello Daniel, right now I'm using Excel 2003. An example or a detailed explanation would be highly appreciated. (So far, I used excel only as a spreadsheet viewer - so please be very detailed). Thank you. On Dec 29, 8:31 pm, Daniel dcolarde...@free.fr wrote: Hello, Consider pivot table. I may post a sample file. Just tell what your Excel version is. Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Walter Moser Envoyé : mardi 28 décembre 2010 17:04 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ How to hide/filter rows? Hello, so i have this 1+ rows excel sheet. Each row containins a name and a price - each in its own column. A name may appear various times. How can i filter the rows in order to display only one row for a given name. The one row i'd like to display is the one with the highest price. How can this be done in excel? Thanks, W. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :http://twitter.com/exceldailytip2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below linkhttp://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall;... -- -- 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$$ Re: How to lock cell based on condition
Thanks once again.. :) concept clear.. Again need more value addition... this code is working fine. I am not be able to insert the row, once macro protect the sheet. I want only insert the row, even after the protection of the worksheet Pls suggest Thanks boss Regds, Manish On Dec 30, 1:10 pm, ashish koul koul.ash...@gmail.com wrote: b is column no 2 g is column no 7 target.row will select the row On Thu, Dec 30, 2010 at 1:39 PM, ashish koul koul.ash...@gmail.com wrote: **Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then 'target.column =3 because column c is no 3 column 'you can change password ashish and choose your own ActiveSheet.Unprotect Password:=ashish If Not IsEmpty(Target.Value) And Target.Value = Yes Then Cells(Target.Row, 2).Locked = True Cells(Target.Row, 7).Locked = True End If ActiveSheet.Protect Password:=ashish Else: End If End Sub On Thu, Dec 30, 2010 at 12:42 PM, Manish pansari.man...@gmail.comwrote: Thanks Ashish, This is perfect as i want. I need some more help, If i want to lock only column B to G (not want to lock entire row) than what will the code. I want to understand the diff in codes. :) Thanks once again for your help. Regds, Manish On Dec 30, 10:31 am, ashish koul koul.ash...@gmail.com wrote: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then 'target.column =3 because column c is no 3 column 'you can change password ashish and choose your own ActiveSheet.Unprotect Password:=ashish If Not IsEmpty(Target.Value) And Target.Value = Yes Then Rows(Target.Row : Target.Row).Select Selection.Locked = True End If ActiveSheet.Protect Password:=ashish Else: End If End Sub check this http://akoul.blogspot.com/2010/06/lock-cell-after-data-entry-from-edi. .. On Thu, Dec 30, 2010 at 10:38 AM, Manish pansari.man...@gmail.com wrote: Any help/suggestion ??? Thanks, Manish On Dec 29, 3:03 pm, Manish Pansari pansari.man...@gmail.com wrote: Dear EE, Is it possible to lock the entire row/selected cell based on condition in particular Cell. for example, I want to lock the row based on value in column A. If macro found value yes in cell A1 A5, Macro will lock the row 1 row 5. I hope its possible in macro. Pls suggest me the code. Thnxs, Manish -- ------ 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 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 Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall;. .. -- *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. testlock.xls 45KViewDownload- 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 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 Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall;... -- *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. -- *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.- 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.
Re: $$Excel-Macros$$ Re: How to lock cell based on condition
Again, unless i will not enable the macro, i can change in the locked cell :( :( How can I enable the macro automatically, if the user open the xl file. I hope my requirement is clear and hope such option is available in VBA. Regds, Manish -- -- 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$$ How to learn VBA Languages and Macros
Dear Friends, Firstly I want to thank you all for making and using this wonderful educational site. Its really superb. I am somewhat good in excel inbuilt formulas functions and able to complete most of my work through that. But I need your help as I want to learn VBA programming Macros and want to automate my working. Please suggest me the way, I want to know how to write programs starting with some small programs in a easy language along with the meaning /definition of objects, array, classes, etc. How to write programmes. Along with this I will appreciate if peoples send me their working files, learning books, etc. through which I can learn programmes, etc. -- -- 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$$ Description while using Macro Functions in Excel
hi Group, i want to show description of the Function while using the same in Excel like below screen shot. e.g while using if function in excel it displays like =if(logical_test, value_if_true, value_if_false) thanks Rajesh Mahapatra -- -- 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$$ Nested IF functions?
Dear Group, May I know how much time use nested if in loop of function?? Thanks, Prabhakar Thakur New Delhi +919953736776 On Thu, Dec 30, 2010 at 8:24 AM, J D springer...@gmail.com wrote: Thanks, got it to work finally. On Dec 29, 3:51 am, Dave Bonallack davebonall...@hotmail.com wrote: Hi, To just do the 3 levels you asked about, try: =IF(B16500,3.5,IF(B161000,2.75,2.25)) Regards - Dave. Date: Tue, 28 Dec 2010 20:18:30 +0530 Subject: Re: $$Excel-Macros$$ Nested IF functions? From: dilipan...@gmail.com To: excel-macros@googlegroups.com Hi J D, á It would be really appreciable if you can share a test file on this.á Help us to help you :) á Best Regards, DILIPandey On Tue, Dec 28, 2010 at 7:36 AM, J D springer...@gmail.com wrote: I am a concrete estimator who is trying to create some cut and paste Estimate line items I can just grab from one spread sheet and paste in to my estimate. I was refining one and tried to use the IF function to pick the number of labor hours based on sq footage. áMore s.f. and we are more productive therefore less hours per s.f. I was trying to say if less that 500 s.f. then .035 hrs/s.f. á500 to 1,000 then .0275 hrs/s.f. 1,000 s.f. then .0225 hours/s.f. I could get one working but wanted to know how to get more going choises out of one formula. áAttached is the assembly and the formula below it. Form, place and finish ~ (__) s.f. of 4 broom swept finish concrete sidewalk. áConcrete to be 3,500 psi and reinforced with 6 x 6 , w1.4/ w1.4 wwf. á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á $4,410.00 á á á áArea á á990 á á s.f. á áPerimeter á á á 114 á á l.f. Concrete á á á á990 á á 0.33 á á1.03 á á336.501 12.463 á13 á á á145 á á 1885 Labor á 13 á á á0.4 á á 5.2 á á á á á á á á á á 5.2 á á 40 á á á208 wwf á á 990 á á 40 á á á24.75 á á á á á á á á á 25 á á á7 á á á 175 2 SB á 990 á á 0.26 á á257.4 á á á á á á á á á 260 á á 0.49 á á127.4 Labor á 990 á á 0.003 á 2.97 á á á á á á á á á á3 á á á 40 á á á120 Poly á á990 á á 1800 á á0.55 á á á á á á á á á á0.6 á á 85 á á á51 Labor á 990 á á 0.002 á 1.98 á á á á á á á á á á2 á á á 40 á á á80 Expansion á á á 990 á á 0.25 á á247.5 á 100 á á 2.475 á 2.5 á á 31.64 á 79.1 Labor á 250 á á 0.01 á á2.5 á á á á á á á á á á 2.5 á á 40 á á á100 Curing á640 á á 350 á á 1.828571429 á á 5 á á á 0.365714286 á á 0.4 á á 55 á á á22 Labor á 990 á á 0.003 á 2.97 á á á á á á á á á á3 á á á 40 á á á120 2 x 4 á 114 á á 16 á á á7.125 á á á á á á á á á 8 á á á 5.81 á á46.48 Labor á 114 á á 0.33 á á37.62 á 0.2 á á 7.524 á 7.6 á á 40 á á á304 Finish á990 á á 100 á á 9.9 á á 2.75 á á27.225 á27.3 á á40 á á á1092 á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á4409.98 =IF(B16500,3.5,2.75) -- ------ 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 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 Like our page on facebook , Just follow below linkhttp:// www.facebook.com/pages/discussexcelcom/160307843985936?v=wall... -- Thanks Regards, DILIP KUMAR PANDEYá á MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials 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 Like our page on facebook , Just follow below linkhttp:// www.facebook.com/pages/discussexcelcom/160307843985936?v=wall... -- -- 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
$$Excel-Macros$$ Trying to calculate Number of Days to Deplete Inventory Stock for a Number of Stores
I am performing a descending balance in column B,C,D. up to 100 Stores. that incorporates number of days to arrive at that point based on some calculation. If the outstanding balance is less than 1 then I require the number of days to arrive at that point. in Column C to so indicated in Row 5 of that column. The calculation is quite complicated but their must be some suggestions as to the statement I should include that will give me the number of days Here are more details I huave a series of stores with different Inventory Levels on hand. I know the average daily sales for each store. If I assume that I can meet the daily sales or a multiple thereof. How many days will it take to run through the Inventory for each store. Hope this is not as clear as MUD! Help would be greatly appreciated Regards Ronald Cayne r...@ronca.ca or ronca...@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$$ How to use a drop down list to select data from another sheet
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
$$Excel-Macros$$ Hyperlink Funcitonality
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
Re: $$Excel-Macros$$ Re: How to lock cell based on condition
hi manish check this link you can hide all the sheets and make user to click on enable macro to make that sheet visible. http://www.vbaexpress.com/kb/getarticle.php?kb_id=379 to insert row write in code to to unprotect sheet and then protect it again. On Thu, Dec 30, 2010 at 4:25 PM, Manish pansari.man...@gmail.com wrote: Again, unless i will not enable the macro, i can change in the locked cell :( :( How can I enable the macro automatically, if the user open the xl file. I hope my requirement is clear and hope such option is available in VBA. Regds, Manish -- -- 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
$$Excel-Macros$$ Wishing you all Very happy and prosperous New Year
*Wishing you all Very happy and prosperous New Year* -- *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
$$Excel-Macros$$
*Wishing you all Very happy and prosperous New Year* -- -- 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$$ Wishing you all Very happy and prosperous New Year
Hi All, I am new macros and VBA , I have test session on VBA , Macros , excel , access and sql. Could you please advice me on the links to which I can refer and learn basics. With Regards Rathi -- -- 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$$ Change / Arrange no. of order of Sheets - Help
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
Re: $$Excel-Macros$$ Wishing you all Very happy and prosperous New Year
Excel tutorials at http://www.excel-macros.blogspot.com Learn VBA Macros at http://www.quickvba.blogspot.com Excel Tips and Tricks at http://exceldailytip.blogspot.com www.mrexcel.com www.contextures.com http://msdn.microsoft.com/en-us/library/bb149081(v=office.12).aspxhttp://www.linkedin.com/redirect?url=http%3A%2F%2Fmsdn%2Emicrosoft%2Ecom%2Fen-us%2Flibrary%2Fbb149081%28v%3Doffice%2E12%29%2Easpxurlhash=LuJ5_t=tracking_disc www.techonthenet.com/excel/formulas/index.php www.cpearson.com http://www.functionx.com/vbaexcel/Lesson02.htmhttp://www.linkedin.com/redirect?url=http%3A%2F%2Fwww%2Efunctionx%2Ecom%2Fvbaexcel%2FLesson02%2Ehtmurlhash=AkRu_t=tracking_disc http://www.functionx.com/vbaexcel/Lesson02.htm www.*w3schools*.com/sql/default.asphttp://www.w3schools.com/sql/default.asp On Fri, Dec 31, 2010 at 10:54 AM, rathi rupenzala rathi8rupenz...@gmail.com wrote: Hi All, I am new macros and VBA , I have test session on VBA , Macros , excel , access and sql. Could you please advice me on the links to which I can refer and learn basics. With Regards Rathi -- -- 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