$$Excel-Macros$$ MACRO FOR DATA SORT

Dear Experts, Kindly advise macro to sort data by dt of opening & Macro shd run if the range of data is changed Thanks in advance Regards, Prashant -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urge

$$Excel-Macros$$ Re: pls help for dis

On Thu, Apr 16, 2009 at 10:46 AM, rohit patel wrote: > i just want to link dis 1 sheet (Vendor April .09 demo) to Receiving > status(supplier)mar.09 demo, i just want dat if we entered the data > in Receiving status(supplier)mar.09 demo the effect should be show in dis > file (Vendor April .09

RE: $$Excel-Macros$$ Count & sum color cell, cells have conditional formatting

Chil, Also see Bob Phillip's method @ http://www.xldynamic.com/source/xld.CFConditions.html -Original Message- From: Asa Rossoff [mailto:a...@lovetour.info] Sent: Monday, May 07, 2012 4:08 PM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Count & sum color cell, cells

RE: $$Excel-Macros$$ Count & sum color cell, cells have conditional formatting

Excel has no function to determine conditional formats of cells -- you have to evaluate the same formulas used to color the cells again yourself to determine what color/format the cell will have received. The "simplest" solution is probably to use VBA to evaluate the CFs, see http://www.cpearson.c

$$Excel-Macros$$ Reporting Lead required - Pittsburgh, PA

*Hi,* *This is Arvind , - Recruitment and Resources from SancroSoft USA Inc.* We have an urgent requirement as follows: Please respond with resumes in MS-Word Format with the following details to *arv...@sancrosoftusa.com* Full Name : Location : Contact Number : Email : Availability : Visa Stat

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

Yes, it will be sorted already. On Mon, May 7, 2012 at 11:29 PM, Asa Rossoff wrote: > Will the list already be sorted when the button is pressed? > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Excel_Lover > *Sent:* Monday, May 07,

RE: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

Will the list already be sorted when the button is pressed? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Excel_Lover Sent: Monday, May 07, 2012 1:18 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ To create a serial number based on s

Re: $$Excel-Macros$$ Chart-Secondary Axis option

Thanks Noorains On Fri, May 4, 2012 at 5:29 PM, ╰» ℓαℓιт мσαнη wrote: > Try these link also > > www.nios.ac.in/basiccomp/l12.pdf > > > http://mac2.microsoft.com/help/office/14/en-us/excel/item/301ec775-d4b3-452d-85af-55df53ff6db8 > > *Regards,* > *Lalit Mohan* > *https://www.facebook.com/buziness

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

It should be assigned to a button. On Mon, May 7, 2012 at 10:43 PM, Asa Rossoff wrote: > Hi Excel_Lover, > > When would you like the Req.No's to be generated? Should they be > permanent numbers once calculated, or can the be recalculated at any time > (for example with a formula)? Will the

RE: $$Excel-Macros$$ My First Excel Program

Hi Hilary, looks good! My first question: You're a 14 year old single mom?! And an Excel whiz to boot. Please update on how it is coming along, and I will try to help with some of your remaining troubles! Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.co

$$Excel-Macros$$ Reporting Lead required - Pittsburgh, PA

*Hi,* *This is Arvind , - Recruitment and Resources from SancroSoft USA Inc.* We have an urgent requirement as follows: Please respond with resumes in MS-Word Format with the following details to *arv...@sancrosoftusa.com* Full Name : Location : Contact Number : Email : Availability : Visa Stat

Re: $$Excel-Macros$$ How to populate a browse window to select a file and capture the filename with full path?

Hello, I have a file which will grab lots data from another file called data-source file, the data-source will change name depends on date and comments, e.g. DS-0507.xls or DS-0507 with comments.xls ..., since the file name is not consistent, I will have to change my formula every time. Theref

RE: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

Hi Excel_Lover, When would you like the Req.No's to be generated? Should they be permanent numbers once calculated, or can the be recalculated at any time (for example with a formula)? Will the list always be sorted in the order you want used for Req.No. logic? Asa From: excel-macros@

RE: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

HI Sometimes using VBA is not a good approach to accomplish the task, when we can do the same by excel native formulas, So the best is to use formula when it can be easily done. J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros

Re: $$Excel-Macros$$ Macro required to add demand to substitution part and zero out the original one, see attachment.

Hi Maries, I have checked the file but all numbers, no formula inside ... hence, the macro needs to do something on the data itself not to create another sheet. The sample I provided is to show what result I want to see not meaning it will be 2 sections of the data, I guess using formula will n

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

Dear Rajan, Thanks for your effort, I was seeking for a macro solution for this. How is it possible, please let me know. Thanks, On Mon, May 7, 2012 at 8:13 PM, Rajan_Verma wrote: > Hi > > ** ** > > Please find the attached File > > ** ** > > *=IF(OR(COUNTIF($C$1:C2,C2)>=5,E3<>E2),C2

Re: $$Excel-Macros$$ Macro required to add demand to substitution part and zero out the original one, see attachment.

Hi Tony, I have done by formula... Just check the sheets cells. There is no Macro codes inside. Regards, MARIES. On Mon, May 7, 2012 at 5:13 PM, Tony Wu wrote: > Sorry ... I didn;t see the Macro in the attachment. > thanks, > Tony > > > On Saturday, May 5, 2012 9:23:46 AM UTC-4, Maries wrote:

RE: $$Excel-Macros$$ need Macro

Please see the attached file I declare a public range variable which will set by Target Range on Worksheet Change Event At before Close worbook Event Pubic Variable will have a Name rngLastRecord At Workbook Open , Msgbox will Display the Information about rngLastRecord Range and Will Delet

RE: $$Excel-Macros$$ Problems Comparing New Line Character in Strings

You can use Clean("String") Function before comparison Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Alan Sent: 30 April 2012 3:33 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Problem

RE: $$Excel-Macros$$ match 2 columns

Hi Sara You can also use =SUMPRODUCT(--(Sheet2!$A$2:$A$7=Sheet1!B2)*--(Sheet2!$B$2:$B$7=Sheet1!C2)*Sh eet2!$C$2:$C$7) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 07 M

Re: $$Excel-Macros$$ repeat ACTION AS PER FILTER

Are you saying you want to do this for each item in col R or enter x for in col S for each to do CALCULATION 45 6 x 4 3 12 3 x 4 2 x 62 33 65 Don Guillett Microsoft MVP Excel SalesAid Software

Re: $$Excel-Macros$$ repeat ACTION AS PER FILTER

Dear, Attached sheet with recorded macro. i think by this way i can explain you better. I am sorry for this. Thanks & Regards, Prajakt Pande +971551388482 ** On Mon, May 7, 2012 at 5:47 PM, dguillett1 wrote: > I do NOT understand your explanation. > > Don Guillett > Microsoft MVP Exce

Re: $$Excel-Macros$$ repeat ACTION AS PER FILTER

I do NOT understand your explanation. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Prajakt Pande Sent: Monday, May 07, 2012 8:20 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ repeat ACTION AS PER FILTER Dear, Please find enclosed herew

Re: $$Excel-Macros$$ INCOME TAX CALCULATION AND FORM 16 AND QUERTERLY RETURN

sir , i have to calculate the income tax of about 300 employees and have to generate form 16 and form 24 etc with printing facility..our departmental pakage(india post) is not working properly that's why i have to do all the work in excel and its very tedious..please create some macro or vb i

Re: $$Excel-Macros$$ repeat ACTION AS PER FILTER

Dear, Please find enclosed herewith what you requested. i apologies for inconvenience, attached sheet for your reference. Thanks & Regards, Prajakt Pande +971551388482 ** On Mon, May 7, 2012 at 5:01 PM, dguillett1 wrote: > Your sample only shows one row per number. You say copy to next >

Re: $$Excel-Macros$$ Macro required to add demand to substitution part and zero out the original one, see attachment.

Sorry ... I didn;t see the Macro in the attachment. thanks, Tony On Saturday, May 5, 2012 9:23:46 AM UTC-4, Maries wrote: > > Hi, > > Check the attachment. > > Regards, > > MARIES. > > On Fri, May 4, 2012 at 12:27 PM, Tony Wu wrote: > >> Hello, >> >> I have a file for the forecast demand, so

Re: $$Excel-Macros$$ repeat ACTION AS PER FILTER

Your sample only shows one row per number. You say copy to next file???. Pls provide larger representative sample and a better explanation. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Prajakt Pande Sent: Monday, May 07, 2012 7:32 AM To: excel-macros@googlegroup

Re: $$Excel-Macros$$ pls help with matching postal codes

Tested in the source sheet. This is an array formula entered using CSE =INDEX($C$1:$C$140,MATCH(MIN(ABS($C$1:$C$140-E1)),ABS($C$1:$C$140-E1),0)) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Sara Lee Sent: Monday, May 07, 2012 5:54 AM To: excel-macros@googlegroups

$$Excel-Macros$$ repeat ACTION AS PER FILTER

Dear All, Please help me in this. attached file for your reference. What I am looking for, 01) macro filter data by number 1,2,3,4,5,. and so on 02) copy date paste it in to next file what ever the number filter by macro that many time repeat the action. Note:- it can't say filter will be

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

Yes Mr. Excel_Lover, Please provide more clarification. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, May 7, 2012 at 2:50 AM, Excel_Lover wrote: > Dear All, > > Appreciate an help to write a macro to create a request number as per the > bel

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

Was my question not clear? On Mon, May 7, 2012 at 12:20 AM, Excel_Lover wrote: > Dear All, > > Appreciate an help to write a macro to create a request number as per the > below condition. > > for each name on the same date should be a same request number, but should > not be repeated more than

Re: $$Excel-Macros$$ pls help with matching postal codes

actually, if there is no exact value, it should give me next smallest or largest value- which ever is closest. i tried vlook up with true- but a lot of cases, it is not the closest. pls check out after u use vlookup true. It is not always the closest Best case scenario is exact and then next

Re: $$Excel-Macros$$ need Macro

Hi Chetan, You can create a log tab in your workbook and place the code in "This workbook" section of that excel on Close event to update that log with username and time. Regards Shekhar Sharma On Mon, May 7, 2012 at 1:25 AM, B.N.Chethan Kumar wrote: > Dear Excel Gurus, > > I need BIG help fro

Re: $$Excel-Macros$$

Hi Smitha, In case of 2003 Version you can also use. =SUMPRODUCT(('Utilization and Closing stock'!$A$2:$A$19='May 2012'!D2)*('May 2012'!$B$2:$B$19="Opening Stock")*('Utilization and Closing stock'!$C$2:$C$19)) -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogsp

Re: $$Excel-Macros$$ Office stock consumption - formula needed to solve the attached.

Hi Smitha, Please share your workbook with group. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Sun, May 6, 2012 at 2:38 PM, Smitha S R wrote: > > On Sun, May 6, 2012 at 2:37 PM, Smitha S R wrote: > >> Hi, >> >> >> >> Any one please help: >> >>

Re: $$Excel-Macros$$ INCOME TAX CALCULATION AND FORM 16 AND QUERTERLY RETURN

Dear Tarun, Please also visit here.. http://www.pankajbatra.com/ On Mon, May 7, 2012 at 2:19 PM, Tarun Mondal wrote: > Sir, > I want a income tax calculating software or excel sheet bywhich > i can calculate annual tax and take easy report of querterly and > monthly return and can prepare f

Re: $$Excel-Macros$$ pls help with matching postal codes

Hi Sara, You can also you use.. *=IFERROR(LOOKUP(H2,Sheet1!$C$1:$C$72),"")* -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, May 7, 2012 at 9:39 AM, Sara Lee wrote: > > > -- > > *col i *in Sheet 2 needs to be filled up > > by looking

Re: $$Excel-Macros$$ Help Required to update off days in a tracker

hello everyone, please help with the query below. Regards Seema On Saturday, 5 May 2012 17:54:42 UTC+5:30, Seema wrote: > hi, > > thankyou. the tracker looks good. but it allows the user to have the same > day off for two consecutive weeks. and also allows the user to choose > multiple da

Re: $$Excel-Macros$$ Need macro website

Dear Karthik, Please download ebook from below mentioned website..and follow excel macro group on regular basis. http://search.4shared.com/q/CCAD/1/excel%20vba?suggested -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Sat, May 5, 2012 at 5:11 PM,

Re: $$Excel-Macros$$ match 2 columns

Hi Sara, Please use.. * =INDEX(Sheet2!$C$2:$C$7,MATCH(1,(Sheet2!$A$2:$A$7=Sheet1!B2)*(Sheet2!$B$2:$B$7=Sheet1!C2),0)) *or * =LOOKUP(2,1/((Sheet2!$A$2:$A$7=Sheet1!B2)*(Sheet2!$B$2:$B$7=Sheet1!C2)),Sheet2!$C$2:$C$7) * with ctrl+shift+enter See attached sheet,,, -- Thanks & regards, Noorain Ansa

Re: $$Excel-Macros$$ match 2 columns

2012/5/7 ╰» ℓαℓιт мσαнη > Dear Sara, > > PFA > > *Regards,* > *Lalit Mohan* > *https://www.facebook.com/buzinesstransformation* > > > > On Sun, May 6, 2012 at 11:35 PM, Sara Lee wrote: > >> hi >> i would like to have wgt column in sheet 1 updated

Re: $$Excel-Macros$$ Rounding value of six digit

Thanks Asa for very useful information.. On Sat, May 5, 2012 at 7:14 AM, Asa Rossoff wrote: > Hi Shekhar, > > ** ** > > Either of these: > > =ROUNDDOWN(A1,-3) > > =MROUND(A1-500,1000) > > ** ** > > If you wanted to round to the nearest multiple of 1000, instead of > rounding down

Re: $$Excel-Macros$$ Rounding value of six digit

Asa and Maries, Thanks so much for providing the formulas. I was looking for the same kind of formulas. Thanks Shekhar Sharma On Sat, May 5, 2012 at 6:26 PM, Maries wrote: > Try this too, > > =QUOTIENT(A1,1000)*1000 > > > On Sat, May 5, 2012 at 5:47 AM, Maries wrote: > >> *Asa, Good Informati