Re: $$Excel-Macros$$ Expert help needed - Select the rows based on the columns (using VBA or formula) . -URGENT

2013-05-10 Thread Mathan
scenario-1 to be highlighted or listed separately because i have 5 benefits for those two companies in common. I had given the earlier one for example. sorry for the confusion. Please let me know if still its not clear. Thanks On Fri, May 10, 2013 at 1:50 AM, Mathan wrote: > Hi Expe

$$Excel-Macros$$ Expert help needed - Select the rows based on the columns (using VBA or formula) . -URGENT

2013-05-09 Thread Mathan
. Thanks a lot in advance. regards, Mathan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles

Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer

2013-05-08 Thread Mathan
g on the site > where the file is located. > > We also need to know why VBA code is required, rather than simply a > hyperlink. > > Regards > David Grugeon > > > > On 9 May 2013 06:56, Mathan wrote: > >> Hi Experts, >> >> I'm trying to upload

$$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer

2013-05-08 Thread Mathan
Hi Experts, I'm trying to upload a file from shared folder (directory) to the internet explorer. Need a VBA code to do this. Could anyone help me on this? Thanks in advance. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Face

Re: $$Excel-Macros$$ Re: Hi Anoop

2013-05-02 Thread Mathan
Hi Anoop, Just wanted to let you know the result of implementation of your effort. It saved 35 Hours per month.. :-) Thanks again ! Mathan On Thu, May 2, 2013 at 12:47 PM, Mathan wrote: > Hi Anoop, > > It's working fine. Thanks a lot ! :-) > > Your dedication

Re: $$Excel-Macros$$ Re: Hi Anoop

2013-05-02 Thread Mathan
Hi Anoop, It's working fine. Thanks a lot ! :-) Your dedication is much appreciated ! Regards, Mathan On Thu, May 2, 2013 at 8:58 AM, Anoop K Sharma wrote: > Try this... You can change code as per your requirement. > > Regards, > Anoop > > > On Wed, May 1, 2013

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-24 Thread Mathan
ts. > Create a range there. Use the range as Validation List. When you start > typing in the cell, the list will automatically adjust to match with the > typed words. It is unfortunate the MS has not provided any such > functionality till date. > > On Sat, Apr 13, 2013 at 12:32 AM, Math

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-24 Thread Mathan
Hi, Thanks for taking time out and helping. Does auto correct work even for names? Example, in column A, I have names as following Mathan Raja Ravi if I type 'M' in column B. It should auto fill 'Mathan'. Pls let me know if its not clear. Plz see my first post for more de

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-23 Thread Mathan
e which will replace off into Office >> Supplies. >> >> Just go to file->option->proofing->autocorrect, type off in replace box >> and office Supplies in with box. >> >> --- On *Sun, 4/21/13, Mathan * wrote: >> >> >> From: Mathan >

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-22 Thread Mathan
Hi, Thanks for taking time out and helping. Does auto correct work even for names? Example, in column A, I have names as following Mathan Raja Ravi if I type 'M' in column B. It should auto fill 'Mathan'. Pls let me know if its not clear. Plz see my first post for more de

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-21 Thread Mathan
Hi, thanks for your reply but my requirement is different. Auto complete should work even the words are in different column or different sheet. And it's not work with Alt+down arrow. Thanks On 21/04/2013, xlstime wrote: > Hi Mathan, > > You can use "Pick from drop-down list&

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-21 Thread Mathan
Hi Experts, Any updates on this ? Your help is much appreciated.. Thanks On Sat, Apr 13, 2013 at 12:32 AM, Mathan wrote: > Hello Experts, > > I am looking for an excel add-in that will enable Autocomplete from any > column or Sheet within a workbook > > For example, lets

$$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-12 Thread Mathan
I'm trying with my knowledge but I feel this is an advanced task which I could not get so far. ATTACHED THE SCREENSHOT OF THE EXAMPLE. Thanks in advance. Regards, Mathan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official F

Re: $$Excel-Macros$$ URGENT -Need an Expert to help !

2013-01-08 Thread Mathan
“Do all the good you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *- > > >

Re: $$Excel-Macros$$ Need help on selecting optimal value --- URGENT -Need help !

2013-01-08 Thread Mathan
Hi, Thank you very much. This is simply superb. :-) On 08/01/2013, Swapnil Palande wrote: > Hi Mathan, > > Pls find attached excel for solution. > > Open the attached excel and press "Ctrl + q" to run macro. > > I have added extra 2 columns ("Pieces Remain&qu

$$Excel-Macros$$ Need help on selecting optimal value --- URGENT -Need help !

2013-01-08 Thread Mathan
gt; We need to solve for the minimum number of cycles needed to produce all > the pieces (in this case 105 pieces totaling 10559.75 ft in combined > length). This solution need to also tell me what to produce on the line > each day... > > > Thanks in advance. please let me k

$$Excel-Macros$$ To reduce Excel file size drastically save as [.xlsb] format

2011-11-09 Thread Mathan
Your comments are highly appreciated. Regards, Mathan -- Regards, Mathan -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get

Re: $$Excel-Macros$$ Re: Urgent - MS Excel charts

2010-07-13 Thread Mathan
Hi Dilip, I have created a folder named as "Dilip pandey solutions". I became your fan :) Great... regards, Mathan On Tue, Jul 13, 2010 at 4:12 PM, Ahmed Honest wrote: > Dear Dilip, > > Can you explain the logic, of getting the Unit Price 25-30, > 30-35..

Re: $$Excel-Macros$$ Need help with a lookup

2010-06-30 Thread Mathan
We will have to add one more column in Extracted data sheet to concatenate Area & ID. If it is fine then it is easy. Otherwise I do not have solution. Regards, Mathan On Wed, Jun 30, 2010 at 6:09 AM, Nadine S wrote: > The attached file is a sample of my data. I need to write a

Re: $$Excel-Macros$$ Urgent Help needed regarding using macro

2010-06-25 Thread Mathan
mail.com > dilipan...@yahoo.com > New Delhi - 62, India > > > On Fri, Jun 25, 2010 at 5:38 PM, Aindril De wrote: > >> Hi Dilip, >> >> This is an excellent solution you have provided.. Hats off to you for >> keeping it so simple.. >> >> Cheers, &

Re: $$Excel-Macros$$ Pivot table not showing

2010-06-17 Thread Mathan
Hi, This file is shared. you will have to remove this.. Go to Tools-> share work book-> uncheck the ' allow changes' -> ok Regards, Mathan On Thu, Jun 17, 2010 at 11:29 AM, Deepak Rawat wrote: > Hi friends, > > I got an excel file, in which pivot table option

$$Excel-Macros$$ Re: Need help to select the data columns into pivot table data field using VBA code.....

2009-12-13 Thread Mathan
.g. A to C), column field (e.g. D,E) and data field(e.g. F to N). Thanks in advance. Mathan On Thu, Dec 10, 2009 at 11:20 AM, nayag...@gmail.com wrote: > Hi Mathan, > > I used column A to determine the number of rows that should be > included in the > pivottable range. And I use

Re: $$Excel-Macros$$ Re: Need help to select the data columns into pivot table data field using VBA code.....

2009-12-10 Thread Mathan
A to C), column field (e.g. D,E) and data field(e.g. F to N). Thanks in advance. Mathan On Thu, Dec 10, 2009 at 11:20 AM, nayag...@gmail.com wrote: > Hi Mathan, > > I used column A to determine the number of rows that should be > included in the > pivottable range. And I used Ro

$$Excel-Macros$$ Re: Multiply and/divide with a number

2009-07-29 Thread Mathan
Hi, refer the attached file mathan On 7/29/09, balbirkumar . wrote: > > > Hi Friends > > I want to multiply all cells in the excel sheet with a particular number. > > please help > > With > Tha

Fwd: $$Excel-Macros$$ hi

2009-06-01 Thread Mathan
Hi find the attachment . I tried as much as i can. mathan -- Forwarded message -- From: satish Date: May 29, 2009 2:47 PM Subject: $$Excel-Macros$$ hi To: excel-macros@googlegroups.com Hey People I need a small help, some of you might even find silly I have big list of

$$Excel-Macros$$ How to create Folder and documents with help of macro

2009-04-27 Thread Mathan
*Hi All,* ** *1. How to create a folder and other documents with macro in desktop.. ?* *2. How to get a files as input file through a user form?* ** *pls give me examples.* --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: Show the start and end of groups of cells

2009-04-21 Thread Mathan
*Hi, Please find the attachment for the given problem.. regards, mathan * On Tue, Apr 21, 2009 at 9:26 PM, Geo wrote: > > I have data like this: > > part# location > 1 1B-1-A-01 > 5 1B-1-A-01 > 6 1B-1-A-01 > 14 1B-1-A-02 > 12 1B-1-A-

$$Excel-Macros$$ Re: Sort Table as per the order of records in another Table

2009-03-22 Thread Mathan Kumar
straint couldn't write VBA macro. > Sending you updated file, it has formulas and giving required results. As per > me for this requirements formulas would be better as compare to VBA. > > Feel free to contact for further clarifications or requirements. > > > On 3/21/09,

$$Excel-Macros$$ Re: Sort Table as per the order of records in another Table

2009-03-21 Thread Mathan Kumar
. > > I have created a sample spreadsheet and included the instructions too. > > Hope someone will come up with an excellent code. Looking for that... > > Thanks in advance for your time and efforts. > >