Re: $$Excel-Macros$$ Find counts based on names

Hi All, Any updates from the below mail. i am looking another sum formula in to this sumproduct, In cell consolidated report sheet Cell F4. just add another sum formula in to this sumproduct based on names. the data is in contain deleted sheet. regards lokesh.M On Thu, Jan 5, 2012 at 6:39 PM, Ra

Re: $$Excel-Macros$$ Multiple worksheet in a single file.....need some help

*Thanks Sam, thanks a lot.* * * On Sat, Jan 7, 2012 at 9:14 PM, Sam Mathai Chacko wrote: > Back in Delhi > > Indrajit, the view that you see in that workbook is called the pagelayout > (Enum 3) view. This was introduced in Excel 2007, and you can simply go the > view tab and click on the pagel

Re: $$Excel-Macros$$

Hi Please find enclosed On Sat, Jan 7, 2012 at 6:31 PM, dguillett1 wrote: > Just send to me as requested. dguillett1 @gmail.com > > > > > Don Guillett > SalesAid Software > dguille...@gmail.com > -Original Message- From: jagan mohan > Sent: Friday, January 06, 2012 11:04 PM > > To:

Re: $$Excel-Macros$$ want to solution of Vlookup limitation

Dear Aamir, 1 use for Lookup range, 2 use for target column -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Fri, Jan 6, 2012 at 11:20 PM, Aamir Shahza

Re: $$Excel-Macros$$ Sorted Stacks in VBA

Hi Try this Sub kTest() Dim r As Range Set r = Range("a2:a6") SortAlphaNums r End Sub Sub SortAlphaNums(ByRef r As Range) Dim a With r a = "'" & .Parent.Name & "'!" & .Address .Value = Evaluate("=IF(ISNUMBER(--LEFT(" & a & ",FIN

Re: $$Excel-Macros$$ Multiple worksheet in a single file.....need some help

Back in Delhi Indrajit, the view that you see in that workbook is called the pagelayout (Enum 3) view. This was introduced in Excel 2007, and you can simply go the view tab and click on the pagelayout button. The Normal (Enum 1) and the PageBreak Preview (Enum 2) options were already available in

Re: $$Excel-Macros$$ Sorted Stacks in VBA

If desired, send me your file dguillett1 @gmail.com with code and complete explanation. Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: christoph404 Sent: Saturday, January 07, 2012 9:10 AM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Sorted

Re: $$Excel-Macros$$ Sorted Stacks in VBA

Hey Don, Your answer is very much appreciated. However, as I stated at the end of my post, I'm trying to avoids doing this action in the spreadsheet but instead keep it in the code completely. Still, thanks! Christoph On Jan 7, 8:45 am, "dguillett1" wrote: > One way is to just have a macro crea

Re: $$Excel-Macros$$ Sorted Stacks in VBA

One way is to just have a macro create a helper column>sort by that>delete the helper column. Here is one I did for someone that you can modify to suit. Option Explicit Sub MakeReportSAS() Dim lr As Long Application.ScreenUpdating = False lr = Cells(Rows.Count, 1).End(xlUp).Row Range("P2:p" &

$$Excel-Macros$$ Sorted Stacks in VBA

Hi, I'm using Excel 2010 and am darn close to finishing a pretty cool spreadsheet I built with the exception of one problem I can't seem to solve. I a VBAS sub() that takes n pairs of two variables (n is usually < 50). The pairs are always made up of one integer and one string. For example, a pair

Re: $$Excel-Macros$$ Multiple worksheet in a single file.....need some help

it has some kind of excel sheet setting..so go into option On Sat, Jan 7, 2012 at 4:22 AM, Indrajit $nai wrote: > Hi All, > > I got the attached file somewhere from net. Can anyone explain me how to > create such kind of workbook like the attached file. > > Thanks in advance. > > -- > Indrajit >

Re: $$Excel-Macros$$

Just send to me as requested. dguillett1 @gmail.com Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: jagan mohan Sent: Friday, January 06, 2012 11:04 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Kindly check the 1st mail in this link.