Re: $$Excel-Macros$$ Need formula

Dear naanu Go through the attachment. it may help. or please make it clear with sample file -- *Great day,* *viper * On Thu, Aug 25, 2011 at 8:51 PM, naanu wrote: > I want to know the formula to find out the solution. > > ** ** > > For Ex: I have two columns > > ** ** > > Aru*

Re: $$Excel-Macros$$ Multiple sorts on one Sheet

Hi Guys Wow, they work like magic. Thanks Ashish and Rajan. Some more new knowlege for me. Great work and thanks Charlie Harris On Aug 26, 5:58 pm, "Rajan_Verma" wrote: > Try this: > > Sub SortList() > > On Error Resume Next > >      Dim Record As Integer > >      Record = ActiveSheet.UsedRa

Re: $$Excel-Macros$$ Cut Data from Rows and Paste into Columns

Dear green go through the attachment. it may help. -- *Great day,* *viper* On Fri, Aug 26, 2011 at 10:42 AM, NOORAIN ANSARI wrote: > Please provide sample sheet. > > > On Fri, Aug 26, 2011 at 9:25 AM, GreenBriar > wrote: > >> I have a series of spreadsheets that have data in them that

RE: $$Excel-Macros$$ Multiple sorts on one Sheet

Try this: Sub SortList() On Error Resume Next Dim Record As Integer Record = ActiveSheet.UsedRange.Rows.Count For i = 1 To Record If Range("D" & i).Value = "HD" Then Range("D" & i + 1).Select ActiveCell.Resize(ActiveCell.End(x

Re: $$Excel-Macros$$ Help to create summary table count unique

Dear Sandeep, Please see attached sheet for Example... -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Fri, Aug 26, 2011 at 10:51 AM, wrote: > **Dear excelguru, > > Can u pls elaborate what is unique count? > And how

RE: $$Excel-Macros$$ BarHide

Go To View and Uncheck the Heading CheckBox. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of SAJID MEMON Sent: Thursday, August 25, 2011 5:59 PM To: Excel Group Subject: $$Excel-Macros$$ BarHide Dear Experts, Plz give attachment requirement code.

Re: $$Excel-Macros$$ Help to create summary table count unique

Dear excelguru, Can u pls elaborate what is unique count? And how it helps? Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI Sender: excel-macros@googlegroups.com Date: Fri, 26 Aug 2011 10:49:39 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Exce

Re: $$Excel-Macros$$ Help to create summary table count unique

Dear ChilExcel, For Unique Count... Use below function..with Ctrl+shift+Enter.. *=SUM(1/COUNTIF(I1:I28,I1:I28))* -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Fri, Aug 26, 2011 at 3:20 AM, ChilExcel wrote: > h

Re: $$Excel-Macros$$ Cut Data from Rows and Paste into Columns

Please provide sample sheet. On Fri, Aug 26, 2011 at 9:25 AM, GreenBriar wrote: > I have a series of spreadsheets that have data in them that needs to > be formatted into 3 columns instead of one column. > > The data in Row 1 needs to go in row 1, column 1 > Row 2 needs to go in row 1, column 2 >

$$Excel-Macros$$ MIS Opening

I Have 2 Off-roll Opening with me, One in Videocon as an Off-roll Employee and One in Master Franchisee of United Colors of Benetton. Package 2.5-3 Lac. Please call @ 9711772297 Regards Rahul Gandhi -- -- Some imp

$$Excel-Macros$$ Pivot Table Percent of Column...

Thanks in advance experts!!! This is very complicated to explain, but I'll give it a go: I have data (Invoice#, Invoice Year, Cat1 Sales, Cat2 Sales, Cat3 Sales), and need to find the percent of sales for each category, for each year in my data. For instance, if I have: Invoice#Year

Re: $$Excel-Macros$$ Copy and paste

Thanks ...It was very helpful. On Aug 22, 1:37 am, "Rajan_Verma" wrote: > See if it helps : > > > > > > > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > > On Behalf Of bom > Sent: Monday, August 22, 2011 4:40 AM > To: MS EXCEL AND VBA M

Re: $$Excel-Macros$$ BarHide

how about hiding row and column heading for all sheet using VBA? Why the code below doesn't work? *Sub HideRowColEntireWorkbook()* > Dim sh As Worksheet > For each sh in ThisWorkbook.Worksheets > sh.DisplayHeadings=False > Next sh > *End Sub* > 2011/8/25 NOORAIN ANSARI > Dear Sajid, > > Pls try

$$Excel-Macros$$ Need formula

I want to know the formula to find out the solution. For Ex: I have two columns Aru fddfs eder dfds ihcx zesr yes err fddfs dfsf dfds dsdas zesr xzcxc vdfd wewq dst fddfs dfds dfds cfdf zesr zdfdf zcvz drer sdfds 1 2 Nw i would like to sort colu

$$Excel-Macros$$ Cut Data from Rows and Paste into Columns

I have a series of spreadsheets that have data in them that needs to be formatted into 3 columns instead of one column. The data in Row 1 needs to go in row 1, column 1 Row 2 needs to go in row 1, column 2 Row 3 = Row 1, Col 3 Row 4 = Row 2, Col 1 Row 5 = Row 2, Col 2 Row 6 = Row 2 Col 3 Row 7 = R

$$Excel-Macros$$ Conditional Lookup or data validation

Dear All, PFA sample file for your kind consideration. Regards, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join

Re: $$Excel-Macros$$ Multiple sorts on one Sheet

see if it helps Sub SORT_DA() Application.DisplayAlerts = False Application.ScreenUpdating = False Dim lA, I As Long Dim a As Range Set a = Range("D1") For lA = 1 To WorksheetFunction.CountIf(Columns(4), "HD") Set a = Columns(4).Find(What:="HD", After:=a, LookIn:=xlValues

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

There you go =SUM(INDIRECT("'2011 Actual'!$C$3:"&ADDRESS(3,MATCH("*"&TEXT('Monthly IS'!$J$3,"MM/YY")&"*",'2011 Actual'!$A$1:$N$1,0 On Aug 26, 2:28 am, Steve Weaver wrote: > Thank you Sam for this suggestion. However, the formula doesn't provide > the results that I am looking for. > > The fo

Re: $$Excel-Macros$$ BarHide

Dear Sajid, Pls try To Hide Row/Column Heading.. *Sub Hide_Rowcolumn_Heading() ActiveWindow.DisplayHeadings = False End Sub * To Unhide Row/Column Heading.. *Sub Hide_Rowcolumn_Heading() ActiveWindow.DisplayHeadings = True End Sub * On Thu, Aug 25, 2011 at 5:58 PM, SAJID MEMON wrote: > Dear E

Re: $$Excel-Macros$$ Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet

Change "" to 99 if numbers in col a of source sheet -Original Message- From: dguillett1 Sent: Thursday, August 25, 2011 8:06 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet I would probably a

Re: $$Excel-Macros$$ Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet

I would probably also use a macro but if you have a list of sheet names in column A and put this formula in col B and copy over and down =INDEX(INDIRECT($A2&"!a:z"),MATCH("",INDIRECT($A2&"!A:A"),1),COLUMN()-1) -Original Message- From: Clint Stevens Sent: Wednesday, August 24, 2011

Re: $$Excel-Macros$$ BarHide

goto excel option and click on advanced then un check show row and column headers On Thu, Aug 25, 2011 at 5:58 PM, SAJID MEMON wrote: > Dear Experts, > > Plz give attachment requirement code. > > Regards > > Sajid memon > > -- > >

$$Excel-Macros$$ BarHide

Dear Experts, Plz give attachment requirement code. Regards Sajid memon -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : ht

Re: $$Excel-Macros$$ Re: Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet

Hey Noorain, it's perfectly working On Thu, Aug 25, 2011 at 3:43 PM, NOORAIN ANSARI wrote: > Dear Frederic, > > This function LOOKUP(9^9,A:A) is not working.. > We are unable to find Adject Output, it is showing #N/A error.. > -- > Thanks & regards, > Noorain Ansari > *http://noorain

Re: $$Excel-Macros$$ Fwd: regaurding popup XLS

Hey Nandkumar, where is due date column. and use conditional formation for highlighting On Thu, Aug 25, 2011 at 10:07 AM, Nandkumar kakvipure < nandkumar.hindust...@gmail.com> wrote: > > > -- Forwarded message -- > From: shridhar pandit > Date: Thu, Aug 18, 2011 at 12:32 PM > S

Re: $$Excel-Macros$$ Re: Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet

Huh :| Don't you have any problem with your data (like text instead of figure) on the last position ? It works perfectly on my computer On 25 août, 12:13, NOORAIN ANSARI wrote: > Dear Frederic, > > This function LOOKUP(9^9,A:A) is not working.. > We are unable to find Adject Output, i

Re: $$Excel-Macros$$ Conditional Formatting

kindly put 3 condition it self and then send file. try this code Private Sub Worksheet_Change(ByVal Target As Range) Set I = Intersect(Target, Range("B2:B8")) If Not I Is Nothing Then Select Case Target Case 0 To 100: NewColor = 37 ' light blue Case 101 To 200: NewColor = 46 '

Re: $$Excel-Macros$$ Re: Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet

Dear Frederic, This function LOOKUP(9^9,A:A) is not working.. We are unable to find Adject Output, it is showing #N/A error.. -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Thu, Aug 25, 2011 at 2:36 PM, Frederic LE

$$Excel-Macros$$ Re: Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet

Use the function LOOKUP(9^9,A:A) 9^9 = 387420489 Because this value is not in your range A:A, Excel return the last value of your range. Then, you copy/paste this formula 40 times and you just have to change the column's reference. And if the hearder of your report worksheet is equal to the works

$$Excel-Macros$$ Re: Conditional Formatting

I'm not sure that it's possible with xl 2003 because the conditionnal formating must be the same as the range of apply. In xl 2007 and 2010, you can make a test to a range of cell (O2:AS2 in your example) and apply the result to O3:AS11. The conditionnal formating has changed a lot with the new ve

Re: $$Excel-Macros$$ How to attach Excel file here in this post

Dear Zafar, Simply mail your attached file on excel-macros@googlegroups.com On Thu, Aug 25, 2011 at 1:32 PM, Zafar Iqbal wrote: > Dear Group, > > How to attach Excel file here in this post? I cannot find any button > for attaching files here in this page. Please help. Thanks > > Zafar Iqbal > >

$$Excel-Macros$$ Re: Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet

Clint Have you thought about using formulas for your summary sheet? That way you won't need to copy to a summary sheet, repeat the process, and then delete it the following day. The formula will keep your summary sheet constantly updated. You would need to set it up to begin with, but after tha

$$Excel-Macros$$ How to attach Excel file here in this post

Dear Group, How to attach Excel file here in this post? I cannot find any button for attaching files here in this page. Please help. Thanks Zafar Iqbal -- -- Some important links for excel users: 1. Follow us on TWI