Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

Glad to help Don Guillett SalesAid Software dguille...@gmail.com From: Jorge Marques Sent: Wednesday, February 22, 2012 10:00 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting Hi, Aamir Shahzad was option was good, but it suited

Re: $$Excel-Macros$$ Help plz

=IF(AND(A1>=3000,A1=<4500),B1*0.5,"") On Wed, Feb 22, 2012 at 11:14 PM, Seraj Alam wrote: > Please try this in C1 > > =IF(A1>=3000,IF(A1<=4500,B1*0.5,""),"") > > > seraj alam > > > On Tue, Feb 21, 2012 at 12:31 AM, m7md.gmail wrote: > >> Please check attached >> I need this function necessary

$$Excel-Macros$$ Looking for a Macro which can capture the keystroke timing....

Hi All, Is there any coding is available which can capture the "Keystroke" in a Excel file, Like whenever I am pressing alt+ctrl+del or locking the system it will automatically capture the timing in a Excel file. If the coding is available then please provide me the same. Thanks in advance for al

Re: $$Excel-Macros$$ Looking for a Macro which can capture the keystroke timing....

check whether this help http://www.rondebruin.nl/key.htm Thanks Chilexcel 2012/2/22, Indrajit $nai : > Hi All, > > Is there any coding is available which can capture the "Keystroke" in a > Excel file, Like whenever I am pressing alt+ctrl+del or locking the system > it will automatically captur

$$Excel-Macros$$ not to be published

Hi, Could I have this discussion I have initiated : "To excel macro team" be deleted. http://groups.google.com/group/excel-macros/browse_thread/thread/fc324012cef2c1b2/9c2867243b9cc606?lnk=gst&q=bpascal123#9c2867243b9cc606 I don't think it's relevant and it's not really related to Vba. Regards, Pas

RE: $$Excel-Macros$$ macro to sort excel data & email to party

Dear All, I am not sure what are the rules to define "high priority". I am not sure why this was taken other way round. Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: 22 February 2012 18:57 To: excel-macros@googlegrou

RE: $$Excel-Macros$$ Help with code please.

Hey Don, I wasn't saying my modification would be faster. Find starts searching immediately AFTER the beginning of the LookIn range, so if there are multiple instances of the search term in the range, the user might be surprised that it doesn't find the first instance. Find/Findnext will loop ar

Re: $$Excel-Macros$$ Shotcut Security Warning

Unfortunately this macro is for a client and for security / confedentiality reasons I can't publish anything at all. It has always worked fine and as far as we can tell nothing has changed. I really just wondered if perhaps a windows or office update could affect this and if anyone had a similar

Re: $$Excel-Macros$$ Help plz

thanks :) On Tue, Feb 21, 2012 at 8:41 PM, Sam Mathai Chacko wrote: > =IF(AND(A1>=3000,A1<=4500),B1*0.5,B1) > > Sam Mathai Chacko > > > On Tue, Feb 21, 2012 at 2:01 PM, m7md.gmail wrote: > >> Please check attached >> I need this function necessary now . >> >> thanks, >> >> >> * >> --

$$Excel-Macros$$ Business Days Query

Hi, i am using =networkdays(A1,today()) and cell A1 is 2/1/12. the problem is, we have night shift in office and after 12:00 AM the business day changes to next day and the Value change form 16 to 17. is there any way so that this will not change before morning 7:00 AM. also, i cannot change the c

Re: $$Excel-Macros$$ Help plz

thanks :) On Wed, Feb 22, 2012 at 2:47 PM, m7md.gmail wrote: > thanks :) > > > On Tue, Feb 21, 2012 at 8:41 PM, Sam Mathai Chacko wrote: > >> =IF(AND(A1>=3000,A1<=4500),B1*0.5,B1) >> >> Sam Mathai Chacko >> >> >> On Tue, Feb 21, 2012 at 2:01 PM, m7md.gmail wrote: >> >>> Please check attached >>>

$$Excel-Macros$$ Meaning of minus minus or -- in an Excel function

Hi Cyberspace, I'd like to understand the meaning of "--" in front of an Excel function like : =--sumproduct(...) =--substitute(...) ... and other I can't recall I know that in some programming language it's a way to "decrement" a variable like i = i - 1 can be i-- or --i following the precedence

Re: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel function

Dear johann, The -- is used as an unary operator to convert a boolean value ie, TRUE/FALSE in to 1/0. Sumproduct for example does not evaluate non-numeric values that results in a formula like the boolean results in the array equation A1:A10="johann". So to negate this, we use unary operator -- w

Re: $$Excel-Macros$$ Business Days Query

Hi Sushil, In Networkdays formula, use NOW() function and then you can play around with Time available in NOW() as today() do not have this feature. Thanks. Regards, DILIPandey On 2/23/12, Sushil Kumar wrote: > Hi, > > i am using =networkdays(A1,today()) and cell A1 is 2/1/12. the problem >

Re: $$Excel-Macros$$ search via macro like excel

Dear MARIES, Thank you very much. On Tue, Feb 21, 2012 at 8:44 PM, Maries wrote: > Hi Prajakt, > > Please find the attached file.I have used below codes in user form. > > Private Sub CommandButton1_Click() > > Dim rng1 As Range > Dim lll As Integer > > Sheets("Sheet2").Select > Cells.Se

Re: $$Excel-Macros$$ macro to sort excel data & email to party

Dear Amit, Its mean that when ever you send your mail next time set your email priority to normal rather than urgent. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: "Amit Desai (MERU)" Sender: excel-macros@googlegroups.com Date: Thu, 23 Feb 2012 07:01:40

Re: $$Excel-Macros$$ Business Days Query

Dear Sushil, Please check below link, hope it might be help to you.. http://www.teachexcel.com/excel-help/interstitial.php?i=309802&src=button http://www.mrexcel.com/forum/showthread.php?t=451891 -- Thanks & regards, Noorain Ansari *http://noorainansari.com/*

RE: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel function

Hi Johann, To add to Noorain's explanation: Boolean (True/False) values cannot be added, multiplied, averaged, etc. by aggregate functions such as SUM(), PRODUCT(), AVERAGE(), MEDIAN(), and SUMPRODUCT. In fact, boolean values are always completely ignored by aggregate functions. To summar

$$Excel-Macros$$ images export in Excel with Image name and Hyperlink

Dear All, One folder of images export in Excel with Image name and Hyperlink,,-- *Thanks&Regards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical & Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near

Re: $$Excel-Macros$$ Number gets change by modification

I opened the file with Excel, chose Delimited, put "," (comma without quotes) in Delimiters>Others box and it worked fine. No issues. Am I missing something? On Thu, Feb 23, 2012 at 12:52 PM, PrIyAnKa wrote: > Dear Team > > Kindly find the attached file > > When i open the file with Excel or us

Re: $$Excel-Macros$$ images export in Excel with Image name and Hyperlink

Dear Veeru, try it.. Insert-Object-Adobe Photoshop Image/Bitmap Image-Create From File -Browse-Link to File-Ok -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ doubt with setfocus

thank you for solution On Tue, Feb 21, 2012 at 3:24 PM, Prajakt Pande wrote: > Dear shankar, > > I tried to solve your problem > > PFA > > On Tue, Feb 21, 2012 at 12:47 PM, Shankar Bheema > wrote: > >> Dear Experts >> >> I am enclosing the attachment which was solved by NOORAIN. but when I >> a

Re: $$Excel-Macros$$ Rounding Numbers

Dear JP, See attached sheet.. On Wed, Feb 22, 2012 at 1:04 PM, Jayaprakash S wrote: > Dear Experts, > > Good Noon. > > Need help on rounding up of numbers based on the decimal through a > formula... > > the criteria for roudning is : > > a) Less than or equal to 0.5 should get round down to prec

Re: $$Excel-Macros$$ Rounding Numbers

Thanks Dear Noorain, superb !! =ROUND(MROUND(A1,0.4),0.5) - this formula also works :-) Mr. Sanjib - It is not working per my requirement - thank u for your effort.. cheers JP. On Wed, Feb 22, 2012 at 1:04 PM, Jayaprakash S wrote: > Dear Experts, > > Good Noon. > > Need help on rounding up of

Re: $$Excel-Macros$$ Rounding Numbers

Hi, Subtract 0.1 from your value and Try Rount formula. *=ROUND(A1-0.1,0.2)* Regards, MARIES On Wed, Feb 22, 2012 at 12:14 PM, NOORAIN ANSARI wrote: > Dear JP, > > See attached sheet.. > > On Wed, Feb 22, 2012 at 1:04 PM, Jayaprakash S > wrote: > >> Dear Experts, >> >> Good Noon. >> >> Need h

Re: $$Excel-Macros$$ Rounding Numbers

On Wed, Feb 22, 2012 at 1:18 PM, Maries wrote: > Hi, > > Subtract 0.1 from your value and Try Rount formula. > > *=ROUND(A1-0.1,0.2)* > > Regards, > > MARIES > > On Wed, Feb 22, 2012 at 12:14 PM, NOORAIN ANSARI > wrote: > >> Dear JP, >> >> See attached sheet.. >> >> On Wed, Feb 22, 2012 at 1:04

Re: $$Excel-Macros$$ Rounding Numbers

Thanks a Ton Maries!!! you made the formula so simple :-) cheers Jp. On Wed, Feb 22, 2012 at 2:48 PM, Maries wrote: > Hi, > > Subtract 0.1 from your value and Try Rount formula. > > =ROUND(A1-0.1,0.2) > > Regards, > > MARIES > > On Wed, Feb 22, 2012 at 12:14 PM, NOORAIN ANSARI > wrote: >> >> D

Re: $$Excel-Macros$$ Help with code please.

Thanks so much guys!! Works like a charm, Again thanks you!! On Feb 21, 8:14 pm, Sam Mathai Chacko wrote: > Don, your code works fine for the selection. I would gladly accept any > correction if somebody did that to me. My only point is that > 1. Find doesn't stop the loop > > in other words, the

Re: $$Excel-Macros$$ Help with code please.

OK. I had thought that the SELECTION would stop the loop. So, I went back and tested and you are CORRECT.. See msgbox line which showed sheet4 even tho find was on sheet3. Next time I will exit the for Sub lookinallsheets() For Each ws In Worksheets With ws == MsgBox .Name ==

Re: $$Excel-Macros$$ macro to sort excel data & email to party

Why is YOUR request more HIGH PRIORITY than others. Some of us take this differently than you might desire. DELETE. Don Guillett SalesAid Software dguille...@gmail.com From: Amit Desai (MERU) Sent: Tuesday, February 21, 2012 11:46 PM To: excel-macros@googlegroups.com Subject: FW: $$Excel-Macro

Re: $$Excel-Macros$$ how to find a text in a folder

please use same software for any data type.. On Wed, Feb 22, 2012 at 12:21 AM, raghu gr wrote: > hi, > > This is working fine for searching text, how to search for numbers sir, > > means example if i want search a invoce number 2000127845 in a folder in > which there are 50 files. > > > Thank yo

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

Hi, Aamir Shahzad was option was good, but it suited me for doing another thing in another report, but i needed in a macro format in order to delete the data whenever i pull a report, dguillett1 was exactly as i wanted :). thank you very much both of you. 2012/2/20 dguillett1 > I didn’t do col