Re: $$Excel-Macros$$ Pivot Help

http://www.contextures.com/xlpivot04.html On Sat, Oct 15, 2011 at 10:14 AM, hanumant shinde wrote: > Thanks Sam, > > > *From:* Sam Mathai Chacko > *To:* excel-macros@googlegroups.com > *Sent:* Saturday, 15 October 2011 3:19 AM > > *Subject:* Re: $$Excel-Macros$$ Pivot Help > > You would find

Re: $$Excel-Macros$$ Pivot Help

Thanks Sam, From: Sam Mathai Chacko >To: excel-macros@googlegroups.com >Sent: Saturday, 15 October 2011 3:19 AM >Subject: Re: $$Excel-Macros$$ Pivot Help > > >You would find countless results if you just do a search on 'VBA Pivot Table' > >Anyway, a few sites that could be recommended are > >ht

Re: $$Excel-Macros$$ Pivot Help

Hi Noorain, thanks a lot file you provided is very nice. i get to know many extra things as you have covered many things here. but is it possible to prepare all these pivots by programming and can i have the code to see. thanks again :) > >From: NOORAIN ANS

Re: $$Excel-Macros$$ Expense Sheet -- Need Help Urgently

Thank you so Much Paul and Don for your valuable help.:-) D On Fri, Oct 14, 2011 at 10:02 PM, dguillett1 wrote: > I used some defined names with sumproduct. See attached > > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Anupam Konhar > *Sent:* Thursday, October 13

Re: $$Excel-Macros$$ Toggle a Cell value

Charlie, the reason why it throws an exception is because the cell should have either 1 or 0 in the first place. You probably are copying the formula over to your workbook. If yes, just put a 0 in G15 before you start using the macro. FOr your query regarding selection of cell, pls download the att

$$Excel-Macros$$ Solution required

Dear Experts, I have been given the following task. Please help me solving the problem attached in the excel sheet. Thanks. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and l

Re: $$Excel-Macros$$ Dynamic chart range

Dear Atul, Please see attached sheet with Dynamic Chart example. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Thu, Oct 13, 2011 at 5:32 AM, Atul wr

Re: $$Excel-Macros$$ Toggle a Cell value

Hi Don and Sam Thanks for your input. I use Win7 Excel and on a laptop. Don, your code work ok but small hiccup. The code/color changes ok when I select a different cell and then come back to actual cell again. Color and number change as required. However I would like to be able to leave

Re: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)

Hello Sharma; As Paul said; use a helper column & use formulas in the attached. HTH Haseeb For the help & tips, visit; http://www.excelfox.com/forum/forum.php -- -- Some important links for excel users: 1. Follow u

Re: $$Excel-Macros$$ Pivot Help

You would find countless results if you just do a search on 'VBA Pivot Table' Anyway, a few sites that could be recommended are http://www.ozgrid.com/News/pivot-tables.htm http://msdn.microsoft.com/en-us/library/aa164537%28v=office.10%29.aspx http://www.zerrtech.com/content/pivot-table-creation-u

Re: $$Excel-Macros$$ hiya

If it is a form control, right-click on the control and click format control, and in the input range, add the entire range reference including the name of the sheet, like Sheet2!$A$1:$A$10 If it is an activex control, right-click on the control and click properties, and in the ListFillRange, add t

Re: $$Excel-Macros$$

Here's a solution that will return the text in Thousands, Lakh, Crore, Arab instead of million, billion, trillion etc. http://www.excelfox.com/forum/showthread.php?45-Number-into-words-(Rupees) Regards, Sam Mathai Chacko (GL) On Fri, Oct 14, 2011 at 9:06 PM, NOORAIN ANSARI wrote: > Dear Sunil,

Re: $$Excel-Macros$$ Assign values in an array to a userform listbox, then allow user to select

1) The array has to be a one dimensional array Private Sub UserForm_Activate() Dim arrayname As Variant arrayname = Sheet2.Range("A1:A10").Value ListBox1.List() = arrayname End Sub If it is a two dimensional array, you could loop through the values and add item to list like Dim ln

$$Excel-Macros$$ Pivot Help

Hi frends, need to learn Pivot programming do you have any good stuff or site which you can refer to me? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitte

Re: $$Excel-Macros$$ Toggle a Cell value

This should do it Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address(0, 0) = "G15" Then Target.Value = Abs(CLng(Not -Target.Value)) End If End Sub Use a conditional format for coloring the cell. If you do not want to add a conditional format (which i

$$Excel-Macros$$ hiya

hi there have cells on another sheet of my workbook and was wondering how i use these to populate a combo box. alex cargill ps i use excel 2010 -- -- Some important links for excel users: 1. Follow us on TWITTER fo

Re: $$Excel-Macros$$ Worksheetfunction with Excel for Mac

Cannot comment conclusively without having Mac first hand exposure, however, just a suggestion. Try Application.VarP Regards, Sam On Fri, Oct 14, 2011 at 12:56 PM, james D wrote: > Hi, > > I have coded something that works fine in Excel 2010 (on Windows) - > but when a Mac user uses it they

Re: $$Excel-Macros$$ Fuzzy name match- output from userform

My take would be to have a list-box instead of a dropdown. Have a multi-select listbox, and give an option to the user to select the desired list of names. Regards, Sam On Fri, Oct 14, 2011 at 7:09 AM, DaveO wrote: > I have a scenario in which a user needs to perform a "fuzzy" match > between

Re: $$Excel-Macros$$ Urgent Help required

Here's a VBA formula that does the trick http://www.ozgrid.com/forum/showthread.php?t=144212 Regards, Sam Mathai Chacko (GL) On Fri, Oct 14, 2011 at 11:03 AM, Dilip Pandey wrote: > Hi Prathap, > > If this is one time exercise then, write 100 somewhere in and copy > it. Now select the data

Re: $$Excel-Macros$$ Need help

thanks alot Paul its working. On Fri, Oct 14, 2011 at 9:09 PM, Paul Schreiner wrote: > do you HAVE a sheet called "FolderList" ?? > > If not, replace "FolderList" with the name of the sheet that you want to > use to display the sizes! > > > *Paul* > > - > *

Re: $$Excel-Macros$$ Need help

do you HAVE a sheet called "FolderList" ?? If not, replace "FolderList" with the name of the sheet that you want to use to display the sizes!   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At

Re: $$Excel-Macros$$

Dear Sunil, It is possible to Excel and VBA both. You can see attached sheet with both example. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* O

Re: $$Excel-Macros$$ Need help

hi Paul, i am getting bug here, ub List_Folder_Size() Dim fso, fldr, sfldr, FolderName Dim Sht, R FolderName = "D:\C-backup" Sht = "FolderList" Set fso = CreateObject("Scripting.FileSystemObject") Sheets(Sht).Range("A2:Z65000").ClearContents this yellow highlighted one

Re: $$Excel-Macros$$ Need help

This should do it. Sub List_Folder_Size()     Dim fso, fldr, sfldr, FolderName     Dim Sht, R     FolderName = "C:\temp\"     Sht = "FolderList"         Set fso = CreateObject("Scripting.FileSystemObject")         Sheets(Sht).Range("A2:Z65000").ClearContents     R = 1     If (fso.folderexists(Fo

$$Excel-Macros$$ Assign values in an array to a userform listbox, then allow user to select

I have values in an array that I want to appear in a userform listbox. How do I assign array values to a listbox? I googled and found this code, but it returns an error: ListBox1.List() = ArrayName() Then, once the listbox is populated, I want the user to doubleclick a listbox entry and store it t

Re: $$Excel-Macros$$ Need help

are you wanting all sub-folders within the folder? or do you want to progress down through all the nested sub-folders?   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, T

$$Excel-Macros$$ Need help

Good evening experts, Please assist me in this concern i am looking for a excel macro which can give details of folders and their respective size. for example i have Main folder with name Excel with in the folder i have many other sub folders, so i am looking for a macro which can list the sub

Re: $$Excel-Macros$$ vlookup return with pcture assinged

The file need to run on ms excel 2003 version. Rgrds.Prabhat On Oct 14, 12:03 pm, ashish koul wrote: > see if it helps > > On Fri, Oct 14, 2011 at 9:46 AM, prabhat.shrivasta...@gmail.com < > > > > > > prabhat.shrivasta...@gmail.com> wrote: > > Good morning experts > > > Need your valueab

Re: $$Excel-Macros$$ Selecting a range based on a cell value

Attach your file Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Seba Sent: Friday, October 14, 2011 5:28 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Selecting a range based on a cell value Hi all, I am facing a problem regarding the range s

Re: $$Excel-Macros$$ Toggle a Cell value

Right click sheet tab>view code>copy/paste this to make the changes in col G Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Column <> 7 Or Target.Count > 1 Then Exit Sub If Target = 1 Then Target = 0 Target.Interior.ColorIndex = 4 Else Target = 1 Target.Interior.ColorIndex

Re: Fwd: $$Excel-Macros$$ Expense Sheet -- Need Help Urgently

In the Date column, is that the date format you have set up in Windows? dd.mm. ?? In other words, if you change the format of the cells to Long Date format, does 31.05.2011 become "Tuesday, May 31, 2011" ??   If not, we'll have to get a little creative... Paul

Re: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)

It looks to be an ALPHABETIC sort rather than a NUMERIC sort. or.. a Binary sort... Regardless, that means that 192 comes before 52 because 1 comes before 5 Unfortunately, even if the cells are formatted as Text, Excel tries to sort numbers as Numeric and text gets sorted separately. To get the

Re: $$Excel-Macros$$ Selecting a range based on a cell value

First of all... I think some of your primary assumptions are not accurate! I have 109,000 rows with 74 columns in one of my reporting documents (my macros build a summary "dashboard" based on this data) I wrote a macro that: a) prompts for a reporting month, b) Clears the Report sheet c) Extracts

$$Excel-Macros$$ Selecting a range based on a cell value

Hi all, I am facing a problem regarding the range selection. I have a worksheet used for recording daily stuff. SOmething like this: ColAColB ColC January1.1.2011 9:00 - 10:00 January1.1.2011 10:00 - 11:00 January1.1.2

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

Thanks to all of you dear On Fri, Oct 14, 2011 at 12:55 PM, Ananta Sapkota wrote: > Congratulation, Keep it up. > > > On Thu, Oct 13, 2011 at 11:18 PM, Ankit Agrawal < > ankit.agrawal...@gmail.com> wrote: > >> Congrats Noorain. You deserved it.. >> >> >> On Fri, Oct 14, 2011 at 11:40 AM, Subhash

Re: $$Excel-Macros$$ vlookup return with pcture assinged

Dear Prabhat, Please try it and see attached sheet for reference Copy it and paste in Formula-Define Name-Referes to Indirect Formula =INDIRECT("Sheet4!B"&MATCH('Indirect Example 3'!$A$4,Sheet4!$A:$A,0)) On Fri, Oct 14, 2011 at 9:46 AM, prabhat.shrivasta...@gmail.com < prabhat.shri

$$Excel-Macros$$ Worksheetfunction with Excel for Mac

Hi, I have coded something that works fine in Excel 2010 (on Windows) - but when a Mac user uses it they get compile errors. The issue is me using WorksheetFunction.Var_p (or average... or anything I think) - this does not compile for the Mac. I think this might be to do with the analysis Pak? I

$$Excel-Macros$$ Toggle a Cell value

Hi eveyrone See attached sheet. For a 12 volt motor speed direction, Forward or Reverse I want to have a value of a cell to toggle back and forth between 0 and 1 and cell color also to change each time between green and red. Prefer to use a cell than use a toggle button, unless a toggle button

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

Congratulation, Keep it up. On Thu, Oct 13, 2011 at 11:18 PM, Ankit Agrawal wrote: > Congrats Noorain. You deserved it.. > > > On Fri, Oct 14, 2011 at 11:40 AM, Subhash Yadav wrote: > >> Congratulations Noorain... >> >> >> Thanks for your helps provided.. >> >> Regards, >> >> >> Subhash Yadav >>