$$Excel-Macros$$ Urgent required PL/SQL Developer - LA, CA

2014-08-13 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com Position: Oracle PL/SQL DeveloperLocation: LA, CADuration: 6+ Months* *Need local candidates* JD: Oracle PL/SQL (with APEX understanding) Lead Requirement: •Relevant 6+ experience in SQL, PLSQL, Informatica & Good Unix Scripting. •Experience

$$Excel-Macros$$ Urgent required Java Developer - Seattle WA

2014-08-13 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com * *Position: Java DeveloperLocation: Seattle WA Duration: 6+ Months* JD: Most Imp---Exposure to GIT (Strongly advise to have) - Exposure to AWS Exposure in AWS and GIT would help. Please note: Must Have skills: - Core Java &

Re: $$Excel-Macros$$ Concat & lookup error

2014-08-13 Thread Paul Schreiner
I forgot to add: saving both files in the same format (.xls, .xlsx, .xlsb) would accomplish the same result.  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, At all the times you can, To all the

Re: $$Excel-Macros$$ Concat & lookup error

2014-08-13 Thread veeru h
Thank you very much sir On Wed, Aug 13, 2014 at 5:16 PM, Paul Schreiner wrote: > When you "select table array from another file i.e MData Select A&B Column" > You are selecting the entire column, which is defied along with the number > of rows in the file. > One file (in Excel97 Compatibility f

Re: $$Excel-Macros$$ Values from INDIRECT not staying after file closes

2014-08-13 Thread Paul Schreiner
It would take me an hour or more to put together an example that I HOPE would look like yours before I could even begin to test it. Then I'd have to hope it matches your conditions. If it DIDN'T respond the same way, I wouldn't know if it was because it was MY samples, or a problem with yours.  

Re: $$Excel-Macros$$ Concat & lookup error

2014-08-13 Thread Paul Schreiner
When you "select table array from another file i.e MData Select A&B Column" You are selecting the entire column, which is defied along with the number of rows in the file. One file (in Excel97 Compatibility format .xls) can only deal with 65000 rows. the other file has over 1,000,000 rows.   In yo

$$Excel-Macros$$ Re: VBA questions

2014-08-13 Thread chintz
thanks.. to Kapil Gupta and Pramod Singh for nice questions and answers. I have seen VBA Questions in Q4 transfer data in word but it will transfer word as excel.. is it possible to transfer as image. thanks and regards. Chintan On Sunday, August 3, 2014 11:51:07 PM UTC+5:30, kapil Gupta wro

$$Excel-Macros$$ Concat & lookup error

2014-08-13 Thread veeru h
Sir, I created a Macro, for entry purpose for Regular Work i recieve Reg Work File daily via email & send it to cosern sample data in attached file 1) inserted 1 column after G Column & concatenate G & H Column in to I its in Text then Converted to number. 2) again i insert another column

Re: $$Excel-Macros$$ Calculating working hours between 2 days with break time

2014-08-13 Thread Vaibhav Joshi
hi can you share a sample data in excel sheet. Thanks On Wed, Aug 13, 2014 at 1:57 PM, son nguyen wrote: > Dear Expert. > > I faced on problem while calculating working hours between 2 time (maybe > there is diff. day).Detail as below : > > A1 : Begin time. > B1 : Finish time > C1: Begin time

$$Excel-Macros$$ Calculating working hours between 2 days with break time

2014-08-13 Thread son nguyen
Dear Expert. I faced on problem while calculating working hours between 2 time (maybe there is diff. day).Detail as below : A1 : Begin time. B1 : Finish time C1: Begin time day : 8 AM D1 : Finish time day : 4:30 PM E1:Begin break time F1:Finish break time How to use any formula within excel -200

$$Excel-Macros$$ Re: .xls to .vcf vard format

2014-08-13 Thread Peter Parker
hiii i face this problem but i download excel to vcard converter like http://excel-to-vcard-converter.blogspot.in/ this convert all excel file to vcard and solve my problem On Sunday, October 7, 2012 9:24:44 PM UTC+5:30, V S Rawat g wrote: > > http://www.ehow.com/how_5708670_convert-