Re: $$Excel-Macros$$ Form controls disappear when copying sheet

Dear ugoren When you have contorls on your sheet,You can't copy the controls in next sheet. It can be used when you are working with VBA Form. On Tue, Apr 27, 2010 at 8:08 PM, Uri Goren wrote: > Hi, > > I created a sheet in Excel 2007 and added a few buttons to it via the > form controls tool

Re: $$Excel-Macros$$ Help with Median Formula

Hi All, wots fantastic group where Dilip kind of helping people available . my saveral students are getting lots of benefits from all the members of this group specially from Dilip Pandey. Thanks a lot to all ! _ j...@i Deo t...@ri |

Re: $$Excel-Macros$$ Help with Median Formula

Hi Dilip/Group, Would you be able to throw some more light on "Array Functionality"? I was surprised how solution worked for Gopi. If you can tell us, what is the use of this functionality or which are the areas where we can use this type of functionality It would be a great learning for me Tha

Re: $$Excel-Macros$$ about change to range

Thanks Paul Its a learning for me Harry On Apr 29, 8:39 pm, Paul Schreiner wrote: > Excel has special macros called "Event" macros. > > as the name implies, the macro runs whenever the "event" takes place. > > What you're looking for is the SelectionChange event. > > Now, depending on of you

Re: $$Excel-Macros$$ How to compare two Excel sheets

Dear Friends , I m waiting for your response.. On Wed, Apr 28, 2010 at 11:05 PM, sudhir kumar wrote: > Dear Friend, > Thanks for your response, I attached two excel sheet here, one is 'old > file' and other one is 'latest file'. > Latest file is having the latest changes, now i want to compa

Re: $$Excel-Macros$$ about change to range

Excel has special macros called "Event" macros. as the name implies, the macro runs whenever the "event" takes place. What you're looking for is the SelectionChange event. Now, depending on of you want it to apply to ALL sheets in your workbook, or just a single sheet will determine where and wh

$$Excel-Macros$$ about change to range

Hi all, i want to change size to font of which range when i click and after to change to size when i click another range, i want before range turn to before size. How can i do that. For example, i clicked to A1 and when i click , it size turn to 15. and after when i click to B5 , that range will

Re: $$Excel-Macros$$ Help with Median Formula

:) Thanks for your encouraging words. One Request:- Don't put me as a "Boss" because I am still a learner of Excel and needs the continuous support from all the esteemed group members. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dili

RE: $$Excel-Macros$$ Macro to display specific cells from all sheets onto a new sheet

Hi, Try this code in a normal module, and run it while the report sheet is active. Sub GetSheetInfo() A = ActiveSheet.Name B = 2 For Each s In Sheets If s.Name <> A Then Cells(B, 1) = s.Name Cells(B, 2) = s.Range("A4") Cells(B, 3) = s.Ra

Re: $$Excel-Macros$$ Help with Median Formula

Hello Dilip, Thanks a lot, now the formula is working. Regards Gopi On Thu, Apr 29, 2010 at 3:33 PM, Dilip Pandey wrote: > Dear Gopi, > > After entering the formula, just press Ctrl + Shift + Enter. This will > include those brackets for you (Array Functionality) > > Let me know if you face an

Re: $$Excel-Macros$$ Help with Median Formula

Hi All, I am not sure why i am not able to get the answer when i try the same in the sheet. =MEDIAN(IF($B$3:$B$28=H4,$C$3:$C$28,"")) error on the screen is #VALUE One difference i can notice is that the formula entered by Dilip has a flower Braces start and closed in formula {=MEDIAN(IF($B$3:$B$

Re: $$Excel-Macros$$ Help with Median Formula

Gopi, You are always welcome...!! -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Thu, Apr 29, 2010 at 3:41 PM, krishnan Gopi wrote: > Hello Dilip, > > Thanks a lot, now the formula is w

Re: $$Excel-Macros$$ Help with Median Formula

Dear Gopi, After entering the formula, just press Ctrl + Shift + Enter. This will include those brackets for you (Array Functionality) Let me know if you face any challenge(s). -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan..

Re: $$Excel-Macros$$ Help with Median Formula

Dear Gopi, Using Median formula with the arrays functionality, this task has been achieved. Look in the attached file for more details. Let me know in case of any query(ies) -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@

Re: $$Excel-Macros$$ Help me in contitional formating

Dear Vinod, Your desired solution is attached with this email. :) -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Tue, Apr 27, 2010 at 11:39 PM, vinod rao wrote: > Hello, > I want a cond

Re: $$Excel-Macros$$ Need Help

copy the data of column A, right click from mouse. there is an option "paste special". Click on it & tick on transpose, and press ok. Naveen On 4/28/10, balbirkumar . wrote: > > Dear Friends, > > > > > I want to arrange the series of data in a coloum to series of row. For > example > > > > Data

$$Excel-Macros$$ [EquisMetaStock Group] Help needed

Dear Friends, I would like to find set of events when, Condition : When Security breaks X DEMA Output : Every time when Security has broken X DEMA its performance on +1, +2, +3 days. Any help highly appreciated Regards Vishvesh -- -

Re: $$Excel-Macros$$ Need Help

thanks a lot, 4 immediate reply,,,friends On 29 April 2010 10:53, rf1234 rf1234 wrote: > Hello Dear, > Have a look on attached Vedio. > > > > > > > > > On Wed, Apr 28, 2010 at 5:20 PM, balbirkumar . wrote: > >> Dear Friends, >> >> >> I want to arrange the series of data in a coloum to series

Re: $$Excel-Macros$$ Identify unique dates for employee

Hi Vikas and Gurumurthy No , i cant use this formuals to get the desired results On Apr 28, 4:28 am, gurumurthy sastry Kondury wrote: > Hi Chetan, > > May be you can Use If condition like below : > > =IF(F2>0,1,0) - If the entry is in cell F2. Cuz you put any value more > than 1, it will give yo

$$Excel-Macros$$ Help with Median Formula

Hello All, Pls find attached the excel. I have 10 different amount which belong to one group, similarly i have 5 different groups and would like to calculate the median for these 5 group. The excel has a more detailed explanation. Request your help. Regard Gopi -- ---

Re: $$Excel-Macros$$ Need Help

USe transpose... Select from A1 to A4,,,--> Copy...--> Select cell A1 and then right clickuse paste special...check transpose and then press ok On Thu, Apr 29, 2010 at 10:53 AM, rf1234 rf1234 wrote: > Hello Dear, > Have a look on attached Vedio. > > > > > > > > > On Wed, Apr 28, 2010 at

$$Excel-Macros$$ Macro to display specific cells from all sheets onto a new sheet

Hi all, I need help creating a macro that will scan through all sheets (the number of sheets may vary - but, for example, the first one has 51 sheets), then find 5 specific values on each sheet (pretend they are always in cells A4, B30, C30, D30 and E30) and then display those five values in a new

Re: $$Excel-Macros$$ Need Help

Dear Balbir, copy the respective data and press popup key in your keyboard, then s then e and press Enter. (copy->paste special-> tanspose > Enter) :) Pivot table is also a good option to give a try. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipa