Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

Hi Dhaval, Copy below formula at cell address C11 and confirm it with CSE *=MAX(($B$2:$B$68=$S$10)*($A$2:$A$68 = "FUTSTK")*$I$2:$I$68)* * * Select cell R14:R19, press F2 and paste below formuls and confirm it with CSE *=IFERROR(INDEX($B$1:$N$68,IFERROR(SMALL(IFERROR(INT(SUBSTITUTE(($D$1:$D$68 <=

Re: $$Excel-Macros$$ Need help on Graph

Dear Anil, Ok..thanks . Can you clear one things here ..is there any different between validation and drop down box is taken from developer menu Regards, Prafull. On Wed, Apr 3, 2013 at 10:48 AM, अनिल नारायण गवली wrote: > Dear Praful, > > Yes it is right. but even me didn't used any type of mac

Re: $$Excel-Macros$$ Need help on Graph

Dear Praful, Yes it is right. but even me didn't used any type of macro here . the dropdown box is taken from developer menu. Warm Regards, Gawli Anil On Wed, Apr 3, 2013 at 10:29 AM, prafull jadhav wrote: > Dear Anil, > > I have created the same with help of validation and index formula by >

Re: $$Excel-Macros$$ Protect / Unprotect All Sheets at a time

Sub Protect() ' Loop through all sheets in the workbook For i = 1 To Sheets.Count ' Activate each sheet in turn. Sheets(i).Activate response = MsgBox("Do you want to protect this sheet?", vbYesNo) If response = vbYes Then ActiveSheet.Pr

$$Excel-Macros$$ Re: Macro-with example file

You can go through below links: http://www.excel-vba-easy.com/ http://www.excel-vba.com/ On Wednesday, 3 April 2013 09:56:27 UTC+5:30, prafull jadhav wrote: > > Dear All, > > Very Good Morning , > > I am very familiar with excel ..but I have never use Macro in my work . > > I want to learn Macro

Re: $$Excel-Macros$$ Need help on Graph

Dear Deepak, Pl see the attached sheet. Is it OK. Warm Regards, Gawli Anil On Tue, Apr 2, 2013 at 5:18 PM, Deepak Rawat wrote: > Hi > > Kindly find attached , > i need a graph which change as i select the desired cell. > suppose if i want to see sales then when i wil select "Sale" cell the > g

$$Excel-Macros$$ Protect / Unprotect All Sheets at a time

Hello Friends, Greetings ! How can I do "Protect / Unprotect All Sheets" at a time with the following only two options :- Also when I go for unprotect all sheets system should ask user the password. [image: Inline image 2] Please help me in this task. Thank you, Regards Pravin Gunjal. -- Ar

$$Excel-Macros$$ Macro-with example file

Dear All, Very Good Morning , I am very familiar with excel ..but I have never use Macro in my work . I want to learn Macro ..I am getting lots of mail which from our group but I am not able to understand the same as lack of knowledge of Macro . I want learn Macro but like beginnersI have r

Re: $$Excel-Macros$$ array formula

Dear Kushlesh Sharma, Pl share the sheet with us. Warm Regards, Gawli Anil On Tue, Apr 2, 2013 at 10:33 PM, Kush Shama wrote: > I am using multiple sheets in a file. I want to know how to write array > formulas(those that are combination of formulas or have a lot of brackets). > any simple le

$$Excel-Macros$$ Re: array formula

Just write your formula and comfirm it with CSE. Or you can go through below link: http://www.cpearson.com/excel/ArrayFormulas.aspx http://office.microsoft.com/en-in/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx http://www.excelfox.com/forum/f2/count-consecutive-value-range-usin

$$Excel-Macros$$ Re: Arrangement head of the table in the macro code

Use it like this: For Each Wks In ThisWorkbook.Worksheets If IsNumeric(Wks.Name) Then Wks.Name = "Year " & Wks.Name end if If Wks.Name >= 2010 And Wks.Name <= Year(Date) Then end if next wks On Tuesday, 2 April 2013 20:01:41 UTC+5:30, artforart artforart wrote: > > If I add this bold part in cod

Re: $$Excel-Macros$$ power pivot data copy

Want to copy the data in the PivotTable table, the first headline Copy ( select Cell outside), followed by Copy the contains header data below. To export data, click to select any Cell that contains the data, followed by double-click on it one more time. 2013/4/2 danial mansoor > > > dear expe

$$Excel-Macros$$ How does the Mod operator work with dates

Dear All How are you? I'm trying to learn VBA by following examples in the Excel Macro book I got. I got stuck with one of the function examples relating to using Mod operator with date. This example converts week number to a date. Please see the attached Macro for details. I'm having troub

$$Excel-Macros$$ array formula

I am using multiple sheets in a file. I want to know how to write array formulas(those that are combination of formulas or have a lot of brackets). any simple lead with basic formulas would be very fulfilling. -- Regards Always, Kushlesh Sharma 9907517169 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT

Re: $$Excel-Macros$$ Need help on Graph

Thanx Ashish!! Regards, Deepak On Tue, Apr 2, 2013 at 7:24 PM, ashish koul wrote: > Try the attachment . double click on cell f3-f5 > > Regards > Ashish > > > On Tue, Apr 2, 2013 at 5:18 PM, Deepak Rawat wrote: > >> Hi >> >> Kindly find attached , >> i need a graph which change as i select the

$$Excel-Macros$$ Re: Arrangement head of the table in the macro code

If I add this bold part in code I've got End if without block if For Each Wks In ThisWorkbook.Worksheets If IsNumeric(Wks.Name) Then *Wks.Name = "Year " & Wks.Name* If Wks.Name >= 2010 And Wks.Name <= Year(Date) Then Thank u for help -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y

Re: $$Excel-Macros$$ Need help on Graph

Try the attachment . double click on cell f3-f5 Regards Ashish On Tue, Apr 2, 2013 at 5:18 PM, Deepak Rawat wrote: > Hi > > Kindly find attached , > i need a graph which change as i select the desired cell. > suppose if i want to see sales then when i wil select "Sale" cell the > graph should s

$$Excel-Macros$$ Need help on Graph

Hi Kindly find attached , i need a graph which change as i select the desired cell. suppose if i want to see sales then when i wil select "Sale" cell the graph should show "Sale" bars Only and so on. Regards, Deepak Rawat -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? I

$$Excel-Macros$$ power pivot data copy

dear experts, i have fetched data from MS query in pivot,what i want to get updated data from pivot to excel whenever i fetch data into powerpivot window.is it possible?it can be done in excel through table but i dont know abiut power pivot fetching data.can anyone guide me?

Re: $$Excel-Macros$$ mouse right click option not working in excel sheets

Hi, Open New Workbook-->GoTo VBA--->Click This Workbook(Left Side Panel)-->Enter below Code Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean) Application.CommandBars("Ply").Enabled = True End Sub Save That Workbook Anywhere but Don't Delete

Re: $$Excel-Macros$$ mouse right click option not working in excel sheets

Hi, Okay. Please send your sheet. Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* * * On Tue, Apr

Re: $$Excel-Macros$$ mouse right click option not working in excel sheets

Hi Kuldeep Sir Thanks for quick reply.But i want to edit by right click on the sheet name.(as shown in screen picture R&D sheet was selected na. want to right click on the R&D to edit. this is not working in my excel. On 4/2/13, Kuldeep Singh wrote: > [image: Inline image 1] > > Regards, > Kulde

$$Excel-Macros$$ mouse right click option not working in excel sheets

good evening experts I am using excel 2007.In my excel work book i have 10 sheets with defferent names.i want to colour the sheet tabs.when i right click on sheet name with mouse nothing open.previously i used right click and change the color,rename and hide&unhide the sheets.Any help -- Are y

Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

Dear Thanks for u r prompt reply but out put is not as per my requirement pls check the reference sheet On Tue, Apr 2, 2013 at 10:49 AM, xlstime wrote: > Hi Dhaval, > > dhaval shah > (1).xlsx > > PFA... > > >