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).aspx

$$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

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 importa

$$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 @ h

$$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 *akoul*.wordpress.com My Linkedin Profile P Before printing, think about

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, Mani

$$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:=Tru

RE: $$Excel-Macros$$ How to learn VBA Languages and Macros

I use Excel 2007 Visual Basic for Applications, Step by Step. This book was extremely helpful to me as I am a new in learning VB and wanted to write more extensive macros. Susan -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of B

$$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 sel

Re: $$Excel-Macros$$ Trying to calculate Number of Days to Deplete Inventory Stock for a Number of Stores

There is more to the story. I apply discounts accross the board to all the stores. I may have no discount for 5 days. Then I might run the program at 40% off for 10 days, 50% off for x days ^0 % off for X days etc. On 12/30/10, Ronald Cayne wrote: > I am performing a descending balance in column

$$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

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 wrote: > Thanks, got it to work finally. > > On Dec 29, 3:51 am, Dave Bonallack wrote: > > Hi, > > To just do the 3 levels you asked

$$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 -- --

$$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 w

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 -- ---

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, Man

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" wrote: > Hello, > Consider pivot table. I may post a sample fi

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(Targe

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 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 a