$$Excel-Macros$$ vlookup return with pcture assinged

Good morning experts Need your valueable help to complete ma project, i have three n more pics in name of ram, shyam, n more pasted on diffrent sheet now i want if i write ram in a assinged cell ram's pic appear in selected area of sheet n so on. I dont wanna use macro for thisi need this

$$Excel-Macros$$ Fuzzy name match- output from userform

I have a scenario in which a user needs to perform a "fuzzy" match between a name and a variation of that name in a list about 4500 names long. For example, the user may be looking for "Smith, John" but needs to match to "Smith,John Jr" in the longer list. My plan is to write the long list to an a

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

Congrats Noorain. You deserved it.. On Fri, Oct 14, 2011 at 11:40 AM, Subhash Yadav wrote: > Congratulations Noorain... > > > Thanks for your helps provided.. > > Regards, > > > Subhash Yadav > > On Thu, Oct 13, 2011 at 8:51 PM, Dilip Pandey wrote: > >> Congratulations NOORAIN. >> >> sorry for l

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

Congratulations Noorain... Thanks for your helps provided.. Regards, Subhash Yadav On Thu, Oct 13, 2011 at 8:51 PM, Dilip Pandey wrote: > Congratulations NOORAIN. > > sorry for late responss as I was running behind on my email. > > Regards, > DILIPandey > On 2 Oct 2011 00:43, "Ayush Jain"

Re: $$Excel-Macros$$ Conditional Formatting

hi prasad pfa On Fri, Oct 14, 2011 at 11:11 AM, Mr Excellent wrote: > Hi Group, > > Need a help in Conditional formatting > > I have 12 Columns in the sheet the first 6 Cols have the data and the next > 6 Cols have the Checks, so based on the Values of "Yes" and "No for the > Check1 to till C

$$Excel-Macros$$ Conditional Formatting

Hi Group, Need a help in Conditional formatting I have 12 Columns in the sheet the first 6 Cols have the data and the next 6 Cols have the Checks, so based on the Values of "Yes" and "No for the Check1 to till Check6 the values in the first 6 Columns should be highlighted If It has "Yes" in the

Re: $$Excel-Macros$$ Urgent Help required

Hi Prathap, If this is one time exercise then, write 100 somewhere in and copy it. Now select the data and apply paste special - > Values -> Divide. If this is kinda template where figures will come and go, then you can use custom format. Regards, DILIPandey On 10/13/11, Prathap wrote: > H

Re: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)

Hi, In the Sorted list, you have shown 92C, 94B, 94C... This is not sorted as per alphabet order and neither it is in numeric (Descending) and same goes with 193, 195, 52, 86. Kindly explain the order. Thanks Regards, DILIPandey On 10/14/11, B Sharma wrote: > Dear Don & other experts > >

Re: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)

Dear Don & other experts Coloumn A has raw data and column B have sorted data Before After 52  193  86  195  92C 52  94B 86  94B 87  195 92C  193 94B  ABC 94C  XYZ 94J  87 

Re: $$Excel-Macros$$ Urgent Help required

Hi In a cell type 100 copy it( ctrl + C) Select all cells then paste special ( Alt + E + S + V + I ) value with divide operation This will convert all the numbers in million format. Thanks and Regards, Somnath C Pardeshi +91 966 419 4782 Sent from my BlackBerry® Smartphone on Loop Mobile.

Re: $$Excel-Macros$$ comparison between access forms to excel

Hi, Pls find attached excel for solution. Click on button to run the macro. Regards, Swapnil. On Thu, Oct 13, 2011 at 6:18 PM, mrinal saha wrote: > Here are both access databse and an excel file. > In access there is a object EMPDETAIL (form) contianing multiple forms. > > > > > On Thu, Oct

Re: $$Excel-Macros$$ Urgent Help required

You could use a macro,  or, you could use a formula by: 1. Copy the sheet to another sheet. 2. in Cell D7 use: =IF('P & L'!D7>0,'P & L'!D7 / 100,0) (If you want round it to even values, use: =IF('P & L'!D7>0,ROUND('P & L'!D7 / 100,0),0) 3. Copy this cell to all columns and rows 4. Select

Re: $$Excel-Macros$$ Urgent Help required

Thank you all for your assistance. However i have a sheet (containing 67 columns & 3980 rows) were i need to change the entire cell into million. Attached is the sample sheet Best Regards, PRATHAP D M +91 9899-370-328 On 13 October 2011 20:22, Prathap wrote: > Hi, > > Is there a way to conver

Re: $$Excel-Macros$$ Urgent Help required

Custom Format #,##0,, ;[Red](#,##0,,);- ; Don Guillett SalesAid Software dguille...@gmail.com From: Prathap Sent: Thursday, October 13, 2011 9:52 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent Help required Hi, Is there a way to convert all the cells with numbers in

Re: $$Excel-Macros$$ Urgent Help required

Hi Just divide this by 100 Try this formula =A1/10^6 Thanks and Regards, Somnath C Pardeshi Sent from my BlackBerry® Smartphone on Loop Mobile. -Original Message- From: Prathap Sender: excel-macros@googlegroups.com Date: Thu, 13 Oct 2011 20:22:52 To: Reply-To: excel-macros@googl

Re: $$Excel-Macros$$ Help required

Should do it. Or just use AUTOFILTER on the original to get one at a time to view. Option Explicit Sub GetCountryData_SAS() 'fire while at Tes sheet Dim lr As Long Dim i As Long Columns("I").Delete lr = Cells(Rows.Count, 1).End(xlUp).Row 'get unique list Range("h1:h" & lr).AdvancedFilter Action:=

Re: $$Excel-Macros$$ Urgent Help required

Hi Prathap Assuming u r value in cell A1 '=A1/10^6 HTH Mahesh On Thu, Oct 13, 2011 at 8:22 PM, Prathap wrote: > Hi, > > Is there a way to convert all the cells with numbers in to million format > with shortcut / formula. > > Example: 1232345487 i want as 1232. > > Attached is the sample file

$$Excel-Macros$$ Urgent Help required

Hi, Is there a way to convert all the cells with numbers in to million format with shortcut / formula. Example: 1232345487 i want as 1232. Attached is the sample file Best Regards, PRATHAP D M +91 9899-370-328 -- ---

Re: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)

What would the AFTER look like Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: B Sharma Sent: Thursday, October 13, 2011 8:46 AM To: MS EXCEL AND VBA MACROS Cc: rajanverma1...@gmail.com Subject: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric) Dear

Re: $$Excel-Macros$$ Spell Check and Highlighting Individual Words

Hi Rajan Thanks so much for your speedy response. I've added the code to my complete VBA but, it is not working. Could I send the workbook to you for review? (it's not clear how to attach to this thread??) I am still very much an amateur with regards to VB! Kind regards Greg On Oct 13, 2:53

Re: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)

Hi, The query is not easy but remember this group is awsome which can handle these types of query. See the attachment where I have tried sorting the data numeric/ alphanumeric. Regards, DILIPandey On 13 Oct 2011 19:17, "B Sharma" wrote: > Dear Excel Experts (and to my friends who have ans

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

Congratulations NOORAIN. sorry for late responss as I was running behind on my email. Regards, DILIPandey On 2 Oct 2011 00:43, "Ayush Jain" wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Sept'11 > He has posted 140 posts in sept 2011 an

Re: $$Excel-Macros$$ Thanks everyone.

Heartiest congratulations Ayush. Sorry I missed this email. Regards, DILIPandey On 4 Oct 2011 00:15, "Ayush Jain" wrote: > Dear members, > > I am proud to share that I have been re-awarded the Micrososft MVP award in > 2011. My deep thanks to each group member for all your support and > contrib

Re: Fw: $$Excel-Macros$$ Help required

Try this : its not a Good Macro but can Solve your Query : Sub bifurCateData() Dim rngHeading As Range Dim RngData As Range Dim rngCell As Range Dim strCountryname As String Dim intLastrow As Integer With Range("A1") Set RngData = Intersect(.C

$$Excel-Macros$$ Re: Formula Sorting Data (Alpha + Numeric)

Hi, Do you want only 'figures' to be sorted out OR do you want numbers only to be sorted out ? Regards, DILIPandey -- Thanks & Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Oct 13, 2:46 pm, B

Re: $$Excel-Macros$$ Average

Hi pramod. Put this in E2 =(C3/B3)/D3 :) On Thu, Oct 13, 2011 at 4:15 PM, Pramod Kumar wrote: > Dear Experts, > Please find attached data sheet & I want per day per site average. > > > -- > Regards, > Pramod Kumar > Technocare Solution(TCS) > Rudrapur > +91 9927033573 > E-Mail:-kumar.pramod03i

Re: $$Excel-Macros$$ Spell Check and Highlighting Individual Words

Hi Try this .. Hope it will Resolve Your Query *Public MyTest As Boolean Public myWord As String* *Sub GetText()* *On Error Resume Next* *Dim ws As Worksheet* *Dim st As String* *Dim arr() As String* *Dim cell As Range* ** *Se

Re: $$Excel-Macros$$ Average

Dear Pramod, If possible, Please explain more clearly. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Thu, Oct 13, 2011 at 4:15 PM, Pramod Kumar wro

$$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)

Dear Excel Experts (and to my friends who have answered to my earlier queries) >From a long time, I am searching for a formula which can sort the list and represent the unique datas only for Example , In column 1 I have the following data 52 86 92C 94B 94B 195 193 ABC XYZ 87 94J 94B 94K 94C

$$Excel-Macros$$ Required MIS Executive in V5Global.com in Nehru Place

*Experience:* 1 - 6 Years *Location:* Delhi/NCR *Compensation:* Rupees 2,00,000 - 5,00,000 *Education:* UG - Any Graduate - Any Specialization,Graduation Not Required PG - Any PG Course - Any Specialization,Post Graduation Not Required *Industry Type:* IT-Hardware & Networking *Role:* Stenog

$$Excel-Macros$$ Formula Sheet

Dear All, could anyone have formula sheet with its illustration. I need it Thanks Regards, Ankit -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/e

$$Excel-Macros$$

-- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutor

Re: $$Excel-Macros$$ Solution Request

Hi Ahmed, I think Mr.Guillet was correct,as if i am right one cell in excel can hold only 32,767 characters, if you have thousands of mail ids then it may exceed this limit. On Thu, Oct 13, 2011 at 12:34 AM, Ahmed Honest wrote: > Dear Mr. Chethan, > > Just a Lovely, Damm and Beyond imagination s

Re: $$Excel-Macros$$ comparison between access forms to excel

Hi, Can you provide sample data. Regards, Swapnil. On Thu, Oct 13, 2011 at 5:48 PM, mrinal saha wrote: > hi folks, > > I have an excel sheet wherein column A contains EMP ID and column B > contains EMP NAME. > > I also have an access database with multiple forms and each form contains > this

Re: $$Excel-Macros$$ Shortcut key for Border

Now its working... Thanks... On 10/13/11, Dilip Pandey wrote: > Nice collection Noorain... > > Regards, > DILIPandey > > On 10/12/11, NOORAIN ANSARI wrote: >> Dear Ankit, >> >> Please find below Short Cut keys,I hope it will help to you. >> >> 1. *Apply* an outline border >> *[Ctrl]+[Shift]+[&]

Re: $$Excel-Macros$$ "fill down formulas in columns adjacent to data" option in Excel 2007

The easy way to do this is to select the formula to copy double click the fill handle Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Sumesh Sent: Thursday, October 13, 2011 3:47 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ "fill down formulas

$$Excel-Macros$$ comparison between access forms to excel

hi folks, I have an excel sheet wherein column A contains EMP ID and column B contains EMP NAME. I also have an access database with multiple forms and each form contains this two fields also out of many fields. I want, if the EMP ID in form matches to column A in excel then highlight the cell.

$$Excel-Macros$$ Re: Unable to change date fromate

Hi Try This Formula =+DATE(RIGHT(A2,4),MID(A2,4,2),LEFT(A2,2)) Regards On Oct 11, 6:08 pm, Suman wrote: > Hi, > Good evening to all, > Please help in changing date formate. > > -- > >        «•´`•.(*•.¸(`•.¸*¸.•´)¸.•*).•´`•» > «´¨*•.¸¸.*.~*--Suman --*~..*.¸¸.•*¨`» >        «•´`•.(¸.•´

$$Excel-Macros$$ Average

Dear Experts, Please find attached data sheet & I want per day per site average. -- Regards, Pramod Kumar Technocare Solution(TCS) Rudrapur +91 9927033573 E-Mail:-kumar.pramod03i...@gmail.com -- -- Some important l

$$Excel-Macros$$ "fill down formulas in columns adjacent to data" option in Excel 2007

Hi, I'm using Excel 2007. I'm exporting some data from Oracle DB2 database using the export data functionality in Excel (Data - Get External Data - From Other Sources - From Microsoft Query). To the data so retrieved, I've added two more columns which contain formula. Whenever the data retrieve

$$Excel-Macros$$ How to create an Purchase Order Template with Database in excel

Hi All, I have new to EXCEL VBA, I have tried PO with using mail merge in MSWORD.. However, its not possible for me create an PO. Request to help me on this.. Regards Sunil Bedre -- -- Some important links for exc

$$Excel-Macros$$ Spell Check and Highlighting Individual Words

Hi I have an Excel sheet with VBA which is designed to compare two boxes of text/copy and highlight any differences. The existing code is very good although, it does not currently highlight individual words (it only changes the box color to red to suggest there is an error). Here is the existing

Fwd: Fw: $$Excel-Macros$$ Help required

Hi Group, Please help Thanks Prasad. -- Forwarded message -- From: Date: Thu, Oct 13, 2011 at 10:43 AM Subject: Fw: $$Excel-Macros$$ Help required To: excel-macros@googlegroups.com **Hi Guys can anyone help me on this please Thanks Prasad Sent from BlackBerry® on Airtel

Re: $$Excel-Macros$$ can we change hard copy in excel

Hi Anil, Not sure if you are asking to edit a scanned excel sheet. Please elaborate. Thanks. Regards, DILIPandey On 13 Oct 2011 15:15, "anil kumar" wrote: > Hi frineds, > > > can we change a hard copy of data in excel by scanner. > > > Regards & Thanks > > Anil > > -- > > ---

Re: $$Excel-Macros$$ can we change hard copy in excel

Yes you can convert your image files in excel through online or download a software from the website below : http://www.onlineocr.net/ http://www.cometdocs.com/ http://www.coolutils.com/Online-Excel-Converter.php http://document.online-convert.com/convert-to-pdf http://www.pdfconverter.com/ http:/

Re: $$Excel-Macros$$ can we change hard copy in excel

Hi sam, fist of all thanks for response. I have some data in trems of hard copy like add. mob. no. etc. and i have to type in excel. so i think that frist i scan that hard copy and than change in excel file by any sofware. I hope you will understand now. Anil -- -

RE: $$Excel-Macros$$ Selecting a date from a database, which equal to or lesser than the selected date

Solution revised. Thanks Sam for the catch. Regards, DILIPandey On 13 Oct 2011 14:11, "Dilip Pandey" wrote: -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twi

Re: $$Excel-Macros$$ can we change hard copy in excel

Hi Anil, Could you please explain a little more. Not sure what your query is. Sam On Thu, Oct 13, 2011 at 3:15 PM, anil kumar wrote: > Hi frineds, > > > can we change a hard copy of data in excel by scanner. > > > Regards & Thanks > > Anil > > -- > > --

$$Excel-Macros$$ can we change hard copy in excel

Hi frineds, can we change a hard copy of data in excel by scanner. Regards & Thanks Anil -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceld

Re: $$Excel-Macros$$ Selecting a date from a database, which equal to or lesser than the selected date

Fortunately, there are smaller formulas. Here's one =INDEX($C$2:$C$19,SUMPRODUCT(MATCH($E2&$D2,$B$2:$B$19&$A$2:$A$19,1))) Here's another one that uses array =INDEX($C$2:$C$19,MATCH($E2&$D2,$B$2:$B$19&$A$2:$A$19,1)) Regards, Sam Mathai Chacko (GL) On Thu, Oct 13, 2011 at 1:06 PM, B Sharma wro

RE: $$Excel-Macros$$ Selecting a date from a database, which equal to or lesser than the selected date

Dear Sharmaji Nice explanation. I have tweeked my previous formula and that worked. See the attachment. Regards, DILIPandey On 13 Oct 2011 12:23, "BS" wrote: > Dilip, > I have attached a file for your reference for what I needed. > > Thank you for your efforts.. > > > -Original Message---

Re: $$Excel-Macros$$ Selecting a date from a database, which equal to or lesser than the selected date

Thanks to all . almost every formula is working Actually my problem is the following I have 3 coloums "Rate w.e.f. (dd-mmm-yy)"Item Rate 01-Apr-10 Bulb 5.00 15-Apr-10 Bulb 6.00 01-Jul-10 Bulb 7.00 30-Jul-10 Bulb