Re: $$Excel-Macros$$ Re: calculating between two cells in two different sheets.

2013-03-08 Thread Shrinivas Shevde
On Sat, Mar 9, 2013 at 12:32 PM, Shrinivas Shevde wrote: > > > On Sat, Mar 9, 2013 at 11:52 AM, ravinder negi wrote: > >> there is no sheet >> >> --- On *Fri, 3/8/13, Jaz * wrote: >> >> >> From: Jaz >> Subject: $$Excel-Macros$$ Re: calculating between two cells in two >> different sheets. >> To:

Re: $$Excel-Macros$$ Re: calculating between two cells in two different sheets.

2013-03-08 Thread Shrinivas Shevde
On Sat, Mar 9, 2013 at 11:52 AM, ravinder negi wrote: > there is no sheet > > --- On *Fri, 3/8/13, Jaz * wrote: > > > From: Jaz > Subject: $$Excel-Macros$$ Re: calculating between two cells in two > different sheets. > To: excel-macros@googlegroups.com > Date: Friday, March 8, 2013, 10:20 PM > >

Re: $$Excel-Macros$$ calculating between two cells in two different sheets.

2013-03-08 Thread ravinder negi
Hi please find attached with solution.. I am not sure about the amount to  subtract, please advise again. if you want. --- On Fri, 3/8/13, Jaz wrote: From: Jaz Subject: $$Excel-Macros$$ calculating between two cells in two different sheets. To: excel-macros@googlegroups.com Date: Friday, March

Re: $$Excel-Macros$$ Re: calculating between two cells in two different sheets.

2013-03-08 Thread ravinder negi
there is no sheet --- On Fri, 3/8/13, Jaz wrote: From: Jaz Subject: $$Excel-Macros$$ Re: calculating between two cells in two different sheets. To: excel-macros@googlegroups.com Date: Friday, March 8, 2013, 10:20 PM Hi, I would appreciate very much if someone can help me on this. Thank you Ja

Re: $$Excel-Macros$$ Re: calculating between two cells in two different sheets.

2013-03-08 Thread Shrinivas Shevde
I already replied please check On Fri, Mar 8, 2013 at 10:20 PM, Jaz wrote: > Hi, > I would appreciate very much if someone can help me on this. > Thank you > Jaz > > On Thursday, March 7, 2013 1:00:57 PM UTC-8, Jaz wrote: >> >> Hello all, >> I am wondering if I can be helped in this. I have two

Re: $$Excel-Macros$$ calculating between two cells in two different sheets.

2013-03-08 Thread Shrinivas Shevde
Dear Jaz Please find attached file. Is it om Please let me know. Regards Shrinivas On Fri, Mar 8, 2013 at 2:30 AM, Jaz wrote: > Hello all, > I am wondering if I can be helped in this. I have two sheets 'Main' & > 'Consumed' B col. of both sheets have Lot ID. > A macro should be written to see

$$Excel-Macros$$ Re: calculating between two cells in two different sheets.

2013-03-08 Thread Jaz
Hi, I would appreciate very much if someone can help me on this. Thank you Jaz On Thursday, March 7, 2013 1:00:57 PM UTC-8, Jaz wrote: > > Hello all, > I am wondering if I can be helped in this. I have two sheets 'Main' & > 'Consumed' B col. of both sheets have Lot ID. > A macro should be writt

Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

2013-03-08 Thread Paul Schreiner
Sorry, I (quite often) work on several tasks at one time. In fact, about the only time my priorities remain unchanged is when I'm working early mornings (before others arrive) and on the weekends if I'm working from home. I've been pursuing an approach to accessing the data directly from Sharepo

$$Excel-Macros$$ Treeview in 2010 64Bit

2013-03-08 Thread Divaker Pandey
Hi Expert I have made an application that have tree view. it works on 2010 32Bit excel. but get problem in 2010 64Bit. is there any solution to rectify this issue? Regards. Divaker -- 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 officia

Re: $$Excel-Macros$$ Re: [XL-VBA Clinic] PDF to Excel

2013-03-08 Thread NOORAIN ANSARI
Please use.. Online converter to PDF to excel http://www.pdftoexcelonline.com/ 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://www.freepdfconvert.com/

Re: $$Excel-Macros$$ Re: [XL-VBA Clinic] PDF to Excel

2013-03-08 Thread Aamir Shahzad
Object Library is not reflecting as I have installed Adobe Acrobat 7.0 On Fri, Mar 8, 2013 at 4:27 PM, NOORAIN ANSARI wrote: > Dear Aamir, > > Please follow below steps before run the macro > > Goto Tools-Reference and check *Adobe Acrobat 9.0 Object Library* > > > > > > > On Fri, Mar 8, 2013 at

Re: $$Excel-Macros$$ Re: [XL-VBA Clinic] PDF to Excel

2013-03-08 Thread NOORAIN ANSARI
Dear Aamir, Please follow below steps before run the macro Goto Tools-Reference and check *Adobe Acrobat 9.0 Object Library* On Fri, Mar 8, 2013 at 4:47 PM, Aamir Shahzad wrote: > Dear Sir, error is reflecting. Please see > > On Fri, Mar 8, 2013 at 3:34 PM, NOORAIN ANSARI > wrote: > >> Dea

Re: $$Excel-Macros$$ Re: [XL-VBA Clinic] PDF to Excel

2013-03-08 Thread Aamir Shahzad
Dear Sir, error is reflecting. Please see On Fri, Mar 8, 2013 at 3:34 PM, NOORAIN ANSARI wrote: > Dear Aamir, > > Please Press Atl+F11, goto Module and paste it then press F5 to run macro. > > > > > > On Fri, Mar 8, 2013 at 2:37 PM, Aamir Shahzad wrote: > >> Thank you Sir, but kindly also tell me

Re: $$Excel-Macros$$ PDF to Excel

2013-03-08 Thread Aamir Shahzad
ok thanks David. I will try office 2013. On Fri, Mar 8, 2013 at 4:02 PM, David Grugeon wrote: > Yes. I understand the ability is built into Office 2013. > Alternatively you can use an external OCR program. there are several > around. It depends what features you want and what you want to pay.

Re: $$Excel-Macros$$ For one workbook to another workbook

2013-03-08 Thread Gaurav Garg
Dear Experts i have one sheet in this sheet there is a hyperlink , i want that it should be blink. it may possible through by VBA coding.can anyone help me for solve this problem . *GAURAV GARG* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

Re: $$Excel-Macros$$ For one workbook to another workbook

2013-03-08 Thread अनिल नारायण गवली
Dear Manjunath, Enclosed herewith the required file and check is it ok?? Warm Regards, Gawli Anil On Fri, Mar 8, 2013 at 4:32 PM, Manjunath Narayanappa < manjunath.narayana...@aon.co.uk> wrote: > Dear Experts, > > > > > > I have spreadsheet, in which I will be updating the data & i want same

$$Excel-Macros$$ For one workbook to another workbook

2013-03-08 Thread Manjunath Narayanappa
Dear Experts, I have spreadsheet, in which I will be updating the data & i want same information in new workbook Can it be done with help of macros Thanks Manjunath PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon's standard conditions as

Re: $$Excel-Macros$$ PDF to Excel

2013-03-08 Thread David Grugeon
Yes. I understand the ability is built into Office 2013. Alternatively you can use an external OCR program. there are several around. It depends what features you want and what you want to pay. Have a google for PDF to Excel convertor, or for OCR program. On 08/03/2013, Aamir Shahzad wrote: >

Re: $$Excel-Macros$$ help required.

2013-03-08 Thread अनिल नारायण गवली
Dear Rakesh, Pl find attached herewith FYI. Warm Regards, Gawli Anil On Fri, Mar 8, 2013 at 3:53 PM, Rakesh Sharma wrote: > can we arrange rearrange spellings in Excel column. > > like i want to arrange my name > > hsekar to rakesh > > > -- > ** > RA

Re: $$Excel-Macros$$ Re: [XL-VBA Clinic] PDF to Excel

2013-03-08 Thread NOORAIN ANSARI
Dear Aamir, Please Press Atl+F11, goto Module and paste it then press F5 to run macro. On Fri, Mar 8, 2013 at 2:37 PM, Aamir Shahzad wrote: > Thank you Sir, but kindly also tell me the steps how I use > > On Fri, Mar 8, 2013 at 12:50 PM, NOORAIN ANSARI > wrote: > >> Dear Shahzad, >> >>

Re: $$Excel-Macros$$ Re: [XL-VBA Clinic] PDF to Excel

2013-03-08 Thread Aamir Shahzad
Thank you Sir, but kindly also tell me the steps how I use On Fri, Mar 8, 2013 at 12:50 PM, NOORAIN ANSARI wrote: > Dear Shahzad, > > > Please try it.. > > > > Sub ImportPDFFileData() > 'Author: Steve Lipsman > 'Purpose: Import PDF File Data Into Excel Worksheet > 'Other Requirement(s): 'A