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

very nice thanks From: Maries To: excel-macros@googlegroups.com Sent: Saturday, May 5, 2012 5:45 PM Subject: Re: $$Excel-Macros$$ Need macro website Hi,  Check below link, http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm Regards, MARIES.

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

If the text is indeed identical, I have not heard of any problems with comparison. How are you comparing the text? With formulas, a macro, or some other method? One problem that comes up for people working with text in Excel, sometimes, is that there are characters that LOOK identical, but

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

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 based on whenever > there is a match on ozip

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

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 five times. Important: If the date column is blank and Name column having data macro should g

$$Excel-Macros$$ match 2 columns

hi i would like to have wgt column in sheet 1 updated based on whenever there is a match on ozip and dzip columns in sheet1 and sheet 2. Can u pls give exact formula? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Plea

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

If you are using excel 2007 and previous version of you will not be able to record macro of working with Shapes and Charts.. you can do this in Excel 2010 J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behal

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

Dear karthik you can also learn VBA by your self and for this you just need to record macro for anything you do. *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation* On Sun, May 6, 2012 at 7:07 PM, Prajakt Pande wrote: >

RE: $$Excel-Macros$$ $$Excel-Macros$$ $$Excel-Macros$$ Formula Need for difference between days

You can use this non Array function to Calculate the day to completion of starting month =DAY(DATE(YEAR(A2),MONTH(A2)+1,0)-DAY(A2)+1) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Maries Sent:

Re: $$Excel-Macros$$ Formula for discount of third item bought by a customer

Thanks. The logic is for every three items, the third is free nd the free should be the lowest price. The items should be arranged in order they are bought in batches of three. See attached On 6 May 2012 16:39, dguillett1 wrote: > A VERY simple formula for the 1st question. > =LARGE($d$2:$c$4,

RE: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?

You mean, You want to know how many cells you can fill in a minute? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Indrajit $nai Sent: 05 May 2012 03:57 To: excel-macros@googlegroups.com Subject: $$E

Re: $$Excel-Macros$$ Charts

Provide a file Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: joseph.cam...@gmail.com Sent: Saturday, May 05, 2012 2:23 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Charts Sent on my BlackBerryŽ from Vodafone -

Re: $$Excel-Macros$$ Formula for discount of third item bought by a customer

A VERY simple formula for the 1st question. =LARGE($d$2:$c$4,1)+LARGE($d$2:$c$4,2) More info on the logic with examples of the 2nd Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Robinson Boreh Sent: Sunday, May 06, 2012 7:46 AM To: excel-macros@googlegroups.com

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

Dear, Instated of learn from web site, just try your self with small small tools it will help you lot, i learn like this only this is my personal experience. all the best. Thanks & Regards, Prajakt Pande +971551388482 ** On Sun, May 6, 2012 at 5:09 PM, Bé Trần Văn wrote: > ** > > 2012/5/5 Ma

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

** 2012/5/5 Maries > Hi, > > Check below link, > > http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm > > > Regards, > > MARIES. > > > On Sat, May 5, 2012 at 4:41 AM, karthik N wrote: > >> Hi Friends, >> >> >> How learn the macro's in step by step,kindly provide the any macro >>

Re: $$Excel-Macros$$

Hi Smitha, please find attached sheet with correction in formula you just have to put Opening stock in inverted comms. i.e. " Opening stock " thanks rajesh On Sun, May 6, 2012 at 2:37 PM, Smitha S R wrote: > Hi, > > > > Any one please help: > > > > PFA the attachment of office stock. > > > >

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

HI Please try below one =IFERROR(VLOOKUP(D2,'Utilization and Closing stock'!A2:C19,3,FALSE)," ") 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: >> >> >> >> PFA the attachment of office stock.

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

On Sun, May 6, 2012 at 2:37 PM, Smitha S R wrote: > Hi, > > > > Any one please help: > > > > PFA the attachment of office stock. > > > > One sheet shows the closing stock of stationery items. > > > > In the second sheet, if I select particulars as Opening stock I need toe > get the closing stock

$$Excel-Macros$$

Hi, Any one please help: PFA the attachment of office stock. One sheet shows the closing stock of stationery items. In the second sheet, if I select particulars as Opening stock I need toe get the closing stock of that Particular item, else for Purchase and Issue I have to manually ente

RE: $$Excel-Macros$$ Formula required for finding Consumption value for giving cons. Qty.

Thank You Maries for your try.. The output is what I wanted but the way is not as per my need. I have a huge file in which there are about 25 sheets. Out of which one sheet is named as "PURCHASE" another is as "Consumption" In purchase there are many items are purchased on different dates

Re: $$Excel-Macros$$ Formula required for finding Consumption value for giving cons. Qty.

Revised... On Sun, May 6, 2012 at 12:19 AM, Maries wrote: > Hi, > > Find the attachment I hope this fulfill your requirements > > Regards, > > MAIRES. > > > On Sat, May 5, 2012 at 11:37 PM, BS CTC wrote: > >> FIFO calculation means calculation on the basis of First In First Out.** >> *

Re: $$Excel-Macros$$ Formula required for finding Consumption value for giving cons. Qty.

Hi, Find the attachment I hope this fulfill your requirements Regards, MAIRES. On Sat, May 5, 2012 at 11:37 PM, BS CTC wrote: > FIFO calculation means calculation on the basis of First In First Out.*** > * > > ** ** > > In a year we purchase goods on different rates, > > For Exam