Re: $$Excel-Macros$$ Macro to sort data in Ascending/Descending order

Hi Sandip, Please find the attached file. Feel free to ask further for any query. Regards Sandeep Kumar On Wed, Jan 26, 2011 at 10:41 PM, San Pat myitems2...@gmail.com wrote: Hi Ashish, Thanks for your help. Is there any way I can make it cell specific, assign this macro to particular

Re: $$Excel-Macros$$ Cell Reference ( automatic Updation on Date Change)

Hi you can use the date function with offsset function in your reference formula for this. For exact formula tell me what's your current cell address having reference and whats the reference. On 23-Jan-2011 2:01 PM, kush sharma kushleshsha...@gmail.com wrote: Dear All, I have a query in which

Re: $$Excel-Macros$$ Re: User Defined Function not updating

Hi Please add this line to your function. Adding on the first line will be good. Application.Volatile This will cause recalculation of the function when any value change in the sheet. (So directly affect the speed if you use function on many cell) Thanks Regards Sandeep On Fri, Aug 20, 2010

$$Excel-Macros$$ Fwd: Urgent Requirement: Excel VBA with Mini Tab

Hi, Reply to Mr. Lalit Sharma (lalit.sha...@xentaqsys.com) for all information. Will be better if you send your resume. Thanks Regards Sandeep -- Forwarded message -- From: Lalit Sharma lalit.sha...@xentaqsys.com Date: Mon, Aug 16, 2010 at 11:41 AM Subject: Urgent Requirement:

Re: $$Excel-Macros$$ Need list style from data

the second macro it doesn't work.  I don't know how to debug it. Thanks. Nadine From: Sandeep Kumar Maurya sandymau...@gmail.com To: excel-macros@googlegroups.com Sent: Sun, July 25, 2010 10:48:42 AM Subject: Re: $$Excel-Macros$$ Need list style from data

Re: $$Excel-Macros$$ Macro to clean up file

Hi, I got your file but next time use gmail and attach in the mail. Thanks Regards Sandeep On Sun, Jul 25, 2010 at 1:02 AM, JD 5635.daw...@gmail.com wrote: How do I attach? I placed in file section of MS EXCEL AND VBA MACROS. On Jul 24, 5:35 am, Sandeep Kumar Maurya sandymau...@gmail.com

Re: $$Excel-Macros$$ Macro to clean up file

Hi JD, You forgot to attach file. Thanks Regards Sandeep On Sat, Jul 24, 2010 at 5:52 AM, JD 5635.daw...@gmail.com wrote: I am looking to clean up a file that gets sent to me weekly see example file.xlsx on file page. The file may look like the first tab the 1st week it is sent to me and

Re: $$Excel-Macros$$ Auto Calculate Number to Percent

Hi, If I say clearly then this is not possible to change the Hour Worked value in percentage in the same column. The reason is that when a value is changed to percent what will converted to a fraction. Date User Hours Worked Hours Worked % 16-Jul ABC8

Re: $$Excel-Macros$$ how do you identify the first space within a series of words within a a text

Hi Edgar, Function you are applying is correct. So please attached your file so that problem can be solved. Thanks Regards Sandeep On Thu, Jul 22, 2010 at 3:18 AM, Edgar ejax...@gmail.com wrote: I'm trying to clean up some data. I've used SEARCH and FIND to try to identify the first space

Re: $$Excel-Macros$$ Re: [Fwd: Help for format converson required]

Hi, A good solution Dilip Ji. Please see the attached file with just a little modification. Thanks Regards Sandeep On Tue, Jul 20, 2010 at 4:00 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Pradeep, Look out for green shaded cell in the attached spreadsheet, in which I have done

Re: $$Excel-Macros$$ Finding a cell based on multiple criteria typed into cells

Hi David, Please find the solution you required. Feel free to ask anything from me. Regards Sandeep On Wed, Jul 14, 2010 at 3:11 PM, Sach1810 sach1...@googlemail.com wrote: Hi, I have a table of data giving different prices of different items. Below is a sample of that data. I want to be able

Re: $$Excel-Macros$$ Data Logic

Hi Al, Please find the attached file for your required solution. Regards Sandeep On Thu, Jul 15, 2010 at 5:46 AM, Al ali6...@gmail.com wrote: Dear All: This is the sample spread sheet i have.  pat meds stdt spdt  111 ABC 1 .  111 CDE 130 150  111 NNN 132 140  111 GHI 160 170  111

Re: $$Excel-Macros$$ Index match with 3 criteria

Hi, Yes I can, but need a sample file for proper result you want. Regards Sandeep On Thu, Jul 15, 2010 at 2:09 AM, Nadine S n8dine4ma...@yahoo.com wrote: I need to lookup a value based on matching 3 other columns.  I do not want to use a concatenation and then look up that. I have Sheet1 

Re: $$Excel-Macros$$

Hi, Please find the attached file for your required solution. Regards Sandeep On Tue, Jul 6, 2010 at 4:28 PM, Ankit Chandna ankit.chan...@yahoo.inwrote: Dear, Can u plz tell me exact procedure.i do hv ASAP utilities. --- On *Tue, 6/7/10, Mahesh mahender.bi...@gmail.com* wrote: From:

Re: $$Excel-Macros$$ How to display cell contects as password *****

Hi, You can use an alternate way to over come this. change the text color of cell to same as background then lock and hide it. After this protect the sheet. Thanks and Regards Sandeep. On Tue, Jun 15, 2010 at 10:45 AM, Rajesh Bedse rajeshbe...@gmail.com wrote: thx Vikas. The issue with

Re: $$Excel-Macros$$ IF AND formulas

Hi Mike, It will be better if you send a sample file with some data and your query. As it may give you a shorter and simple formula for your task. And about this formula, one can only show you the syntax error and that not guaranteed for formula to give desired result. So if you can than

Re: $$Excel-Macros$$ vlookup with 2 criteria

Hi nino, check my reply in the $$Excel-Macros$$ Maximum Date problem. Thanks Regards Sandeep On Sun, May 9, 2010 at 1:12 PM, Ravi Megharaj ravi.megha...@gmail.com wrote: You can concatenate Column A and Column B to get the unique value. Then do a vlookup to get the exact value. Once

Re: $$Excel-Macros$$ Maximum Date

@Dilip Ji You are always Welcome sir. Thanks Sandeep On Mon, May 10, 2010 at 7:54 PM, Dilip Pandey dilipan...@gmail.com wrote: Thanks Sandy, @ Dheeraj, I think you have got the answer for your query. Get back, in case of any other queries. -- Thanks Regards, DILIP KUMAR PANDEY  

Re: $$Excel-Macros$$ Re: Extract Right Word in Line

Hi Anand, You are right, that Asish solution is perfect, but if you don't want to use VBA you can use this one. =RIGHT(A1,LEN(A1)-FIND(~,SUBSTITUTE(A1, ,~,LEN(A1)-LEN(SUBSTITUTE(A1, ,) Don't see its size, because it is smallest possible using formula. And I assume that your text don't have

Re: $$Excel-Macros$$ TOUGH QUESTION

Hi, It is possible AZHAR. What you have to do is 1. Mail merge all the links in word document. 2. Then use macro in MS Word to insert picture for all the links which have a image extension, like jpg, bmp etc. How you will do this. Apply the straight method of learning VBA. 1. Record a macro

Re: $$Excel-Macros$$ EXCEL SHORTCUT -- PLEASE HELP :-)

Select the function and press tab. Thanks Regards Sandeep On Thu, May 6, 2010 at 11:38 PM, Michael mich...@michaelkwak.net wrote: I posted a picture of what I'm trying to discover:

Re: $$Excel-Macros$$ EXCEL SHORTCUT -- PLEASE HELP :-)

this dear friend On Fri, May 7, 2010 at 11:54 AM, Sandeep Kumar Maurya sandymau...@gmail.com wrote: Select the function and press tab. Thanks Regards Sandeep On Thu, May 6, 2010 at 11:38 PM, Michael mich...@michaelkwak.net wrote: I posted a picture of what I'm trying to discover

Re: $$Excel-Macros$$ Urgent need some about how can calculate week

May be you want this. Find the attached file. Regards Sandeep -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook

Re: $$Excel-Macros$$ Who to remove hyperlinks

Hi, write 1 in a blank cell and then copy it and use multiply option in 'paste special'. It also put 0 in blank selected cells. Regards Sandeep On Mon, Mar 22, 2010 at 9:13 PM, Nani Ram 06n...@gmail.com wrote: Hi Members, i have huge data with hyperlinks. Is there any shortcut key or

Re: $$Excel-Macros$$ Excel Formula Required

Simplest possible. But needed unique list (no duplication). Regards Sandeep On Thu, Mar 18, 2010 at 8:37 PM, Dilip Pandey dilipan...@gmail.com wrote: Dear Venkatesan, Attached file has two solutions for your query. Let me know in case of any challenge(s). -- Thanks Regards, DILIP

Re: $$Excel-Macros$$ How to sum on the basis of color

Hi, You can filter on the basis of color in excel 2007. And with that you can use subtotal(9,Range) for your data. Subtotal don't sum those value which are hidden. Thus you can get sum on the basis of color in excel 2007 using filter and subtotal. But if you want to see both value at time then

Re: $$Excel-Macros$$ Require help on a condition

Hi, Find the attached sheet with formula. Regards Sandeep On Fri, Nov 20, 2009 at 10:35 AM, Sivakumar E.S emm...@gmail.com wrote: pooja Sharma Find attached an excel file with vba macro. place ur cursor anywhere in reference column and run macro... u will see result in next sheet Hope

Re: $$Excel-Macros$$ Plz Urguntly Help needfull

Hi Anil, From Insert menu goto Define Names (As you do for named ranges) then give the Each name (Anil) the value you want. Then A B 1Anil =indirect(A1) 2Saxena =Indirect(A2) Regards Sandeep On Thu, Nov

Re: $$Excel-Macros$$ Flagging duplicate values with Countif and Search functions re partial matches

Check the file. On Sun, Nov 15, 2009 at 6:39 PM, Dilip Pandey dilipan...@gmail.com wrote: Dear Dan, I have tried to build up the data as mentioned by you and able to get the desired result. Same spreadsheet is attached herewith for your review. Best Regards, -- DILIP KUMAR PANDEY

Re: $$Excel-Macros$$ Need Urgent Help ~ Vlookup

Hi Anish, See the attached file. Don't change position of 'Auto Reset', 'Counter' and 'Auto Switch' else it may not work properly. Also it can be done easily with VBA, so if you need then ask the solution in VBA and you will get a quick response from the group. Regards Sandeep On Fri, Nov 13,

$$Excel-Macros$$ Re: DATAIMPORT XML Missing in excel 2003 standard edition

Hi, Don't your Excel 2003 has Data-XML-Import. Check Again. Regards Sandeep On Tue, Oct 6, 2009 at 5:57 PM, Manoj Kukrej manoj...@ocimumbio.com wrote: Hi, I want to know how I can add xml in it I have checked in tools commandsxml is also missing Regards Manoj

$$Excel-Macros$$ Re: Looking for most effecient way to convert lots of data

Hi, First you have to retrieve unique phone numbers I have given the steps in attached file then use the formula as shown in the file. Regards Sandeep On Wed, Oct 7, 2009 at 6:41 AM, bruce goo...@johnsonclan.net wrote: I am creating a program that does daily QA of our products. I work for a

$$Excel-Macros$$ Re: excel + vba + html

Hi, There are many free online spreadsheet solution, you should give try to one of them (Personally I never use them because I never need and online excel file). Follow this link and you will get many online spreadsheet solution and choose as per your need.

$$Excel-Macros$$ Re: Excel macro-Help

Hi, I update the macro as per your use and assign a shortcut too. There are some guidelines follow them to use desired result. Regards Sandeep On Tue, Oct 6, 2009 at 11:35 PM, Umesh Matkar matkarum...@gmail.com wrote: Dear Friends, I have one query regarding macro. i want to record a

$$Excel-Macros$$ Re: Unique record retrieval

Hi, If you want to retrieve a unique row then select all data go to 'Advance filter' and check 'unique records only'. Choose 'Filter the list, In place' if you want to just filter the data and choose 'Copy to another location' if you want to copy the filter list to another place, (select any

$$Excel-Macros$$ Re: Fwd: Name Matching In Excel

Hi Sonal, I take a look on your data and find that your data in file1 and file2 are not same as there are some short names and no middle name in one of the file but the other one has full name and short middle name. It can be done with VBA but if your data is not unique then there is no

$$Excel-Macros$$ Re: Need urgent help on finding formula

Hi VR, Find the attached solution. Regards Sandeep On Tue, Sep 22, 2009 at 8:05 PM, vinod rao vinod.ma...@gmail.com wrote: HI Team, need a foumula to find the latest Date and in next column the Status Plz find attached.file. Thanks in advance. VR

$$Excel-Macros$$ Re: help plz

Hello Ashish, Do you have your data ready or you want to enter the data then a new row below it. Means your data already have parent co in column B are you going to enter it in column B. Regards Sandeep On Wed, Sep 23, 2009 at 10:29 AM, ashish koul koul.ash...@gmail.com wrote: inserting a

$$Excel-Macros$$ Re: Need help on formula

Hi Vinod, Did you find my solution or not? This is my seventh mail. Regards Sandeep On Wed, Aug 26, 2009 at 9:50 AM, Prashant Bhawar prashant.aca...@gmail.comwrote: On Tue, Aug 25, 2009 at 9:52 PM, vinod rao vinod.ma...@gmail.com wrote: Hello Team, How do i rank only positive numbers.

$$Excel-Macros$$ Re: Separate Fields in fastest way

Hi, find the attach solution for your problem. Sandeep On Wed, Jul 8, 2009 at 10:50 AM, Deepak Rawat deepakrawa...@gmail.comwrote: Dear friends have attached a file in which all fields are merged and have to separate all fields as soon as possible. pl suggest me the way. there is another