Re: $$Excel-Macros$$ Help in preparing the column automatically

ssage- From: Ankit Agrawal Sent: Saturday, December 10, 2011 9:54 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help in preparing the column automatically Dear Sir, I had some confusion regarding my sheet now it has been clear.Please find my new attachment.plz solve m

Re: $$Excel-Macros$$ Help in preparing the column automatically

nUpdating = False > >Rows(tr - 1).Copy Rows(tr).Resize(2) > >Cells(tr, "c").Resize(, 20).ClearContents > >Rows(tr + 1).ClearContents > > Application.ScreenUpdating = False > > End If > > End Sub > > > > Don Guillett > > SalesAid

Re: $$Excel-Macros$$ Help for If nesting formula

Hi yogi, Can use this formula too... =IF(SUM(--(A1:D1>5))>=2,"Good","Poor") (apply with Ctrl + Shift + Enter) Regards, MARIES. On Mon, Dec 12, 2011 at 7:00 PM, rajan verma wrote: > See the attached File.. > > > On Wed, Nov 30, 2011 at 8:39 PM, Sam Mathai Chacko wrote: > >> This formula would

Re: $$Excel-Macros$$ Help for If nesting formula

Dear Yogi, You can also try through UDF Nested_If *Function Nested_if(rng As Range) counter = 1 For Each cell In rng If cell.Value > 5 Then counter = counter + 1 End If Next If counter > 2 Then Nested_if = "Good" Else Nested_if = "Poor" End If** End Function * On Sat, Dec 10, 2011 at 4

Re: $$Excel-Macros$$ Help for If nesting formula

Glad to help Don Guillett SalesAid Software dguille...@gmail.com From: yogiyogi123 Sent: Saturday, December 10, 2011 8:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help for If nesting formula thankq very much On Sat, Dec 10, 2011 at 8:06 PM, dguillett1 wrote

Re: $$Excel-Macros$$ Help for If nesting formula

011 4:59 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help for If nesting formula > > HAI ALL .I HAVE SMALL DOUBT IN CONDITIONAL (and) function > > Q1) i have four months > > jan feb marapr > > 61 5 0 >

Re: $$Excel-Macros$$ Help for If nesting formula

=IF(COUNTIF(A3:D3,">5")>1,"good","bad") Don Guillett SalesAid Software dguille...@gmail.com From: yogiyogi123 Sent: Saturday, December 10, 2011 4:59 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help for If nesting for

Re: $$Excel-Macros$$ Help for If nesting formula

Hi, Can you explain more or send us the sample. Regards, MARIES. On Sat, Dec 10, 2011 at 2:59 PM, yogiyogi123 wrote: > HAI ALL .I HAVE SMALL DOUBT IN CONDITIONAL (and) function > > Q1) i have four months > > jan feb marapr > > 61 5 0 > > if any two month get

Re: $$Excel-Macros$$ Help for If nesting formula

HAI ALL .I HAVE SMALL DOUBT IN CONDITIONAL (and) function Q1) i have four months jan feb marapr 61 5 0 if any two month get '> 5' then the result is GOOD other wise POOR . KINDLY RECTIFY THIS PROBLEM. THANK Q -- FORUM RULES (934+ members already BANNED for v

Re: $$Excel-Macros$$ Help in preparing the column automatically

Deal All, PFA as per your query. Regards, Ankit On Fri, Dec 9, 2011 at 8:19 PM, dguillett1 wrote: > You need to give examples > col b. could/should be from data validation list > col a. incremented automatically when you enter col B. Example of next > number > col c. same as col B using DV >

Re: $$Excel-Macros$$ Help in preparing the column automatically

You need to give examples col b. could/should be from data validation list col a. incremented automatically when you enter col B. Example of next number col c. same as col B using DV col I. “agreement sheet” ? col J. populated on what__occurring. Don Guillett SalesAid Software dguille...@g

Re: $$Excel-Macros$$ Help for If nesting formula

Hi, Try also without any tables, =LOOKUP(A2,DATE(YEAR(TODAY()),-{1342,35,12,9,6,3}+MONTH(TODAY()),0),{"Prospect";"> 12 Month";"9 - 12 Month";"6 - 9 Month";"3 - 6 Month";"0 - 3 month"}) Or, if you activate Analysis ToolPak AddIn (unless if you are using XL2007 or later), you can simplify, =LO

Re: $$Excel-Macros$$ Help for If nesting formula

Thanx to all my team member and Noorain. On Wed, Nov 30, 2011 at 12:24 PM, NOORAIN ANSARI wrote: > Dear Lucky, > > Please paste below formula in B2 Cell. > > =IF(AND(A2>=$F$2,A2<=$G$2),"0-3 Month",IF(AND(A2>=$F$3,A2<=$G$3),"3-6 > Month",IF(AND(A2>=$F$4,A2<=$G$4),"6-9 > Month",IF(AND(A2>=$F$5,A2<

Re: $$Excel-Macros$$ Help for If nesting formula

Hi Singh, Would you explain the logic for the file? If 1 value is bigger than another 1, you would like the cell to return something, am i right?? Darwin 2011/11/30 lucky singh > > Hello Team, > > > Require your help for If nesting formula please see the attachment. > > > Regards, > Lucky > >

Re: $$Excel-Macros$$ Help for If nesting formula

Dear Lucky, Please paste below formula in B2 Cell. =IF(AND(A2>=$F$2,A2<=$G$2),"0-3 Month",IF(AND(A2>=$F$3,A2<=$G$3),"3-6 Month",IF(AND(A2>=$F$4,A2<=$G$4),"6-9 Month",IF(AND(A2>=$F$5,A2<=$G$5),"9-12 Month",IF(AND(A2>=$F$6,A2<=$G$6),">12 Month","Prospect") On Wed, Nov 30, 2011 at 12:09 PM, luc

Re: $$Excel-Macros$$ Help for stock file

Dear Sir I require a formula which can deducted raw material and packing material when i enter the procution. Example: If i enter production of protozyme II of 5000 kg and use blank granule 4950kg and seaweed 50ltr so when i enter Protozyme II 5000kg it is deducted form raw material and and pack

Re: $$Excel-Macros$$ Help for stock file

You need to explain a bit more with examples Don Guillett SalesAid Software dguille...@gmail.com From: manhar prajapati Sent: Tuesday, November 29, 2011 4:14 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help for stock file Dear All HI Please Find attach file for my quary.

Re: $$Excel-Macros$$ Help me with a macro

Hello Mr Sam, Thank you very much of your help. Regards Son 2011/11/28 Sam Mathai Chacko > Great, so no modifications required for Excel 2010 > > The code below works for both 2003 and 2010 > > > Sub Consolidator() > > Dim rngStart As Range > Dim varArray As Range > > > Applicatio

Re: $$Excel-Macros$$ Help me with a macro

Chacko Sent: Monday, November 28, 2011 8:32 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help me with a macro Great, so no modifications required for Excel 2010 The code below works for both 2003 and 2010 Sub Consolidator() Dim rngStart As Range Dim varArray As Range

Re: $$Excel-Macros$$ Help me with a macro

Great, so no modifications required for Excel 2010 The code below works for both 2003 and 2010 Sub Consolidator() Dim rngStart As Range Dim varArray As Range Application.ScreenUpdating = 0 Range("F1").CurrentRegion.Clear With Cells.Find(What:="Machine", Lookat:=xlWhole, sear

Re: $$Excel-Macros$$ Help me with a macro

Hi Sam I tried on office 2010 ,result is ok.Could you send me a modified version 2003 and explain for me a bit of this code as i am a beginer of VB. Thanks a lot Son 2011/11/28 Sam Mathai Chacko > Son, the macro is written for 2007-10. Will send a modified version, > but before that, can you c

Re: $$Excel-Macros$$ Help me with a macro

Son, the macro is written for 2007-10. Will send a modified version, but before that, can you confirm the result is correct in 2007-10? If not, what is the issue? Sam On 28/11/2011, son nguyen wrote: > Hi Mr Sam. > I wonder this code used for which office as 2003,2007,2010.Because my > office is

Re: $$Excel-Macros$$ Help me with a macro

Hi Mr Sam. I wonder this code used for which office as 2003,2007,2010.Because my office is 2003 and result is not to like my desirement. Hope that you can feed back more to me Regards son 2011/11/27 Sam Mathai Chacko > Here's a macro to get this done > > Sub Consolidator() > > Dim rngStar

Re: $$Excel-Macros$$ Help me with a macro

Hi Rajan, Thank you very much but i like macro better because it is really fast.As you known my sheet is large with lots of rows. Hope that your experience'll help everyone . Regards Son 2011/11/27 rajan verma > Hi > Please see the attached file.. Pivot table can be used for this .. > > Reg

Re: $$Excel-Macros$$ Help me with a macro

Here's a macro to get this done Sub Consolidator() Dim rngStart As Range Application.ScreenUpdating = 0 Range("F1").CurrentRegion.Clear With Cells.Find(What:="Machine", Lookat:=xlWhole, searchDirection:=xlNext, After:=Cells(1)) Set rngStart = Range(.Offset(1), .Offset(, 1).En

Re: $$Excel-Macros$$ Help me with a macro

Hi Please see the attached file.. Pivot table can be used for this .. Regards Rajan On Sat, Nov 26, 2011 at 8:23 PM, son nguyen wrote: > Dear all, > > > I have problem of calculating sheet.Detail as sheet attached. > I want to have a macro to sum value within qty, and downtime column then > del

Re: $$Excel-Macros$$ Help me with a macro

Dear son Here with i attached excel file using sumif command. Mothilal On Sat, Nov 26, 2011 at 8:23 PM, son nguyen wrote: > Dear all, > > > I have problem of calculating sheet.Detail as sheet attached. > I want to have a macro to sum value within qty, and downtime column then > delete produc

Re: $$Excel-Macros$$ Help required for a formula

Thank you seema.   Regards. --- On Fri, 11/25/11, seema mba wrote: From: seema mba Subject: Re: $$Excel-Macros$$ Help required for a formula To: excel-macros@googlegroups.com Date: Friday, November 25, 2011, 4:25 PM Hi, PFA. Query Solved.  Regards, Seema On Fri, Nov 25, 2011 at 7:02

Re: $$Excel-Macros$$ Help required for a formula

if you are saying that g3 should be between d3 and e3 then this formula does it for the CLOSE. =IF(AND(G3>=D3,G3

Re: $$Excel-Macros$$ Help required for a formula

Hi, PFA. Query Solved. Regards, Seema On Fri, Nov 25, 2011 at 7:02 PM, Kenil Gala wrote: > Hi group, > > I have a small doubt for writing a formula and require for help for it. > i have mentioned my doubt as a comment in the attached file. > > > Thanks & Regards > > > -- > FORUM RULES (934+ m

Re: $$Excel-Macros$$ help needs to connect form controls to the table

Dear Sam How to restrict max length of characters in a text box for MS ACCESS 2003 ? On Mon, Nov 21, 2011 at 9:57 PM, Sam Mathai Chacko wrote: > I don't see any remaining doubts! What doubts do you have? > > Sam > > > On Mon, Nov 21, 2011 at 10:57 AM, Shankar Bheema > wrote: > >> thank you so m

Re: $$Excel-Macros$$ help needs to connect form controls to the table

I don't see any remaining doubts! What doubts do you have? Sam On Mon, Nov 21, 2011 at 10:57 AM, Shankar Bheema wrote: > thank you so much sir, if possible pls clarify my remaining doubts. > > > On Sun, Nov 20, 2011 at 1:06 AM, Sam Mathai Chacko wrote: > >> You have to create a recordset by usin

Re: $$Excel-Macros$$ help needs to connect form controls to the table

thank you so much sir, if possible pls clarify my remaining doubts. On Sun, Nov 20, 2011 at 1:06 AM, Sam Mathai Chacko wrote: > You have to create a recordset by using the OpenRecordSet command in the > CurrentDB > > Use > > Private Sub cmdsave_Click() > > Dim rst As Recordset > > Set rst

RE: $$Excel-Macros$$ Help me

Hi Vijayajith, Data validations can be created from one workbook to another workbook. Example: Attached are the two workbook 1. Source_Book.xlsx 2. My_Book.xlsx My list is available in Source_Book - sheet1 - range("A1:A5") and my validation is in workbook - My_Book.xlsx - Sheet1 -

RE: $$Excel-Macros$$ Help Required

@googlegroups.com Subject: Re: $$Excel-Macros$$ Help Required Hi Neeraj, You can use the Consolidate function of Excel to achieve the same. Please follow the link below for the steps: http://support.microsoft.com/kb/214270 Cheers, Andy On Tue, Nov 15, 2011 at 4:00 PM, Neeraj Chauhan

Re: $$Excel-Macros$$ Help Required

Hi Neeraj, You can use the Consolidate function of Excel to achieve the same. Please follow the link below for the steps: http://support.microsoft.com/kb/214270 Cheers, Andy On Tue, Nov 15, 2011 at 4:00 PM, Neeraj Chauhan wrote: > Dear Experts, > > How can I make the qty against particular

Re: $$Excel-Macros$$ Help Required.xlsx

Hello Noorie & Sam; Good ones, but as you know, If a site has LARGE date more than 1 (*not sure does the OP have this situation or not*), this wouldn't work as expected. I think the attached would work. __ HTH Haseeb -- FORUM RULES (934+ members already BANNED for violation) 1)

Re: $$Excel-Macros$$ Help Required.xlsx

t; dguille...@gmail.com > > *From:* NOORAIN ANSARI > *Sent:* Friday, November 11, 2011 4:04 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help Required.xlsx > > Dear Neeraj, > > Please try through below formula, See attached sheet.. > &g

Re: $$Excel-Macros$$ help me

011 at 7:01 PM, wrote: >>> >>>> Copy in a filter mode the desired data then use paste special (alt e s >>>> v ) and select skip blank option. >>>> Hope fully it will solve ur queries. >>>> >>>> Sandeep Chhajer. >>>>

Re: $$Excel-Macros$$ help me

rry® from Vodafone > -- > *From: * vijayajith VA > *Sender: * excel-macros@googlegroups.com > *Date: *Thu, 10 Nov 2011 19:41:37 +0530 > *To: * > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *Re: $$Excel-Macros$$ help me > > > hi > > I have tried u

Re: $$Excel-Macros$$ Help Required.xlsx

In this particular sample you can simply filter by date. However, that may not be what you need in all cases?? Don Guillett SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Friday, November 11, 2011 4:04 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help

Re: $$Excel-Macros$$ Help Required.xlsx

Good one Noorain.. Can you help how this array works please.. Cheers, Andy On Fri, Nov 11, 2011 at 3:34 PM, NOORAIN ANSARI wrote: > Dear Neeraj, > > Please try through below formula, See attached sheet.. > > > =OFFSET($D$1,SMALL(IF($B$2:$B$24=$I2,ROW($D$2:$D$24),""),COUNTIF($I$2:$I2,$I2))-1,0) >

Re: $$Excel-Macros$$ Help Required.xlsx

Dear Neeraj, Please try through below formula, See attached sheet.. =OFFSET($D$1,SMALL(IF($B$2:$B$24=$I2,ROW($D$2:$D$24),""),COUNTIF($I$2:$I2,$I2))-1,0) Press ctrl+shift+enter -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http

Re: $$Excel-Macros$$ Help Required.xlsx

Hi Neeraj, This can be achieved with the use of Pivots. Attached is the Solution. Please let me know if you need any clarification. Cheers, Andy On Fri, Nov 11, 2011 at 2:12 PM, Neeraj Chauhan wrote: > Dear Experts, > > ** ** > > Kindly find the attached sheet. > > I want to only last

Re: $$Excel-Macros$$ help me

To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help me hi I have tried using pastespecial but its working its copying only two cells can you help me ? Pleas find the attachment Thank you On Thu, Nov 10, 2011 at 7:01 PM, wrote: > Copy in a filter mode the desi

Re: $$Excel-Macros$$ help me

al (alt e s v >>> ) and select skip blank option. >>> Hope fully it will solve ur queries. >>> >>> Sandeep Chhajer. >>> Sent on my BlackBerryŽ from Vodafone >>> ---------- >>> *From: * "dguillett1" >>> *Sender: * excel-macros@go

Re: $$Excel-Macros$$ help me

Copy values to an UN filtered destination. Don Guillett SalesAid Software dguille...@gmail.com From: vijayajith VA Sent: Thursday, November 10, 2011 8:11 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help me hi I have tried using pastespecial but its working its

Re: $$Excel-Macros$$ help me

fully it will solve ur queries. >> >> Sandeep Chhajer. >> Sent on my BlackBerryŽ from Vodafone >> -- >> *From: * "dguillett1" >> *Sender: * excel-macros@googlegroups.com >> *Date: *Thu, 10 Nov 2011 07:25:57 -0600 >

Re: $$Excel-Macros$$ help me

To: * excel-macros@googlegroups.com > *Subject: *Re: $$Excel-Macros$$ help me > > Post your file > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* vijayajith VA > *Sent:* Thursday, November 10, 2011 6:11 AM > *To:* excel-macros@googlegroups.c

Re: $$Excel-Macros$$ help me

Please Copy in a filter mode the desired data. Then select all (alt d f s) and in desired column use paste special (alt e s v ) and select skip blank option there. Hope fully it will solve ur queries. Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone -Original Message- From: vijayaj

Re: $$Excel-Macros$$ help me

e: Thu, 10 Nov 2011 07:25:57 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help me Post your file Don Guillett SalesAid Software dguille...@gmail.com From: vijayajith VA Sent: Thursday, November 10, 2011 6:11 AM To: excel-macros@googlegroups.com Subject: $$Excel-Mac

Re: $$Excel-Macros$$ help me

Post your file Don Guillett SalesAid Software dguille...@gmail.com From: vijayajith VA Sent: Thursday, November 10, 2011 6:11 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ help me HI I have some datas in tab with coloumns(code and name) in one more tab with same datas but

Re: $$Excel-Macros$$ help: excel changes macro assignment

Hehe! I knew that Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Wednesday, November 09, 2011 9:53 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help: excel changes macro assignment Hehe, Don, I'm sure he meant 'new' Cli

Re: $$Excel-Macros$$ help: excel changes macro assignment

Hehe, Don, I'm sure he meant 'new' Clinton, Is there any sheet movements in your macro? Maybe worth posting your VBA code. Regards, Sam Mathai Chacko On Wed, Nov 9, 2011 at 6:36 PM, dguillett1 wrote: > You need to post your file or a least your code > How does a jew workbook differ from a gen

Re: $$Excel-Macros$$ help: excel changes macro assignment

You need to post your file or a least your code How does a jew workbook differ from a gentile workbook? Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Clinton James Sent: Tuesday, November 08, 2011 7:55 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macr

Re: $$Excel-Macros$$ Help me

ayajith VA Sent: Monday, November 07, 2011 9:35 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help me Hi Don Guillett, Once again thank you very much . I those two excelbooks saved one folder and named as VA_book1.xls - (one file -blank file) and one more file saved as VA

Re: $$Excel-Macros$$ Help me

os@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help me > > Hi > > Thank you Very much for your help. > > If i run this macros.Some error is showing like VA_book1.xls is not found > error 1004 > > i have saved correctly in my folder i run the macros but its not wor

Re: $$Excel-Macros$$ Help me

Are both files in the same folder? Is the source file named VA_ book1.xls or book1.xls ? Don Guillett SalesAid Software dguille...@gmail.com From: vijayajith VA Sent: Monday, November 07, 2011 9:17 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help me Hi Thank you

Re: $$Excel-Macros$$ Help me

Hi Thank you Very much for your help. If i run this macros.Some error is showing like VA_book1.xls is not found error 1004 i have saved correctly in my folder i run the macros but its not working Please help me On Sun, Nov 6, 2011 at 8:19 PM, dguillett1 wrote: > Never mind. I determined

Re: $$Excel-Macros$$ Help me

In book2 you are filtering col C by what_criteria. Book1 already filtered by what criteria__ Do you want to do this before filtering and before opening book1 or Do you want the macro to filter book2 and open book1>filter>get the data__? Don Guillett SalesAid Software

Re: $$Excel-Macros$$ Help : Live Real Time NSE Cash quotes directly into xls sheet

You can do 2 & 3 with conditional formatting formula1 =a2>f2 format cell color or number color?? formula1 =a2<>g2 format cell color or number color?? . However, you do not say where you are getting your data url___? for 1 & 4 If you have valid YAHOO symbols then I can get with an exter

Re: $$Excel-Macros$$ Help

;> populated with NA >>> >>> Don Guillett >>> SalesAid Software >>> dguille...@gmail.com >>> >>> *From:* Mahreen Ellahi >>> *Sent:* Thursday, November 03, 2011 10:33 AM >>> *To:* excel-macros@googlegroups.com >>>

Re: $$Excel-Macros$$ Help

; >> What do you want when one or the other is NA and how is the cell >> populated with NA >> >> Don Guillett >> SalesAid Software >> dguille...@gmail.com >> >> *From:* Mahreen Ellahi >> *Sent:* Thursday, November 03, 2011 10:33 AM >&g

Re: $$Excel-Macros$$ Help

Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Mahreen Ellahi > *Sent:* Thursday, November 03, 2011 10:33 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help > > I ve to add points scored in each table. When the points are NA, to

Re: $$Excel-Macros$$ Help

ay, November 03, 2011 10:33 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help > > I ve to add points scored in each table. When the points are NA, total is > not possible. Plz see attached file. > > Mahreen > > On Thu, Nov 3, 2011 at 4:49 AM, Hase

Re: $$Excel-Macros$$ Help

What do you want when one or the other is NA and how is the cell populated with NA Don Guillett SalesAid Software dguille...@gmail.com From: Mahreen Ellahi Sent: Thursday, November 03, 2011 10:33 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help I ve to add points

Re: $$Excel-Macros$$ Help

I ve to add points scored in each table. When the points are NA, total is not possible. Plz see attached file. Mahreen On Thu, Nov 3, 2011 at 4:49 AM, Haseeb Avarakkan wrote: > Mahreen, > > If you have multiple ratio values define a name for them each, like > Table1, Table2 & choose which table

Re: $$Excel-Macros$$ Help

Mahreen, If you have multiple ratio values define a name for them each, like Table1, Table2 & choose which table to use. See the attached. HTH Haseeb -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Pleas

Re: $$Excel-Macros$$ Help

Mahreen, I am getting 1 and -2 as answers, and after looking at the formula, I don't think there's anything wrong with the result. I am also able to select NA, or the Scores. Are you facing some other problem? If yes, please explain. Regards, Sam Mathai Chacko On Wed, Nov 2, 2011 at 7:29 PM, Mah

Re: $$Excel-Macros$$ Help

Thanks both of u for the solution :-) I have different cells in my sheet which are to be added which includes both text and number. I am not able generate result with these formulas. Once again help needed. On Wed, Nov 2, 2011 at 12:11 AM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > H

Re: $$Excel-Macros$$ Help

Hello Sam; A nice solution with Validation. Hello Mahreen; If you use "3", "2", "1" (number inside "") this will return the number as text. When you do calculation excel is considering these as text. Use it without "" or you can simplify the formula to; =IFERROR(LOOKUP($E$2,{-9E+300,3;3,1;4,0

Re: $$Excel-Macros$$ Help

Why don't you use something like this =SUMIF(A1:A10,"<>NA") Regards, Sam On Tue, Nov 1, 2011 at 10:58 PM, Mahreen Ellahi wrote: > Hey thanks, but one more prob, wen i sum up all such scores with few > numbers and text NA, i cant derive the total score. Ofcourse its a text > thatsy but is there

Re: $$Excel-Macros$$ Help

Hey thanks, but one more prob, wen i sum up all such scores with few numbers and text NA, i cant derive the total score. Ofcourse its a text thatsy but is there any possibility i can show the result ignoring the NA On Tue, Nov 1, 2011 at 10:23 PM, Sam Mathai Chacko wrote: > Here's how you do it M

Re: $$Excel-Macros$$ Help

Here's how you do it Mahreen. Create a named range using the formula you already have. And in validation, use List, and type NA,=NmRnge where NmRnge is your named range Check attached. Sam On Tue, Nov 1, 2011 at 9:53 PM, Mahreen Ellahi wrote: > Guys > > I have some serious and need some help.

Re: $$Excel-Macros$$ HELP: SHORTEN MY MACRO USING LOOP

Perhaps you can attach a file(s) 1. can be solved with a loop where the file names are listed in a2:a22 Cash Disbursement Schedule.xls" etc sub openfilesinlist() mymonth="OCTOBER" 'or an inputbox asking for the month or in a cell... for each myfile in range("a2:a22") Workbooks.Open Filename:

Re: $$Excel-Macros$$ Help needed..?

Hi Sriram, Please find attached solved sheet. Thanks Mukesh - Original Message - From: sriram ji To: excel-macros@googlegroups.com Sent: Monday, October 24, 2011 7:04 PM Subject: $$Excel-Macros$$ Help needed..? Dear All, Kindly find the attached file, and provide form

RE: $$Excel-Macros$$ Help needed..?

Rossoff Sent: Monday, October 24, 2011 8:16 AM To: 'Asa Rossoff'; excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Help needed..? I agree with Sam that your requirement isn't 100% clear. He gave a solution for one interpretation. I'll flesh out mine. =IFE

RE: $$Excel-Macros$$ Help needed..?

24, 2011 7:54 AM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Help needed..? For book #s starting at 1001 and changing every 10 rows; Put in cell A2: =IFERROR(OFFSET(A2,-10,0)+1,1001) In case of Excel version prior to 2003, which doesn't support I

Re: $$Excel-Macros$$ Help needed..?

Maybe??? =IF(COUNTIF(A:A,D4)>=10,"No","") Don Guillett SalesAid Software dguille...@gmail.com From: sriram ji Sent: Monday, October 24, 2011 8:34 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help needed..? Dear All, Kindly find the attached file, and prov

Re: $$Excel-Macros$$ Help needed..?

So what exactly do you want? Your attachment isn't clear as to what formula you require. >From what I understood, have made a sheet with sequence of receipt leaflets, depending on the number of leaves and starting number. Regards, Sam Mathai Chacko (GL) On Mon, Oct 24, 2011 at 7:04 PM, sriram j

RE: $$Excel-Macros$$ Help needed..?

For book #s starting at 1001 and changing every 10 rows; Put in cell A2: =IFERROR(OFFSET(A2,-10,0)+1,1001) In case of Excel version prior to 2003, which doesn't support IFERROR, use: =IF(ROW(A2)>11,OFFSET(A2,-10,0)+1,1001) Change default book # in formula as desired. Copy down.

Re: $$Excel-Macros$$ HELP REQUIRED

know if u require anything else happy to help. >>>> >>>> Note: in place of your path give \ at the end of the path. i.e. >>>> C:\Documents and Settings\ >>>> >>>> >>>> -- >>>> *From:* Aami

Re: $$Excel-Macros$$ HELP REQUIRED

kbook and paste the code there. >>> >>> let us know if u require anything else happy to help. >>> >>> Note: in place of your path give \ at the end of the path. i.e. >>> C:\Documents and Settings\ >>> >>> >>> --

Re: $$Excel-Macros$$ HELP REQUIRED

; >> let us know if u require anything else happy to help. >> >> Note: in place of your path give \ at the end of the path. i.e. >> C:\Documents and Settings\ >> >> >> -- >> *From:* Aamir Shahzad >> *To:* excel-mac

Re: $$Excel-Macros$$ HELP REQUIRED

- > *From:* Aamir Shahzad > *To:* excel-macros@googlegroups.com > *Sent:* Sunday, 23 October 2011 4:28 PM > *Subject:* Re: $$Excel-Macros$$ HELP REQUIRED > > Can you please brief how to use & apply the codes in excel. > > Aamir Shahzad > > &

Re: $$Excel-Macros$$ HELP REQUIRED

. i.e. C:\Documents and Settings\ > >From: Aamir Shahzad >To: excel-macros@googlegroups.com >Sent: Sunday, 23 October 2011 4:28 PM >Subject: Re: $$Excel-Macros$$ HELP REQUIRED > > >Can you please brief how to use & apply the codes i

Re: $$Excel-Macros$$ Help in Learn advanced excel in noida

Noor is the best teacher . you can contact him. he has great skills in excel . On Sun, Oct 23, 2011 at 10:10 PM, ashish koul wrote: > Contact Noorian Ansari "NOORAIN ANSARI" , > > > On Sun, Oct 23, 2011 at 11:11 AM, ram gopal yadav wrote: > >> Hi all, >> >> Kindly tell me that from where i can l

Re: $$Excel-Macros$$ Help in Learn advanced excel in noida

Contact Noorian Ansari "NOORAIN ANSARI" , On Sun, Oct 23, 2011 at 11:11 AM, ram gopal yadav wrote: > Hi all, > > Kindly tell me that from where i can learn advanced excel in > noida(U.P). > > please tell me the best institute/faculty in noida from where i can > lear macro and VBA > > Thanks in ad

Re: $$Excel-Macros$$ HELP REQUIRED

Can you please brief how to use & apply the codes in excel. Aamir Shahzad On Fri, Oct 21, 2011 at 1:30 AM, hanumant shinde wrote: > yes very much possible with hardly 5 lines of code (if u want it for time > being). > send us the file or use the below code in the file if u can. > > Sub Macro1()

Re: $$Excel-Macros$$ HELP REQUIRED

yes very much possible with hardly 5 lines of code (if u want it for time being). send us the file or use the below code in the file if u can. Sub Macro1() ChDir "Your Path" Dim wrksht As Worksheet         For Each wrksht In ThisWorkbook.Worksheets     wrksht.Select     wrksht.Copy     Activ

Re: $$Excel-Macros$$ Help

Hello Surya; If your data is sorted by Country in Ascending order, use the file sorted_by_Country. The other one will work with sorted or unsorted data. Also used dynamic range. HTH Haseeb -- -- Some important li

Re: $$Excel-Macros$$ Help

Here's an accurate list. Regards, Sam Mathai Chacko (GL) On Mon, Oct 17, 2011 at 8:53 PM, NOORAIN ANSARI wrote: > Dear Ankit, > > Please see attached sheet with explain > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http:

Re: $$Excel-Macros$$ Help

Dear Ankit, Please see attached sheet with explain Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Mon, Oct 17, 2011 at 7:06 PM, Ankit Agrawal wrote: > Hi

Re: $$Excel-Macros$$ Help

Hi Noorain, Could you plz make me understand how has it been done? Thanks Regards, Ankit On Mon, Oct 17, 2011 at 5:27 PM, NOORAIN ANSARI wrote: > Dear Surya, > > Please see attached sheet > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/

Re: $$Excel-Macros$$ Help

Dear Surya, Please see attached sheet -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Mon, Oct 17, 2011 at 4:54 PM, suryaprasad.b

Re: $$Excel-Macros$$ Help

Send sample file On 15 Oct 2011 21:51, "santhu" wrote: > Hi, > > How to extract a text file data to an excel sheet. > > Ex: Sl.no FirstName MiddleName LastName Place > 1 ABC abc India > 2 DEF def ghi A

Re: $$Excel-Macros$$ Help

Try importing data from external file > Text file. When you import, you'll get an option to use a delimiter. Normally, text files are delimited using tab, or space. Regards, Sam Mathai Chacko (GL) On Sat, Oct 15, 2011 at 6:25 PM, XLS S wrote: > Kindly send text file.. > > On Sat, Oct 15, 201

Re: $$Excel-Macros$$ Help

can you attach the sample file On Sat, Oct 15, 2011 at 5:55 PM, santhu wrote: > Hi, > > How to extract a text file data to an excel sheet. > > Ex: Sl.no FirstName MiddleName LastName Place > 1 ABC abc India > 2 DEF def

Re: $$Excel-Macros$$ Help

Kindly send text file.. On Sat, Oct 15, 2011 at 5:55 PM, santhu wrote: > Hi, > > How to extract a text file data to an excel sheet. > > Ex: Sl.no FirstName MiddleName LastName Place > 1 ABC abc India > 2 DEF def

Re: $$Excel-Macros$$ Help required

Should do it. Or just use AUTOFILTER on the original to get one at a time to view. Option Explicit Sub GetCountryData_SAS() 'fire while at Tes sheet Dim lr As Long Dim i As Long Columns("I").Delete lr = Cells(Rows.Count, 1).End(xlUp).Row 'get unique list Range("h1:h" & lr).AdvancedFilter Action:=

<    2   3   4   5   6   7   8   9   10   11   >