Re: $$Excel-Macros$$ Scraping data from image

Try able2extract professional version Or google OCR to word online converters Sent on my BlackBerry® from Vodafone -Original Message- From: Arsfan2005 Sender: excel-macros@googlegroups.com Date: Fri, 30 Nov 2012 12:58:24 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Exce

Re: $$Excel-Macros$$ MACRO FOR LIST CHECK AND ADD ROWS

Hi Experts I have created a list in "Name Manager" named "TTlist" for values shown in "LIST" sheet of attached file. I used to update this "TTlist" with some other macro. I have another sheet named "TT" in which 1st 5 rows are constant. I sued to fill-in data from 6th row on-wards. I need a macro

Re: $$Excel-Macros$$ Scraping data from image

thanx fr ur reply i will google it. but is it posible fr u too xplain it in more this will help me. Sent from Samsung Mobile xlstime wrote: Yes, it is possible.. pls try Recognize txet from OCR On Fri, Nov 30, 2012 at 2:16 AM, hanumant shinde wrote: Hi, Is it possible to capture (scrape) d

Re: $$Excel-Macros$$ Re: Formula need to calculate sum on conditional base

will you elaborate you query more, so that we can understand . Regards, Gawli Anil On Fri, Nov 30, 2012 at 12:30 PM, Ashish Bhalara wrote: > Dear expert, > Thanks to reply but i have to keep data same as in attached sheet so i > need a formula for amount written in red colour. > > > -- F

Fwd: $$Excel-Macros$$ Re: Formula need to calculate sum on conditional base

Dear expert, Thanks to reply but i have to keep data same as in attached sheet so i need a formula for amount written in red colour. -- Forwarded message -- From: अनिल नारायण गवली Date: Fri, Nov 30, 2012 at 12:26 PM Subject: Re: $$Excel-Macros$$ Re: Formula need to calculate sum

Re: $$Excel-Macros$$ Re: Formula need to calculate sum on conditional base

Pls find attched sheet for you reference. Regards, Gawli Anil On Fri, Nov 30, 2012 at 12:16 PM, Ashish Bhalara wrote: > i need the formula for text enetered in sheet with red color > > On Fri, Nov 30, 2012 at 12:13 PM, Ashish Bhalara < > ashishbhalar...@gmail.com> wrote: > >> Dear expert, >> >>

Re: $$Excel-Macros$$ Re: Formula need to calculate sum on conditional base

Hi,   PFA...   Thanks and Regards,   Somnath C Pardeshi From: Ashish Bhalara To: excel-macros@googlegroups.com Sent: Friday, 30 November 2012 12:16 PM Subject: $$Excel-Macros$$ Re: Formula need to calculate sum on conditional base i need the formula for text e

Re: $$Excel-Macros$$ Re: Formula need to calculate sum on conditional base

pls share the workbook with us On Fri, Nov 30, 2012 at 12:16 PM, Ashish Bhalara wrote: > i need the formula for text enetered in sheet with red color > > On Fri, Nov 30, 2012 at 12:13 PM, Ashish Bhalara < > ashishbhalar...@gmail.com> wrote: > >> Dear expert, >> >> I have a data in attached sheet,

$$Excel-Macros$$ Formula need to calculate sum on conditional base

Dear expert, I have a data in attached sheet, in which data contain opng balance, transaction & closing balance of particular month and code, i need a formula to calculate sum opening balance of month wise on base of code, the data file is attached herewith for my requirement. Thanks & regards.

Re: $$Excel-Macros$$ How to determine the volume slabs for different price levels in excel?

Hi, Pls find attached excel sheet having sample letter Need volume slabs determined based on some statistical measures and also price point based on those volumes... thanks in advance On Thursday, November 29, 2012 9:06:24 PM UTC+5:30, ashish wrote: > > can u share the sample file > > > On Wed,

Re: $$Excel-Macros$$ Scraping data from image

Yes, it is possible.. pls try Recognize txet from OCR On Fri, Nov 30, 2012 at 2:16 AM, hanumant shinde wrote: > Hi, > > Is it possible to capture (scrape) data from .doc file but the data on > this .doc file is pasted as image. > > > -- > Join official Facebook page of this forum @ > https://www

Re: $$Excel-Macros$$ Scraping data from image

Not possible.. Regards, Anoop On Fri, Nov 30, 2012 at 2:16 AM, hanumant shinde wrote: > Hi, > > Is it possible to capture (scrape) data from .doc file but the data on > this .doc file is pasted as image. > > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discusse

$$Excel-Macros$$ Scraping data from image

Hi, Is it possible to capture (scrape) data from .doc file but the data on this .doc file is pasted as image. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent

Re: $$Excel-Macros$$ convert time formatted as text to military time and join with date field

Here's the curious thing though: =TEXT(B3,"dd/mm/") means that you have a value in B3 that Excel considers a NUMBER.. --- TEXT(value, format_text) The TEXT function syntax has the following arguments: - value    Required. A numeric value, a formula that evaluates to

Re: $$Excel-Macros$$ convert time formatted as text to military time and join with date field

thanks - I was so over-thinking this. Such and simple and straight foward solution. THANK YOU!!! On Thursday, November 29, 2012 12:01:43 PM UTC-6, Excel Beginner wrote: > Hi Jenny, > > Use this =TEXT(B3,"dd/mm/")&" "&TEXT(C3,"hh:mm") > > > > -- > *Regards,* > * > * >

Re: $$Excel-Macros$$ convert time formatted as text to military time and join with date field

First of all, How are you importing the data? through a script that reads/writes individual rows, or are you "opening the file" and letting Excel do the mapping? If you're letting Excel do it, you may have some options for the cell format. Secondly, are you SURE the data is "text". Can you change

Re: $$Excel-Macros$$ convert time formatted as text to military time and join with date field

Hi Jenny, Use this =TEXT(B3,"dd/mm/")&" "&TEXT(C3,"hh:mm") -- *Regards,* * * *Excel Beginner* * * On Thu, Nov 29, 2012 at 11:20 PM, JenIT wrote: > My data is opened from a downloaded file. I do not have an import > functions as data exports as excel and I believe my cells

Re: $$Excel-Macros$$ convert time formatted as text to military time and join with date field

Can u attach the excel file with sample data Sent on my BlackBerry® from Vodafone -Original Message- From: JenIT Sender: excel-macros@googlegroups.com Date: Thu, 29 Nov 2012 09:50:18 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ convert time formatted as text to

$$Excel-Macros$$ convert time formatted as text to military time and join with date field

My data is opened from a downloaded file. I do not have an import functions as data exports as excel and I believe my cells are formatted as Text since I cannot seem to make any formatting change the data.I need to to change from it's current format to military time and then also combine t

Re: $$Excel-Macros$$ Re: Code to refresh information from external data source *

Thanks Paul exactly what i need. Thanks Ashish its sorted now On Thu, Nov 29, 2012 at 3:45 PM, Paul Schreiner wrote: > ActiveWorkbook.RefreshAll -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thr

$$Excel-Macros$$ Dynamic Fixed Asset Depreciation Schedule

Hello Gurus i am trying to develop a very dynamic Fixed Asset depreciation schedule but facing a slight formula or logic challenge and as usual seeking your expert advice. Basically what this current schedule does is assuming you want to depreciate your asset for say 5 years, starting from 2013 yo

Re: $$Excel-Macros$$ date query

in cell E62 =VLOOKUP(E63-1,A:A,1) E63 =VLOOKUP(E64-1,A:A,1) IN CELL F62 =SUMIF(A:A,E62,B:B) and fill down the formula On Thu, Nov 29, 2012 at 10:29 PM, Kenil Gala wrote: > Hi, > Pls find the file attched. > > Thanks & Regards, > > > -- > Join official Facebook page of this forum @ > https

$$Excel-Macros$$ date query

Hi, Pls find the file attched.   Thanks & Regards,   -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice

RE: $$Excel-Macros$$ Remove highlighted number

Thank you very much From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: 29 November 2012 16:33 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Remove highlighted number The hardest part is figuring out what function to use.

Re: $$Excel-Macros$$ Remove highlighted number

The hardest part is figuring out what function to use. The EASIEST part is figuring out how it works! Do you use the Function Wizard? (the little Fx button next to the "content" box at the top) Hit it. choose "All" in the Category box. Find "Replace" in the list of functions (you can begin typi

RE: $$Excel-Macros$$ Remove highlighted number

Thank you very much... Please can you explain me how it work... it can long last me for ever Thanks MAnjunath From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kanwaljit Singh Sent: 29 November 2012 14:56 To: excel-macros@googlegroups.com Subject: Re:

$$Excel-Macros$$ Re: Code to refresh information from external data source

I believe the VBA code is: ActiveWorkbook.RefreshAll Paul On Wednesday, November 28, 2012 3:22:19 PM UTC-5, hilary lomotey wrote: > Hello Expert > > can i get help with a code to refresh information coming from a data > source. i know the short cut ctrl + alt +f5 to refresh such data

Re: $$Excel-Macros$$ How to determine the volume slabs for different price levels in excel?

can u share the sample file On Wed, Nov 28, 2012 at 11:07 PM, Ashok Charan wrote: > > > I have set of historic data > 1. different price levels > 2. quantity at that price levels > > based on the above i need to arrive at the volume slabs like > 0-100 units, 100- 300 units etc and also what pri

Re: $$Excel-Macros$$ Insert Multiple mails as icons into excel

can u share the sample file Also visit http://msdn.microsoft.com/en-us/library/office/aa174259(v=office.11).aspx http://www.java2s.com/Code/VBA-Excel-Access-Word/Data-Type/CreatingCompoundDocumentsProgrammaticallyUsingOleObjects.htm http://vba2008.wordpress.com/2008/10/17/adding-an-ole-object-com

Re: $$Excel-Macros$$ Code to refresh information from external data source

what is the source of external information On Thu, Nov 29, 2012 at 1:52 AM, Hilary Lomotey wrote: > Hello Expert > > can i get help with a code to refresh information coming from a data > source. i know the short cut ctrl + alt +f5 to refresh such data, but i > would be grateful to get a code to

RE: $$Excel-Macros$$ Remove me

PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon's standard conditions associated with this e-mail please visit http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725

Re: $$Excel-Macros$$ Remove highlighted number

Hi, You can also use =REPLACE(A1,3,2,"") On Thu, Nov 29, 2012 at 8:17 PM, Manjunath Narayanappa < manjunath.narayana...@aon.co.uk> wrote: > Dear Experts. > > > > > > In a spreadsheet there are more than 80 policy for example below. I want > to remove 3rd & 4th for below entries > > > > Examples

Re: $$Excel-Macros$$ EMAIL AUTOMATION BY VBA OUTLOOK

@ Narton - Thanks @Satendra kumar - whts nt wrkng in the file u need to add the loop On Thu, Nov 29, 2012 at 6:52 AM, Natron wrote: > *Ashish, you are awesome!* >> > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, ac

Re: $$Excel-Macros$$ Remove highlighted number

LEFT(A1,2)&RIGHT(A1,LEN(A1)-4) On Thu, Nov 29, 2012 at 8:17 PM, Manjunath Narayanappa < manjunath.narayana...@aon.co.uk> wrote: > PH1106220 > > AK0721911 > > AG0600641 > > AK0915631 > > AK1015631 > > AK1015631 > > AK0915631 > > AK0721911 > > AK0915631 > -- *Regards* * * *Ashish Koul* *Vis

$$Excel-Macros$$ Remove highlighted number

Dear Experts. In a spreadsheet there are more than 80 policy for example below. I want to remove 3rd & 4th for below entries Examples - PH1106220. I want to remove highlighted one PH1106220 AK0721911 AG0600641 AK0915631 AK1015631 AK1015631 AK0915631 AK0721911 AK0915631 Thanks Manjunath ___

Re: $$Excel-Macros$$ sequence issue

Are you saying that you'd like Excel to automatically sort your data? So that, when you enter a number, it will sort the rows in numerical order?   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can,

Re: $$Excel-Macros$$ Modify Code to to send range * *

Excellent Ashish thanks a zillion On Thu, Nov 29, 2012 at 2:59 AM, wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (koul.ash...@gmail.com) Add cleanup > rule